SN#20815 ZFS & MySQL/InnoDB Compression Update
SYSTEM NEWS FOR SUN USERS
Vol 129 Issue 1 2008-11-08 Article 20815 from section "MySQL"
Why Don MacAskil Is Switching his ZFS Volume to LZJB
Don MacAskil set himself a three-fold task, which was to determine
the "best case" compression ration for InnoDB tables; the "worst
case" CPU usage for the workload; and to learn all of this by the
most quick and dirty means possible. He reports the results in his
blog. The result he obtained -- using gzip-9 for the first pass --
was a 2.12X compression ratio over a large and varied dataset.
Details at [url]http://sun.systemnews.com/g?A=20815[/url]
Have a custom version of 'System News for Sun Users' delivered to you
via email each week in text or HTML. Only the sections that you
select will be included in your copy of the news magazine. Subscribe at
Free 4-week trial is available.
(c) 2008 System News, Inc. [url]http://www.systemnews.com[/url]