[wp-hackers] InnoDB Compression

[Barry Abrahamson]

Howdy,

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]

References:

[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