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 much [&]

https://www.percona.com/blog/2018/11/01/how-to-best-use-percona-server-column-compression-with-dictionary/