content_image/845050.jpg content_image/845051.jpg content_image/845052.jpg
<img src='content_image/845050.jpg'>

• innodb_cmp_per_index_enabled 

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

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. 

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” . 

• innodb_commit_concurrency 

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

