Description:
Request for Enhancement to allow for compressed columns.
This request is for compressed columns similar to how MySQL's competition have been doing it for a long time now. It shouldn't be confused with table level compression which MySQL already does have.
For us this would be most helpful on InnoDB tables.
We need some columns to be able to be part of an index (and hence not compressed), while other columns can be compressed and hence cannot be part of an index.
It is important that this feature will work even if MySQL wasn't compiled in a special way such as using zlib.
INSERT and UPDATE statements will automatically compress the values in these columns, and likewise SELECT queries will automatically decompress them so that the queries remain the same. Obviously statements and queries involving these columns can perform slower than normal queries as these would just be intended for audit tables, or tables where the information is not commonly retrieved.
It would also be helpful if backup tools could access the already compressed data, so that they don't need to decompress the data, recompress it again, and then do the inverse on restore.
How to repeat:
This is a RFE and not a bug.
