[wp-hackers] InnoDB Compression

Barry Abrahamson barry at automattic.com
Sat Sep 24 17:24:25 UTC 2011


Is anyone successfully using InnoDB compression[1] on their posts and/or comments tables and have any benchmarks/numbers they would like to share?  It only probably makes sense if you have more data than fits in RAM and your workload is I/O bound, otherwise the performance seems pretty terrible[2]


[1] http://dev.mysql.com/doc/refman/5.5/en/innodb-compression.html
[2] http://www.mysqlperformanceblog.com/2011/05/20/innodb-compression-woes/
Barry Abrahamson | Systems Wrangler | Automattic
Blog: http://barry.wordpress.com

More information about the wp-hackers mailing list