- 20 INFORMATION_SCHEMA Tables
- 20.1 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 20.2 The INFORMATION_SCHEMA COLLATIONS Table
- 20.3 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 20.4 The INFORMATION_SCHEMA COLUMNS Table
- 20.5 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 20.6 The INFORMATION_SCHEMA ENGINES Table
- 20.7 The INFORMATION_SCHEMA EVENTS Table
- 20.8 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
- 20.9 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
- 20.10 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 20.11 The INFORMATION_SCHEMA PARAMETERS Table
- 20.12 The INFORMATION_SCHEMA PARTITIONS Table
- 20.13 The INFORMATION_SCHEMA PLUGINS Table
- 20.14 The INFORMATION_SCHEMA PROCESSLIST Table
- 20.15 The INFORMATION_SCHEMA PROFILING Table
- 20.16 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
- 20.17 The INFORMATION_SCHEMA ROUTINES Table
- 20.18 The INFORMATION_SCHEMA SCHEMATA Table
- 20.19 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 20.20 The INFORMATION_SCHEMA STATISTICS Table
- 20.21 The INFORMATION_SCHEMA TABLES Table
- 20.22 The INFORMATION_SCHEMA TABLESPACES Table
- 20.23 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 20.24 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 20.25 The INFORMATION_SCHEMA TRIGGERS Table
- 20.26 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 20.27 The INFORMATION_SCHEMA VIEWS Table
- 20.28 INFORMATION_SCHEMA Tables for InnoDB
- 20.28.1 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
- 20.28.2 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
- 20.28.3 The INFORMATION_SCHEMA INNODB_TRX Table
- 20.28.4 The INFORMATION_SCHEMA INNODB_LOCKS Table
- 20.28.5 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
- 20.28.6 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
- 20.28.7 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
- 20.28.8 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
- 20.29 INFORMATION_SCHEMA Tables for MySQL Cluster
- 20.30 Thread Pool INFORMATION_SCHEMA Tables
- 20.31 Extensions to SHOW Statements
[+/-]
- 20.28.1. The
INFORMATION_SCHEMA INNODB_CMPandINNODB_CMP_RESETTables - 20.28.2. The
INFORMATION_SCHEMA INNODB_CMPMEMandINNODB_CMPMEM_RESETTables - 20.28.3. The
INFORMATION_SCHEMA INNODB_TRXTable - 20.28.4. The
INFORMATION_SCHEMA INNODB_LOCKSTable - 20.28.5. The
INFORMATION_SCHEMA INNODB_LOCK_WAITSTable - 20.28.6. The
INFORMATION_SCHEMA INNODB_BUFFER_PAGETable - 20.28.7. The
INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRUTable - 20.28.8. The
INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATSTable
The InnoDB tables related to the
InnoDB storage engine help you to monitor ongoing
InnoDB activity, to detect inefficiencies before
they turn into issues, or to troubleshoot performance and capacity
issues that do occur. As your database becomes bigger and busier,
running up against the limits of your hardware capacity, you monitor
and tune these aspects to keep the database running smoothly. The
monitoring information deals with:
InnoDBtable compression, a feature whose use depends on a balance between I/O reduction, CPU usage, buffer pool management, and how much compression is possible for your data.Transactions and locks, features that balance high performance for a single operation, against the ability to run multiple operations concurrently. (Transactions are the high-level, user-visible aspect of concurrency. Locks are the low-level mechanism that transactions use to avoid reading or writing unreliable data.)
User Comments
Add your own comment.