Tag - Database Compression Methods

How To Best Use Percona Server Column Compression With Dictionary

Database Compression

Very often, database performance is affected by the inability to cache all the required data in memory. Disk IO, even when using the fastest devices, takes much more time than a memory access. With MySQL/InnoDB, the main memory cache is the InnoDB buffer pool. There are many strategies we can try to fit as […]

Read more

InnoDB Page Compression: the Good, the Bad and the Ugly

In this blog post, we’ll look at some of the facets of InnoDB page compression.
Somebody recently asked me about the best way to handle JSON data compression in MySQL. I took a quick look at InnoDB page compression and wanted to share my findings.
There is also some great material on this topic that was prepared and […]

Read more

Evaluating Database Compression Methods: Update

column compression

This blog post is an update to our last post discussing database compression methods, and how they stack up against each other. 
When Vadim and I wrote about Evaluating Database Compression Methods last month, we claimed that evaluating database compression algorithms was easy these days because there are ready-to-use benchmark suites such as lzbench.
As easy […]

Read more

Evaluating Database Compression Methods

column compression

NOTE:  This blog post contains some mistakes in data. While many of our conclusions are still valid, we’ve updated the evaluation in a new blog post. Please use that post in conjunction with this one.
Vadim Tkachenko and I have been working with Fractal Tree® storage engines (Fractal Tree engines are available in Percona […]

Read more