MySQL InnoDB Compression Dashboard
This dashboard helps you analyze the efficiency of InnoDB compression.
The level of zlib compression to use for InnoDB compressed tables and indexes.
The compression failure rate threshold for a table.
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.
Specifies whether images of re-compressed pages are written to the redo log. Re-compression may occur when changes are made to compressed data.
This section contains the following metrics:
- Compress Attempts
- Uncompressed Attempts
- Compression Success Ratio
Number of compression operations attempted. Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs out.
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
- CPU Core Usage for Uncompression
- Total Used Pages
- Total Free Pages
- Used Pages (Buffer Pool 0)
- Pages Free (Buffer Pool 0)
- Page updated 2021-01-11