Explaining the implementation of the InnoDB compression
The InnoDB compression supports different compression levels. The innodb_compression_level server variable is an integer value in the range between 0 and 9. A higher value represents a more efficient, but slower, compression level. The default value is 6. This variable is dynamic and can be changed at any time.
As mentioned previously, when an index entry is read from the disk, it is written into the buffer pool in both its compressed and uncompressed forms. InnoDB tries to avoid performing a huge number of compression and uncompression operations in several ways. For example, it can modify a compressed page without compressing the new data until the page needs to be flushed onto the disk. ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
