Mysql table compression support?

[imreACTmd]

From 5.5 InnoDB has table compression support. In 5.6.7 Facebook significantly improved this support.
http://dev.mysql.com/doc/refman/5.5/en/innodb-compression.html

Compression is transparent, it requires two general settings for the server and and one additional setting for each table at creation.

Is anyone interested in this? Should I send in a patch with a separate schema.sql for compressed tables?

[mcholste]

Interesting, I hadn't seen that. It would be relatively easy to get a great
comparison by taking one of the existing tables, do SHOW CREATE TABLE,
alter it to be InnoDB and ROW_FORMAT=COMPRESSED, create the table, then do
SELECT * FROM source INTO new (or however you want to do it), then compare
the differences in INFORMATION_SCHEMA.TABLES to see the savings.
Performance will almost certainly not be a factor because all writes are
batched, and reads are usually infrequent.

On Mon, Sep 22, 2014 at 9:18 AM, imreACTmd notifications@github.com wrote:

From 5.5 InnoDB has table compression support. In 5.6.7 Facebook
significantly improved this support.
http://dev.mysql.com/doc/refman/5.5/en/innodb-compression.html

Compression is transparent, it requires two general settings for the
server and and one additional setting for each table at creation.

Is anyone interested in this? Should I send in a patch with a separate
schema.sql for compressed tables?

—
Reply to this email directly or view it on GitHub
#1.

[mcholste]

Would you care to do any tests with this and report the results? Otherwise, I will close this for now.

[imreACTmd]

I don't have time for it, sorry :(