0

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 know..

Advance Thanks,

user626206
  • 637
  • 4
  • 10
  • 13
  • what exactly should be compressed? – Tobias Apr 21 '11 at 11:10
  • You didn't mention anything about engine(s) you were planning to use. Two most popular engines (MyISAM and InnoDB) have already built-in compression control, and there's Archive engine that compresses the data. There are other engines (made for data warehousing) such as Infobright engine that also offer compression and excellent performance. – Michael J.V. Apr 21 '11 at 12:00
  • This isn't a good question. Please explain what type of compression you mean. What are you attempting to improve/compress? – James C Apr 21 '11 at 12:12
  • Hi @James C I meant for MySQL Database compression.Got it? – user626206 Apr 22 '11 at 04:57

2 Answers2

0

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.

WhiteFang34
  • 70,765
  • 18
  • 106
  • 111
0

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?

Community
  • 1
  • 1
Jaydee
  • 4,138
  • 1
  • 19
  • 20