MySQL 5.7发行说明
目录
- 24.1介绍
- 24.2 Information_schema表参考
- 24.3 INFORMATION_SCHEMA通用表
-
- 24.3.1 Information_schema常规表参考
- 24.3.2 INFORMATION_SCHEMA CHARACTER_SETS表
- 24.3.3 INFORMATION_SCHEMA COLLATIONS表
- 24.3.4 INFORMATION_SCHEMA collation_character_set_适用性表
- 24.3.5 INFORMATION_SCHEMA列表
- 24.3.6 Information_schema column_privileges表
- 24.3.7 Information_schema引擎表
- 24.3.8 The INFORMATION_SCHEMA EVENTS Table信息表
- 24.3.9信息_schema文件表
- 24.3.10 INFORMATION_SCHEMA GLOBAL_STATUS和SESSION_STATUS表
- 24.3.11信息_schema global_variables和session_variables表
- 24.3.12 Information_schema key_column_usage表
- 24.3.13 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
- 24.3.14 Information_schema Optimizer_Trace表
- 24.3.15 INFORMATION_SCHEMA参数表
- 24.3.16 Information_schema分区表
- 24.3.17 Information_schema插件表
- 24.3.18 The INFORMATION_SCHEMA PROCESSLIST Table
- 24.3.19 INFORMATION_SCHEMA剖析表
- 24.3.20 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS表
- 24.3.21 Information_schema例程表
- 24.3.22 The INFORMATION_SCHEMA schema Table
- 24.3.23 Information_schema schema_privileges表
- 24.3.24 INFORMATION_SCHEMA统计表
- 24.3.25 The INFORMATION_SCHEMA TABLES表
- 24.3.26 The INFORMATION_SCHEMA TABLESPACES表
- 24.3.27 Information_schema table_constraints表
- 24.3.28 Information_schema table_privileges表
- 24.3.29信息_schema触发表
- 24.3.30 Information_schema user_privileges表
- 24.3.31 Information_schema视图表
- 24.4 INFORMATION_SCHEMA InnoDB表
-
- 24.4.1 INFORMATION_SCHEMA INNODB表参考
- 24.4.2信息架构INNODB_BUFFER_PAGE表
- 24.4.3 Information_schema Innodb_buffer_page_lru表
- 24.4.4 INNODB_BUFFER_POOL_STATS表信息
- 24.4.5 Information_schema Innodb_cmp和Innodb_cmp_reset表
- 24.4.6 INNODB_CMPMEM和INNODB_CMPMEM_RESET表的信息模式
- 24.4.7 INNODB_CMP_PER_INDEX和INNODB_CMP_PER_INDEX_RESET表信息
- 24.4.8 INNODB_FT_BEING_DELETED表信息
- 24.4.9信息_schemaInnodb_ft_config表
- 24.4.10 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD表
- 24.4.11 The INFORMATION_SCHEMA INNODB_FT_DELETED Table .输出说明
- 24.4.12 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
- 24.4.13 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE表
- 24.4.14 The INFORMATION_SCHEMA INNODB_LOCKS Table详细信息
- 24.4.15 INNODB_LOCK_WAITS表信息
- 24.4.16 Information_schema Innodb_metrics表
- 24.4.17 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table详细信息
- 24.4.18信息_schema innodb_sys_datafiles表
- 24.4.19 INFORMATION_SCHEMA INNODB_SYS_FIELDS表
- 24.4.20 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN表
- 24.4.21 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS表
- 24.4.22 The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table信息表
- 24.4.23信息_schemaInnodb_sys_tables表
- 24.4.24 Information_schemaInnodb_sys_tablespaces表
- 24.4.25信息架构INNODB_SYS_TABLESTATS视图
- 24.4.26信息_schemaInnodb_sys_virtual表
- 24.4.27信息_schemaInnodb_temp_table_info表
- 24.4.28 The INFORMATION_SCHEMA INNODB_TRX Table
- 24.5 INFORMATION_SCHEMA线程池表
- 24.6 Information_schema连接控制表
- 24.7 Information_schema MySQL Enterprise防火墙表
- 24.8 SHOW语句扩展名
Information_Schema.
提供对数据库的访问元数据,有关MySQL Server的信息,例如数据库或表的名称,列的数据类型或访问权限。有时用于此信息的其他术语数据词典和系统目录。