MySQL 8.4 Release Notes
- 28.1 介绍28.1 Introduction
- 28.2 INFORMATION_SCHEMA 表参考28.2 INFORMATION_SCHEMA Table Reference
- 28.3 INFORMATION_SCHEMA 常规表28.3 INFORMATION_SCHEMA General Tables
- 28.3.1 INFORMATION_SCHEMA 常规表参考28.3.1 INFORMATION_SCHEMA General Table Reference
- 28.3.2 INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS 表28.3.2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
- 28.3.3 INFORMATION_SCHEMA APPLICABLE_ROLES 表28.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
- 28.3.4 INFORMATION_SCHEMA CHARACTER_SETS 表28.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 28.3.5 INFORMATION_SCHEMA CHECK_CONSTRAINTS 表28.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
- 28.3.6 INFORMATION_SCHEMA 校对表28.3.6 The INFORMATION_SCHEMA COLLATIONS Table
- 28.3.7 INFORMATION_SCHEMA 校对_字符集_适用性表28.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 28.3.8 INFORMATION_SCHEMA 列表28.3.8 The INFORMATION_SCHEMA COLUMNS Table
- 28.3.9 INFORMATION_SCHEMA 列扩展表28.3.9 The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table
- 28.3.10 INFORMATION_SCHEMA 列权限表28.3.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 28.3.11 INFORMATION_SCHEMA 列统计表28.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
- 28.3.12 INFORMATION_SCHEMA ENABLED_ROLES 表28.3.12 The INFORMATION_SCHEMA ENABLED_ROLES Table
- 28.3.13 INFORMATION_SCHEMA ENGINES 表28.3.13 The INFORMATION_SCHEMA ENGINES Table
- 28.3.14 INFORMATION_SCHEMA EVENTS 表28.3.14 The INFORMATION_SCHEMA EVENTS Table
- 28.3.15 INFORMATION_SCHEMA FILES 表28.3.15 The INFORMATION_SCHEMA FILES Table
- 28.3.16 INFORMATION_SCHEMA KEY_COLUMN_USAGE 表28.3.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 28.3.17 INFORMATION_SCHEMA KEYWORDS 表28.3.17 The INFORMATION_SCHEMA KEYWORDS Table
- 28.3.18 INFORMATION_SCHEMA ndb_transid_mysql_connection_map 表28.3.18 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
- 28.3.19 INFORMATION_SCHEMA OPTIMIZER_TRACE 表28.3.19 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
- 28.3.20 INFORMATION_SCHEMA PARAMETERS 表28.3.20 The INFORMATION_SCHEMA PARAMETERS Table
- 28.3.21 INFORMATION_SCHEMA PARTITIONS 表28.3.21 The INFORMATION_SCHEMA PARTITIONS Table
- 28.3.22 INFORMATION_SCHEMA PLUGINS 表28.3.22 The INFORMATION_SCHEMA PLUGINS Table
- 28.3.23 INFORMATION_SCHEMA PROCESSLIST 表28.3.23 The INFORMATION_SCHEMA PROCESSLIST Table
- 28.3.24 INFORMATION_SCHEMA PROFILING 表28.3.24 The INFORMATION_SCHEMA PROFILING Table
- 28.3.25 INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS 表28.3.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
- 28.3.26 INFORMATION_SCHEMA RESOURCE_GROUPS 表28.3.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
- 28.3.27 INFORMATION_SCHEMA ROLE_COLUMN_GRANTS 表28.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
- 28.3.28 INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS 表28.3.28 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
- 28.3.29 INFORMATION_SCHEMA ROLE_TABLE_GRANTS 表28.3.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
- 28.3.30 INFORMATION_SCHEMA ROUTINES 表28.3.30 The INFORMATION_SCHEMA ROUTINES Table
- 28.3.31 INFORMATION_SCHEMA SCHEMATA 表28.3.31 The INFORMATION_SCHEMA SCHEMATA Table
- 28.3.32 INFORMATION_SCHEMA SCHEMATA_EXTENSIONS 表28.3.32 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
- 28.3.33 INFORMATION_SCHEMA SCHEMA_PRIVILEGES 表28.3.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 28.3.34 INFORMATION_SCHEMA STATISTICS 表28.3.34 The INFORMATION_SCHEMA STATISTICS Table
- 28.3.35 INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS 表28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
- 28.3.36 INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS 表28.3.36 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
- 28.3.37 INFORMATION_SCHEMA ST_UNITS_OF_MEASURE 表28.3.37 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
- 28.3.38 INFORMATION_SCHEMA TABLES 表28.3.38 The INFORMATION_SCHEMA TABLES Table
- 28.3.39 INFORMATION_SCHEMA TABLES_EXTENSIONS 表28.3.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table
- 28.3.40 INFORMATION_SCHEMA TABLESPACES_EXTENSIONS 表28.3.40 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table
- 28.3.41 INFORMATION_SCHEMA TABLE_CONSTRAINTS 表28.3.41 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 28.3.42 INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS 表28.3.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table
- 28.3.43 INFORMATION_SCHEMA TABLE_PRIVILEGES 表28.3.43 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 28.3.44 INFORMATION_SCHEMA TRIGGERS 表28.3.44 The INFORMATION_SCHEMA TRIGGERS Table
- 28.3.45 INFORMATION_SCHEMA USER_ATTRIBUTES 表28.3.45 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
- 28.3.46 INFORMATION_SCHEMA USER_PRIVILEGES 表28.3.46 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 28.3.47 INFORMATION_SCHEMA VIEWS 表28.3.47 The INFORMATION_SCHEMA VIEWS Table
- 28.3.48 INFORMATION_SCHEMA VIEW_ROUTINE_USAGE 表28.3.48 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
- 28.3.49 INFORMATION_SCHEMA VIEW_TABLE_USAGE 表28.3.49 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
- 28.4 INFORMATION_SCHEMA InnoDB 表28.4 INFORMATION_SCHEMA InnoDB Tables
- 28.4.1 INFORMATION_SCHEMA InnoDB 表参考28.4.1 INFORMATION_SCHEMA InnoDB Table Reference
- 28.4.2 INFORMATION_SCHEMA INNODB_BUFFER_PAGE 表28.4.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
- 28.4.3 INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU 表28.4.3 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
- 28.4.4 INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS 表28.4.4 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
- 28.4.5 INFORMATION_SCHEMA INNODB_CACHED_INDEXES 表28.4.5 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table
- 28.4.6 INFORMATION_SCHEMA INNODB_CMP 和 INNODB_CMP_RESET 表28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
- 28.4.7 INFORMATION_SCHEMA INNODB_CMPMEM 和 INNODB_CMPMEM_RESET 表28.4.7 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
- 28.4.8 INFORMATION_SCHEMA INNODB_CMP_PER_INDEX 和 INNODB_CMP_PER_INDEX_RESET 表28.4.8 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
- 28.4.9 INFORMATION_SCHEMA INNODB_COLUMNS 表28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table
- 28.4.10 INFORMATION_SCHEMA INNODB_DATAFILES 表28.4.10 The INFORMATION_SCHEMA INNODB_DATAFILES Table
- 28.4.11 INFORMATION_SCHEMA INNODB_FIELDS 表28.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table
- 28.4.12 INFORMATION_SCHEMA INNODB_FOREIGN 表28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table
- 28.4.13 INFORMATION_SCHEMA INNODB_FOREIGN_COLS 表28.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table
- 28.4.14 INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
- 28.4.15 INFORMATION_SCHEMA INNODB_FT_CONFIG 表28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
- 28.4.16 INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 表28.4.16 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
- 28.4.17 INFORMATION_SCHEMA INNODB_FT_DELETED 表28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
- 28.4.18 INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE 表28.4.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
- 28.4.19 INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE 表28.4.19 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
- 28.4.20 INFORMATION_SCHEMA INNODB_INDEXES 表28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table
- 28.4.21 INFORMATION_SCHEMA INNODB_METRICS 表28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table
- 28.4.22 INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES 表28.4.22 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table
- 28.4.23 INFORMATION_SCHEMA INNODB_TABLES 表28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table
- 28.4.24 INFORMATION_SCHEMA INNODB_TABLESPACES 表28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table
- 28.4.25 INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 表28.4.25 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table
- 28.4.26 INFORMATION_SCHEMA INNODB_TABLESTATS 视图28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View
- 28.4.27 INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO 表28.4.27 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
- 28.4.28 INFORMATION_SCHEMA INNODB_TRX 表28.4.28 The INFORMATION_SCHEMA INNODB_TRX Table
- 28.4.29 INFORMATION_SCHEMA INNODB_VIRTUAL 表28.4.29 The INFORMATION_SCHEMA INNODB_VIRTUAL Table
- 28.5 INFORMATION_SCHEMA 线程池表28.5 INFORMATION_SCHEMA Thread Pool Tables
- 28.5.1 INFORMATION_SCHEMA 线程池表参考28.5.1 INFORMATION_SCHEMA Thread Pool Table Reference
- 28.5.2 INFORMATION_SCHEMA TP_THREAD_GROUP_STATE 表28.5.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
- 28.5.3 INFORMATION_SCHEMA TP_THREAD_GROUP_STATS 表28.5.3 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
- 28.5.4 INFORMATION_SCHEMA TP_THREAD_STATE 表28.5.4 The INFORMATION_SCHEMA TP_THREAD_STATE Table
- 28.6 INFORMATION_SCHEMA 连接控制表28.6 INFORMATION_SCHEMA Connection Control Tables
- 28.7 INFORMATION_SCHEMA MySQL 企业防火墙表28.7 INFORMATION_SCHEMA MySQL Enterprise Firewall Tables
- 28.8 SHOW 语句扩展28.8 Extensions to SHOW Statements
INFORMATION_SCHEMA 提供对数据库 元数据、MySQL 服务器信息（例如数据库或表的名称、列的数据类型或访问权限）的访问。有时用于描述这些信息的其他术语包括 数据字典 和 系统目录。INFORMATION_SCHEMA provides access to database
metadata, information about
the MySQL server such as the name of a database or table, the data
type of a column, or access privileges. Other terms that are
sometimes used for this information are
data dictionary and
system catalog.