Is there any MySQL Compression plugin or tool available?

we undergoing performance based testing on MySQL,so we are seeking for MySQL compression tool for that purpose.If anyone came to acquainted about it please let me 开发者_JS百科know..

Advance Thanks,

---

Two possible answers:

1 For compressed data storage, you may want to look at MySQLs Archive storage engine

http://dev.mysql.com/tech-resources/articles/storage-engine.html

2 The compressed protocol can in some cases speed up communication between client and server

When should I use MySQL compressed protocol?

---

MySQL has built-in COMPRESS and UNCOMPRESS functions. That'd require you to change code and use VARBINARY or BLOB columns however. As well it'd only really be of value for large columns. I'm not otherwise aware of a plugin or tool to compress a whole MySQL database. You'll probably find better luck with file system compression like ZFS that you can use under MySQL. See A look at MySQL on ZFS.