28.4 INFORMATION_SCHEMA InnoDB Tables

28.4 INFORMATION_SCHEMA InnoDB Tables

28.4.1 INFORMATION_SCHEMA InnoDB Table Reference
28.4.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
28.4.3 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
28.4.4 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
28.4.5 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table
28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
28.4.7 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
28.4.8 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table
28.4.10 The INFORMATION_SCHEMA INNODB_DATAFILES Table
28.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table
28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table
28.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table
28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
28.4.16 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
28.4.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
28.4.19 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table
28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table
28.4.22 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table
28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table
28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table
28.4.25 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table
28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View
28.4.27 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
28.4.28 The INFORMATION_SCHEMA INNODB_TRX Table
28.4.29 The INFORMATION_SCHEMA INNODB_VIRTUAL Table

이 섹션은 INFORMATION_SCHEMA``InnoDB 테이블에 대한 테이블 정의를 제공합니다. 관련 정보와 예제는 Section 17.15, “InnoDB INFORMATION_SCHEMA Tables”를 참조하십시오.

INFORMATION_SCHEMA``InnoDB 테이블은 진행 중인 InnoDB activity를 모니터링하고, 문제가 되기 전에 비효율성을 감지하거나, 성능 및 용량 문제를 트러블슈팅하는 데 사용할 수 있습니다. 데이터베이스가 점점 더 크고 바빠지고 하드웨어 용량의 한계에 다다르게 되면, 데이터베이스가 원활하게 작동하도록 이러한 측면을 모니터링하고 튜닝합니다.