Page compression is available only if innodb-file-format=Barracuda and innodb-file-per-table=1.
Page compression can be used on any file system but is most beneficial on SSDs and Non-Volatile Memory (NVM) devices like FusionIO atomic-series http://www.fusionio.com/products/atomic-series/.
I setup page compression with the following directives:
create table statement:
I load data from the original table (original size: 32G). According to statistics, compression occurs:
That's 26G saved by compression, according to the stats.
But the resulting .ibd tablespace on disk, and in SHOW TABLE STATUS is exactly the same as the original, uncompressed ibd tablespace (32G).
NB. I have tried with lz4 and that hasn't worked either.