MySQL信息模式

目录

前言及法律声明

1 INFORMATION_SCHEMA表

2介绍

3 INFORMATION_SCHEMA表参考

4 INFORMATION_SCHEMA通用表

4.1 INFORMATION_SCHEMA通用表参考

4.2信息模式管理角色授权表

INFORMATION_SCHEMA APPLICABLE_ROLES表

4.4 INFORMATION_SCHEMA CHARACTER_SETS表

信息模式检查约束表

信息化模式整理表

信息-模式排序-字符- set_适用性表

4.8 INFORMATION_SCHEMA列表

4.9信息模式列扩展表

4.10 INFORMATION_SCHEMA COLUMN_PRIVILEGES表

4.11 INFORMATION_SCHEMA COLUMN_STATISTICS表

4.12 INFORMATION_SCHEMA ENABLED_ROLES表

4.13 INFORMATION_SCHEMA引擎表

4.14 INFORMATION_SCHEMA事件表

4.15 INFORMATION_SCHEMA FILES表

4.16 INFORMATION_SCHEMA KEY_COLUMN_USAGE表

4.17 INFORMATION_SCHEMA KEYWORDS表

4.18 INFORMATION_SCHEMA ndb_transid_mysql_connection_map表

4.19 INFORMATION_SCHEMA OPTIMIZER_TRACE表

4.20 INFORMATION_SCHEMA参数表

4.21 INFORMATION_SCHEMA分区表

4.22 INFORMATION_SCHEMA插件表

4.23 INFORMATION_SCHEMA PROCESSLIST表

4.24 INFORMATION_SCHEMA概要表

4.25 INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS表

4.26 INFORMATION_SCHEMA RESOURCE_GROUPS表

4.27信息模式ROLE_COLUMN_GRANTS表

4.28 INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS表

4.29 INFORMATION_SCHEMA ROLE_TABLE_GRANTS表

4.30 INFORMATION_SCHEMA例程表

4.31 INFORMATION_SCHEMA schema表

4.32 INFORMATION_SCHEMA SCHEMATA_EXTENSIONS表

4.33 INFORMATION_SCHEMA SCHEMA_PRIVILEGES表

4.34 INFORMATION_SCHEMA统计表

4.35 INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS表

4.36 INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS表

4.37 INFORMATION_SCHEMA ST_UNITS_OF_MEASURE表

4.38 INFORMATION_SCHEMA表

4.39 INFORMATION_SCHEMA TABLES_EXTENSIONS表

4.40 INFORMATION_SCHEMA表空间

4.41 INFORMATION_SCHEMA TABLESPACES_EXTENSIONS表

4.42 INFORMATION_SCHEMA TABLE_CONSTRAINTS表

4.43 INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS表

4.44 INFORMATION_SCHEMA TABLE_PRIVILEGES表

4.45 INFORMATION_SCHEMA触发表

4.46 INFORMATION_SCHEMA USER_ATTRIBUTES表

4.47 INFORMATION_SCHEMA USER_PRIVILEGES表

4.48 INFORMATION_SCHEMA视图表

4.49 INFORMATION_SCHEMA VIEW_ROUTINE_USAGE表

4.50 INFORMATION_SCHEMA VIEW_TABLE_USAGE表

5 INFORMATION_SCHEMA InnoDB表

5.1 INFORMATION_SCHEMA InnoDB表参考

inform_schema INNODB_BUFFER_PAGE表

5.3 INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU表

信息schema INNODB_BUFFER_POOL_STATS表

INNODB_CACHED_INDEXES表

信息模式INNODB_CMP和INNODB_CMP_RESET表

INFORMATION_SCHEMA INNODB_CMPMEM和INNODB_CMPMEM_RESET表

信息模式INNODB_CMP_PER_INDEX和INNODB_CMP_PER_INDEX_RESET表

inform_schema INNODB_COLUMNS表

5.10 INFORMATION_SCHEMA INNODB_DATAFILES表

5.11 INFORMATION_SCHEMA INNODB_FIELDS表

5.12 INFORMATION_SCHEMA INNODB_FOREIGN表

5.13 INFORMATION_SCHEMA INNODB_FOREIGN_COLS表

5.14 INFORMATION_SCHEMA INNODB_FT_BEING_DELETED表

5.15 INNODB_FT_CONFIG INFORMATION_SCHEMA表

5.16 INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD表

5.17 INFORMATION_SCHEMA INNODB_FT_DELETED表

5.18 INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE表

5.19 INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE表

5.20 INFORMATION_SCHEMA INNODB_INDEXES表

5.21 INFORMATION_SCHEMA INNODB_METRICS表

5.22 INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES表

5.23 INFORMATION_SCHEMA INNODB_TABLES表

5.24 INFORMATION_SCHEMA INNODB_TABLESPACES表

5.25 inform_schema INNODB_TABLESPACES_BRIEF表

5.26 INNODB_TABLESTATS视图

5.27 INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO表

5.28 INFORMATION_SCHEMA INNODB_TRX表

5.29 INFORMATION_SCHEMA INNODB_VIRTUAL表

6 INFORMATION_SCHEMA线程池表

6.1 INFORMATION_SCHEMA线程池表参考

6.2 INFORMATION_SCHEMA TP_THREAD_GROUP_STATE表

6.3 INFORMATION_SCHEMA TP_THREAD_GROUP_STATS表

INFORMATION_SCHEMA TP_THREAD_STATE表

7 INFORMATION_SCHEMA连接控制表

7.1 INFORMATION_SCHEMA连接控制表参考

7.2信息模式连接控制失败登录尝试表

8 INFORMATION_SCHEMA MySQL企业防火墙表

8.1 INFORMATION_SCHEMA防火墙表参考

MYSQL_FIREWALL_USERS表的信息模式

mysql_firewall_白名单表

9 SHOW语句的扩展

MySQL 8.0 FAQ: INFORMATION_SCHEMA