… ? 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 8, 2013 By 32 Comments
Vadim, can you confirm negative scalability with InnoDB compression and multi value inserts ?
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
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
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: 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…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… TEXT field was compressed which we felt indicated there would be a benefit derived from table compression. With the original InnoDB Antelope file… innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1 as the InnoDB system tablespace cannot be compressed, see this page for further details on how to enable compression…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… compress for the whole table. Among other things compression for data pages and uncompressed index pages can be significantly different. Q2: Does Innodb…_PAGE_COMPRESS_LIMIT (UNIV_PAGE_SIZE / 2) Q5: When Innodb free space becomes available for use within same object? When does Innodb make…
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…
