Is mysql automatically compressing the database?

Question

My table entry was pretty long , around 10000 characters , so i'm wondering if i need to compress that myself , e.g use gzip library , before inserting to mysql ?

Current i'm using MyISAM database format.

Thanks !

Answer 1

InnoDB support data compression:

http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-compression-usage.html

Answer 2

you can use the attributes ROW_FORMAT=COMPRESSED, KEY_BLOCK_SIZE, or both in the CREATE TABLE and ALTER TABLE statements to enable table compression. Depending on the combination of option values, InnoDB attempts to compress each page

For more details go through below link:

Enabling Compression for a Table