InnoDB Enhancements Information

This feature adds the XTRADB_ENHANCEMENTS table in the INFORMATION_SCHEMA. The table contains information about enhancements installed.

Shows current enhancements applied to the InnoDB-plugin.

This table no longer exists, beginning in release 5.1.8-20.0.

mysql> select * from information_schema.XTRADB_ENHANCEMENTS;
+-----------------------------+------------------------------------+----------------------------------------------------------------------+-----------------------------------------------------------------------------+
| name                        | description                        | comment                                                              | link                                                                        |
+-----------------------------+------------------------------------+----------------------------------------------------------------------+-----------------------------------------------------------------------------+
| xtradb_show_enhancements    | I_S.XTRADB_ENHANCEMENTS            |                                                                      | http://www.percona.com/docs/wiki/percona-xtradb:xtradb_show_enhancements    | 
| innodb_show_status          | Improvements to SHOW INNODB STATUS | Memory information and lock info fixes                               | http://www.percona.com/docs/wiki/percona-xtradb:innodb_show_status          | 
| innodb_io                   | Improvements to InnoDB IO          |                                                                      | http://www.percona.com/docs/wiki/percona-xtradb:innodb_io                   | 
| innodb_rw_lock              | InnoDB RW-lock fixes               | Useful for 8+ cores SMP systems                                      | http://www.percona.com/docs/wiki/percona-xtradb:innodb_rw_lock              | 
| innodb_opt_lru_count        | Fix of buffer_pool mutex           | Decreases contention on buffer_pool mutex on LRU operations          | http://www.percona.com/docs/wiki/percona-xtradb:innodb_opt_lru_count        | 
| innodb_buffer_pool_pages    | Information of buffer pool content |                                                                      | http://www.percona.com/docs/wiki/percona-xtradb:innodb_buffer_pool_pages    | 
| innodb_split_buf_pool_mutex | More fix of buffer_pool mutex      | Spliting buf_pool_mutex and optimizing based on innodb_opt_lru_count | http://www.percona.com/docs/wiki/percona-xtradb:innodb_split_buf_pool_mutex | 
+-----------------------------+------------------------------------+----------------------------------------------------------------------+-----------------------------------------------------------------------------+
7 rows in set (0.00 sec)