View Single Post
  #3   (View Single Post)  
Old 28th November 2008
phoenix's Avatar
phoenix phoenix is offline
Risen from the ashes
Join Date: May 2008
Posts: 696

Originally Posted by phoenix View Post
lzjb requires the least amount of CPU, but only gives decent compression (don't expect more than 2:1). Use this for locations that you want to compress, but that are accessed frequently.
Further reading shows lzjb may be the better for MySQL using InnoDB.

Whatever you configure the record size in MySQL is what you use for the record size in ZFS.
The comments on the linked page, and the MySQL dev centre, show this to be 16 KB.

Considering how often MySQL data is accessed, you shouldn't compress it. You don't want anything to get in the way of your data I/O.
I tentatively sit corrected. At least for that one benchmark setup, lzjb compression saves you space without sacrificing performance.

Help for FreeBSD: Handbook, FAQ, man pages, mailing lists.
Reply With Quote