MYSQL's InnoDb storage engine supports compression. However it seems to be only compressing each row separately... which ignores redundancy between rows...
Can multi-row compression be enabled with mysql?
My raw table size is 1.2 GB... however the optimal per-row entropy (pen and paper) would give about .6 GB which is what happens when I enable innodb compression. However if I mysqldump|bzip2
then I get a bzip'ed file as small as 94 MB. This is a factor of 6.3 improvement! How can I enable multi-row compression?