I am using TT-RSS with MySQL with TokuDB engine instead of InnoDB engine. But TT-RSS does not allow this in his sanity check (Link to source /include/sanity_check.php#L34) . So I changed that hard coded now in:
table_schema = ? AND table_name LIKE 'ttrss_%' AND engine NOT IN ('InnoDB','TokuDB')");
Which works fine for me.
I use TokuDB now for years as a drop in replacement for InnoDB. Link to TokuDB Wiki (which I am not allowed to post). This saves about 10 times on disk while speeding up 4 times compared to InooDB.
So it would be nice that we could have a setting where we have a list of supported engines? Maybe there are more engines supported that you do not know.
TokuDB has been deprecated by its upstream maintainer. It is disabled from MariaDB 10.5 and has been been removed in MariaDB 10.6 - MDEV-19780. We recommend MyRocks as a long-term migration path.
This is the first time TheYOSH has posted — let’s welcome them to our community!
Oh. Hey welcome.
This saves about 10 times on disk while speeding up 4 times compared to InooDB.
Have you compared mysql storage space to postgresql? Have you explored compression options in postgresql? Comparing toku to inno isn’t giving you the full picture.
You can continue with mysql but, as indicated by the author already, mysql is “tolerated” at best in tt-rss.
I know I’m risking a ban (hi fox!) but I sure wish this forum had some internet points or gold or whatever. You most definitely earned it, that was fantastic.
I feel a bit hostile environment, and no! I will NOT ask for myrocks… I am pretty capable of patching code as I proposed to make a pull request. I only have to change 1 line.
And TokuDB it is a drop in replacement so that means for you nothing to test. It behaves exactly as InnoDB. But it is clear… you are not a MySQL fan…
Also, I can confirm Postgress uses more space!! About 3 times MORE!. So TokuDB is better in compression… oh wait… that is not fair… Postgress DOES NOT HAVE compression… hmm, that sounds like a good system…
So, I wish you all biased postgress people fun on bashing new people… Luckily I do have some manners…
I was surprise by this affirmation, but postgres have builtin compression :
The compression technique used for either in-line or out-of-line compressed data is a fairly simple and very fast member of the LZ family of compression techniques. See src/common/pg_lzcompress.c for the details.
Probably for the better. (When my ‘home’ forum trialed Discourse (before getting banned from using it by Jeff), that was one of the aspects we, err, broke…)
He even offered money if needed to get us off it. (We didn’t take it.)
TLDR: We adopted Discourse to get us off Community Server, even though it was in “Beta.” Alpha would better describe it at that point in time. Since ours is a programmer/software oriented forum, we did some rather rudimentary QA on it and found it lacking.
Feedback, while abrasive, was constructive.
He didn’t take to the constructive criticism, nor the increasing abrasiveness that came about as a result of his intransigence.
We’re using NodeBB now. Their devs were rather more accepting of us (we tend not to bother them much now - because there’s nothing to bother them much with.)
(i’m fully aware that i should be the last person to have opinions about internet communities, if only based on this forums pervasive reputation as a “toxic shithole”)
anyway, i strongly believe that people should be forced to participate in a discussion, even if they have nothing much to add other than agreeing or disagreeing with someone else.
when you have a silent never posting majority moderating content based on whatever criteria, usually it’s some kind of group-specific consensus, opinions which go against this consensus are punished, discourse is stifled and community suffers massively as a result.
and when you add some kind of global social score on top of this already flawed model, you get something that’s even worse, i.e. sites like reddit[1], where almost every discussion is creepily dominated by subreddit-specific groupthink and every actual post radiates fakeness and desire to conform, as to not have this imaginary social score impacted.
someone quoting you with “lol” is much more meaningful than a +1 (or -1) appearing near your post. it simply weighs more because it’s closer to an actual human interaction.
i have fully understood why reddit discussions are the way they are when at some point i managed to post something contrarian somewhere (imagine that, right) and - while i was being actively downvoted - the system also started enforcing delays between my posts, thus preventing me from defending my opinion (whether right or wrong, it doesn’t matter) so that group consensus is maintained.
