InnoDB/XtraDB Page Compression

[kulasitord]

Anybody tried this?

"Page compression is an alternative way to compress your tables which is different (but similar) to the InnoDB COMPRESSED storage format. In page compression, only uncompressed pages are stored in the buffer pool. This approach differs significantly from legacy InnoDB compressed tables using row_format=compressed, where both uncompressed and compressed pages can be in the buffer pool. In page compression, pages are actually compressed just before being written to the filespace."

"Page compression can be used on any file system but is most beneficial on SSDs..."
--Source MariaDB KB

Here are the supported formats


Here the original source

 

[rdn]

But not available on MariaDB 10.0.x

 

[Xon]

Need to wait to MariaDB 10.1.x or using custom patches sadly.

I'm looking forward to it, as the existing MySQL compression for tables offers very decent space savings but comes with performance overheads.

 

[kulasitord]

"TPC-C is more complex than previous OLTP benchmarks such as TPC-A because of its multiple transaction types, more complex database and overall execution structure. TPC-C involves a mix of five concurrent transactions of different types and complexity either executed on-line or queued for deferred execution. The database is comprised of nine types of tables with a wide range of record and population sizes. TPC-C is measured in transactions per minute (tpmC). In below Figure 5 MySQL compression actually means InnoDB compressed tables (i.e. ROW_FORMAT=COMPRESSED)."



Nice benchmark here.

But for that you may need this.





Some ray of sunshine though...