MySQL InnoDB Compression Details¶

!image

This dashboard helps you analyze the efficiency of InnoDB compression.

Compression level and failure rate threshold¶

InnoDB Compression Level: The level of zlib compression to use for InnoDB compressed tables and indexes.
InnoDB Compression Failure Threshold: The compression failure rate threshold for a table.
Compression Failure Rate Threshold: The maximum percentage that can be reserved as free space within each compressed page, allowing room to reorganize the data and modification log within the page when a compressed table or index is updated and the data might be recompressed.
Write Pages to the Redo Log: Specifies whether images of re-compressed pages are written to the redo log. Re-compression may occur when changes are made to compressed data.

Compress Attempts: Number of compression operations attempted. Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs out.
Uncompressed Attempts: Number of uncompression operations performed. Compressed InnoDB pages are uncompressed whenever compression fails, or the first time a compressed page is accessed in the buffer pool and the uncompressed page does not exist.

CPU Core Usage for Compression: Shows the time in seconds spent by InnoDB Compression operations.
CPU Core Usage for Uncompression: Shows the time in seconds spent by InnoDB Uncompression operations.

Total Used Pages: Shows the total amount of used compressed pages into the InnoDB Buffer Pool split by page size.
Total Free Pages: Shows the total amount of free compressed pages into the InnoDB Buffer Pool split by page size.