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.

Statistic of compression operations

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

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.

Buffer Pool Total

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.
  • Page updated 2021-01-13

Contents

Previous topic

MySQL Command/Handler Counters Compare

Next topic

MySQL InnoDB Details

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.