Chapter 28 INFORMATION_SCHEMA Tables

28.1 Introduction
28.2 INFORMATION_SCHEMA Table Reference
28.3 INFORMATION_SCHEMA General Tables
28.3.1 INFORMATION_SCHEMA General Table Reference
28.3.2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
28.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
28.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
28.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
28.3.6 The INFORMATION_SCHEMA COLLATIONS Table
28.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
28.3.8 The INFORMATION_SCHEMA COLUMNS Table
28.3.9 The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table
28.3.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
28.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
28.3.12 The INFORMATION_SCHEMA ENABLED_ROLES Table
28.3.13 The INFORMATION_SCHEMA ENGINES Table
28.3.14 The INFORMATION_SCHEMA EVENTS Table
28.3.15 The INFORMATION_SCHEMA FILES Table
28.3.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
28.3.17 The INFORMATION_SCHEMA KEYWORDS Table
28.3.18 The INFORMATION SCHEMA JSON_DUALITY_VIEWS Table
28.3.19 The INFORMATION SCHEMA JSON_DUALITY_VIEW_COLUMNS Table
28.3.20 The INFORMATION SCHEMA JSON_DUALITY_VIEW_LINKS Table
28.3.21 The INFORMATION SCHEMA JSON_DUALITY_VIEW_TABLES Table
28.3.22 The INFORMATION_SCHEMA LIBRARIES Table
28.3.23 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
28.3.24 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
28.3.25 The INFORMATION_SCHEMA PARAMETERS Table
28.3.26 The INFORMATION_SCHEMA PARTITIONS Table
28.3.27 The INFORMATION_SCHEMA PLUGINS Table
28.3.28 The INFORMATION_SCHEMA PROCESSLIST Table
28.3.29 The INFORMATION_SCHEMA PROFILING Table
28.3.30 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
28.3.31 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
28.3.32 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
28.3.33 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
28.3.34 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
28.3.35 The INFORMATION_SCHEMA ROUTINE_LIBRARIES Table
28.3.36 The INFORMATION_SCHEMA ROUTINES Table
28.3.37 The INFORMATION_SCHEMA SCHEMATA Table
28.3.38 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
28.3.39 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
28.3.40 The INFORMATION_SCHEMA STATISTICS Table
28.3.41 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
28.3.42 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
28.3.43 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
28.3.44 The INFORMATION_SCHEMA TABLES Table
28.3.45 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table
28.3.46 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table
28.3.47 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
28.3.48 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table
28.3.49 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
28.3.50 The INFORMATION_SCHEMA TRIGGERS Table
28.3.51 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
28.3.52 The INFORMATION_SCHEMA USER_PRIVILEGES Table
28.3.53 The INFORMATION_SCHEMA VIEWS Table
28.3.54 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
28.3.55 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
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
28.5 INFORMATION_SCHEMA Thread Pool Tables
28.5.1 INFORMATION_SCHEMA Thread Pool Table Reference
28.5.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
28.5.3 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
28.5.4 The INFORMATION_SCHEMA TP_THREAD_STATE Table
28.6 INFORMATION_SCHEMA Connection Control Tables
28.6.1 INFORMATION_SCHEMA Connection Control Table Reference
28.6.2 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
28.7 INFORMATION_SCHEMA MySQL Enterprise Firewall Plugin Tables
28.7.1 INFORMATION_SCHEMA Firewall Plugin Table Reference
28.7.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table
28.7.3 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
28.8 Extensions to SHOW Statements

INFORMATION_SCHEMA는 데이터베이스 메타데이터, 즉 데이터베이스나 테이블의 이름, 컬럼의 데이터 타입, 접근 권한과 같은 MySQL 서버에 대한 정보에 대한 액세스를 제공합니다. 이러한 정보에 대해 때때로 사용되는 다른 용어로는 데이터 딕셔너리와 시스템 카탈로그가 있습니다.