content_image/661332.jpg content_image/661333.jpg content_image/661334.jpg
<img src='content_image/661332.jpg'>

Defines the compression failure rate threshold for a table, as a percentage, at which point MySQL begins adding padding within compressed pages to avoid expensive compression failures. When this threshold is passed, MySQL begins to leave additional free space within each new compressed page, dynamically adjusting the amount of free space up to the percentage of page size specified by innodb_compression_pad_pct_max . A value of zero disables the mechanism that monitors compression efficiency and dynamically adjusts the padding amount. 

For more information, see Section 15.9.1.6, “Compression for OLTP Workloads” . 

• innodb_compression_level 

<img src='content_image/661333.jpg'>

Specifies the level of zlib compression to use for InnoDB  compressed tables and indexes. A higher value lets you fit more data onto a storage device, at the expense of more CPU overhead during compression. A lower value lets you reduce CPU overhead when storage space is not critical, or you expect the data is not especially compressible. 

For more information, see Section 15.9.1.6, “Compression for OLTP Workloads” . 

• innodb_compression_pad_pct_max 

<img src='content_image/661334.jpg'>

Specifies 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. Only applies when 

