Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET TablesINFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET
TablesINFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET
TablesINFORMATION_SCHEMA INNODB_TRX TableINFORMATION_SCHEMA INNODB_LOCKS TableINFORMATION_SCHEMA INNODB_LOCK_WAITS TableINFORMATION_SCHEMA INNODB_SYS_TABLES TableINFORMATION_SCHEMA INNODB_SYS_INDEXES TableINFORMATION_SCHEMA INNODB_SYS_COLUMNS TableINFORMATION_SCHEMA INNODB_SYS_FIELDS TableINFORMATION_SCHEMA INNODB_SYS_FOREIGN TableINFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS TableINFORMATION_SCHEMA INNODB_SYS_TABLESTATS ViewINFORMATION_SCHEMA INNODB_SYS_DATAFILES TableINFORMATION_SCHEMA INNODB_SYS_TABLESPACES TableINFORMATION_SCHEMA INNODB_BUFFER_PAGE TableINFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU TableINFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS TableINFORMATION_SCHEMA INNODB_METRICS TableINFORMATION_SCHEMA INNODB_FT_CONFIG TableINFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORDTableINFORMATION_SCHEMA INNODB_FT_INDEX_TABLE TableINFORMATION_SCHEMA INNODB_FT_INDEX_CACHE TableINFORMATION_SCHEMA INNODB_FT_DELETED TableINFORMATION_SCHEMA INNODB_FT_BEING_DELETED TableINFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table The InnoDB tables related to the InnoDB storage engine
serve two purposes:
You can 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:
InnoDB table 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.)
You can extract information about schema objects managed by InnoDB,
using the INNODB_SYS_* tables. This information comes from the InnoDB data dictionary, which cannot be queried directly like regular
InnoDB tables. Traditionally, you would get this type of information using
the techniques from Section
14.2.4.4, "SHOW ENGINE INNODB STATUS and the InnoDB
Monitors", setting up InnoDB monitors and parsing the output from
the SHOW ENGINE INNODB STATUS command. The InnoDB interface offers a simpler, familiar technique to access this
data.