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
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 […]
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 […]
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 […]