InnoDB System Variables 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. 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” . Command-Line Format --innodb-compression-failure- threshold-pct=# System Variable innodb_compression_failure_threshold_pct Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 5 Minimum Value 0 Command-Line Format --innodb-compress-debug=value System Variable innodb_compress_debug Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Enumeration Default Value none Valid Values none zlib lz4 lz4hc Type Integer Default Value 0 Minimum Value 0 Maximum Value 1000 • innodb_compress_debug • innodb_compression_failure_threshold_pct 3232