Gregory, I am comparing workload that I am interested in. I am not going to use InnoDB compression in production, as it introduces more problems than it solves. So this comparison is relevant for me.
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
Then why comparing ompressed tables and uncompressed table on size ? That’s clearly not relevant ! Could you redo the same test with innodb compression ? Thanks
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
In your my.cnf conf I don’t see barracuda file format and did you create your table using row_format = compressed with InnoDB which enables tablespace compression ?
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… ? Add my vote on compression as we are facing more and more big data challenges where innoDB and TokuDB will have to…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
Gregory, I do not use compression for InnoDB.
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
Strikes me as odd that they actually take a previous InnoDB checkpoint benchmark from you as a reference for having outstanding… would be highly interesting to see the performance with lzma compression.
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
InnoDB compression is getting some traction, and I see quite contradictory opinions. Someone has successful deployments in productions, and someone says that compression… compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
…’ as compressed field, doing compress()/uncompress() to store/restore. To test InnoDB compression I use only uncompressed text, though I tested compression on compress()-ed data… from index compression. For test I use dump created with mysqldump, final size 30286M. To create InnoDB compression table I use ENGINE=InnoDB KEY…
Post: InnoDB page sizes: plans and ideas
April 21, 2011 By 9 Comments
… needed ? For InnoDB compression. Right now if you use 16K and trying to compress, the only good choice is to compress to 8K pages (which gives you only 2:1 compress ratio), and you rarely will be able to compress to…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… Innodb table, while data pages and pages for different indexes may well have very different compression ratio. As Innodb indexes are not prefix compressed they have very good compression potential. I also would like to see some stats about compressed…
