content_image/802061.jpg content_image/802060.jpg content_image/802059.jpg
<img src='content_image/802061.jpg'>

The number of threads that can commit at the same time. A value of 0 (the default) permits any number of transactions to commit simultaneously. 

The value of innodb_commit_concurrency  cannot be changed at runtime from zero to nonzero or vice versa. The value can be changed from one nonzero value to another. 

• innodb_compress_debug 

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

Compresses all tables using a specified compression algorithm without having to define a COMPRESSION attribute for each table. This option is only available if debugging support is compiled in using the WITH_DEBUG CMake  option. 

For related information, see Section 15.9.2, “InnoDB Page Compression” . 

• innodb_compression_failure_threshold_pct 

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

