1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

InnoDB/XtraDB Page Compression

Discussion in 'Server Configuration and Hosting' started by bortrenamo, Apr 18, 2015.

  1. bortrenamo

    bortrenamo Member

    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
    Capture.PNG

    Here the original source
     
    Marcus likes this.
  2. RoldanLT

    RoldanLT Well-Known Member

    But not available on MariaDB 10.0.x :rolleyes:
     
  3. Xon

    Xon Well-Known Member

    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.
     
  4. bortrenamo

    bortrenamo Member

    "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)."

    Capture.PNG

    Nice benchmark here.

    But for that you may need this.

    sd-drives.png

    Capture2.PNG

    Some ray of sunshine though...

    Capture3.PNG
     

    Attached Files:

Share This Page