InnoDB System Variables • innodb_cmp_per_index_enabled • innodb_commit_concurrency For more information, see Section 26.4.8, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables” , and Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime” . Enables per-index compression-related statistics in the INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX  table. Because these statistics can be expensive to gather, only enable this option on development, test, or replica instances during performance tuning related to  InnoDB  compressed tables. Value Generated checksum (when writing) Permitted checksums (when reading) crc32 A checksum calculated using the crc32  algorithm, possibly done with a hardware assist. Any of the checksums generated by  none ,  innodb , or  crc32 . strict_none A constant number Any of the checksums generated by  none ,  innodb , or  crc32 . InnoDB  prints an error message if a valid but non-matching checksum is encountered. strict_innodb A checksum calculated in software, using the original algorithm from  InnoDB . Any of the checksums generated by  none ,  innodb , or  crc32 . InnoDB  prints an error message if a valid but non-matching checksum is encountered. strict_crc32 A checksum calculated using the crc32  algorithm, possibly done with a hardware assist. Any of the checksums generated by  none ,  innodb , or  crc32 . InnoDB  prints an error message if a valid but non-matching checksum is encountered. Command-Line Format --innodb-cmp-per-index-enabled[={OFF| ON}] System Variable innodb_cmp_per_index_enabled Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF Command-Line Format --innodb-commit-concurrency=# System Variable innodb_commit_concurrency Scope Global Dynamic Yes SET_VAR  Hint Applies No 3231