MySQL :: MySQL 8.4 参考手册 :: 28.2 INFORMATION

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.2 INFORMATION_SCHEMA 表参考

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 98%

28.2 INFORMATION_SCHEMA 表参考28.2 INFORMATION_SCHEMA Table Reference

下表总结了所有可用的 INFORMATION_SCHEMA 表。有关详细信息，请参阅各个表的说明。The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions.

表 28.1 INFORMATION_SCHEMA 表Table 28.1 INFORMATION_SCHEMA Tables

表名Table Name	说明Description	已弃用Deprecated
`ADMINISTRABLE_ROLE_AUTHORIZATIONSADMINISTRABLE_ROLE_AUTHORIZATIONS`	当前用户或角色可授予的用户或角色Grantable users or roles for current user or role
`APPLICABLE_ROLESAPPLICABLE_ROLES`	当前用户的适用角色Applicable roles for current user
`CHARACTER_SETS`	可用字符集Available character sets
`CHECK_CONSTRAINTS`	表和列的 CHECK 约束Table and column CHECK constraints
`COLLATION_CHARACTER_SET_APPLICABILITY`	每个排序规则适用的字符集Character set applicable to each collation
`COLLATIONS`	每个字符集的排序规则Collations for each character set
`COLUMN_PRIVILEGESCOLUMN_PRIVILEGES`	列上定义的权限Privileges defined on columns
`COLUMN_STATISTICSCOLUMN_STATISTICS`	列值的直方图统计Histogram statistics for column values
`COLUMNSCOLUMNS`	每个表的列Columns in each table
`COLUMNS_EXTENSIONSCOLUMNS_EXTENSIONS`	主存储和次存储引擎的列属性Column attributes for primary and secondary storage engines
`CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTSCONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS`	每个账户当前连续失败的连接尝试次数Current number of consecutive failed connection attempts per account
`ENABLED_ROLESENABLED_ROLES`	当前会话中启用的角色Roles enabled within current session
`ENGINESENGINES`	存储引擎属性Storage engine properties
`EVENTSEVENTS`	事件管理器事件Event Manager events
`FILESFILES`	存储表空间数据的文件Files that store tablespace data
`INNODB_BUFFER_PAGEINNODB_BUFFER_PAGE`	InnoDB 缓冲池中的页面Pages in InnoDB buffer pool
`INNODB_BUFFER_PAGE_LRUINNODB_BUFFER_PAGE_LRU`	InnoDB 缓冲池中页面的 LRU 顺序LRU ordering of pages in InnoDB buffer pool
`INNODB_BUFFER_POOL_STATSINNODB_BUFFER_POOL_STATS`	InnoDB 缓冲池统计信息InnoDB buffer pool statistics
`INNODB_CACHED_INDEXESINNODB_CACHED_INDEXES`	InnoDB 缓冲池中每个索引的索引页缓存数量Number of index pages cached per index in InnoDB buffer pool
`INNODB_CMPINNODB_CMP`	与压缩 InnoDB 表相关操作的状态Status for operations related to compressed InnoDB tables
`INNODB_CMP_PER_INDEXINNODB_CMP_PER_INDEX`	与压缩 InnoDB 表和索引相关操作的状态Status for operations related to compressed InnoDB tables and indexes
`INNODB_CMP_PER_INDEX_RESETINNODB_CMP_PER_INDEX_RESET`	与压缩 InnoDB 表和索引相关操作的状态Status for operations related to compressed InnoDB tables and indexes
`INNODB_CMP_RESETINNODB_CMP_RESET`	与压缩 InnoDB 表相关操作的状态Status for operations related to compressed InnoDB tables
`INNODB_CMPMEMINNODB_CMPMEM`	InnoDB 缓冲池中压缩页的状态Status for compressed pages within InnoDB buffer pool
`INNODB_CMPMEM_RESETINNODB_CMPMEM_RESET`	InnoDB 缓冲池中压缩页的状态Status for compressed pages within InnoDB buffer pool
`INNODB_COLUMNSINNODB_COLUMNS`	每个 InnoDB 表的列Columns in each InnoDB table
`INNODB_DATAFILESINNODB_DATAFILES`	InnoDB 文件按表和通用表空间的数据文件路径信息Data file path information for InnoDB file-per-table and general tablespaces
`INNODB_FIELDSINNODB_FIELDS`	InnoDB 索引的关键列Key columns of InnoDB indexes
`INNODB_FOREIGNINNODB_FOREIGN`	InnoDB 外键元数据InnoDB foreign-key metadata
`INNODB_FOREIGN_COLSINNODB_FOREIGN_COLS`	InnoDB 外键列状态信息InnoDB foreign-key column status information
`INNODB_FT_BEING_DELETEDINNODB_FT_BEING_DELETED`	INNODB_FT_DELETED 表的快照Snapshot of INNODB_FT_DELETED table
`INNODB_FT_CONFIGINNODB_FT_CONFIG`	InnoDB 表 FULLTEXT 索引及相关处理的元数据Metadata for InnoDB table FULLTEXT index and associated processing
`INNODB_FT_DEFAULT_STOPWORDINNODB_FT_DEFAULT_STOPWORD`	InnoDB FULLTEXT 索引的默认停用词列表Default list of stopwords for InnoDB FULLTEXT indexes
`INNODB_FT_DELETEDINNODB_FT_DELETED`	从 InnoDB 表的全文索引中删除的行Rows deleted from InnoDB table FULLTEXT index
`INNODB_FT_INDEX_CACHEINNODB_FT_INDEX_CACHE`	InnoDB 全文索引中新插入行的分词信息Token information for newly inserted rows in InnoDB FULLTEXT index
`INNODB_FT_INDEX_TABLEINNODB_FT_INDEX_TABLE`	处理针对 InnoDB 表全文索引的文本搜索的倒排索引信息Inverted index information for processing text searches against InnoDB table FULLTEXT index
`INNODB_INDEXESINNODB_INDEXES`	InnoDB 索引元数据InnoDB index metadata
`INNODB_METRICSINNODB_METRICS`	InnoDB 性能信息InnoDB performance information
`INNODB_SESSION_TEMP_TABLESPACESINNODB_SESSION_TEMP_TABLESPACES`	会话临时表空间元数据Session temporary-tablespace metadata
`INNODB_TABLESINNODB_TABLES`	InnoDB 表元数据InnoDB table metadata
`INNODB_TABLESPACESINNODB_TABLESPACES`	InnoDB 按表存储、通用和回滚表空间元数据InnoDB file-per-table, general, and undo tablespace metadata
`INNODB_TABLESPACES_BRIEFINNODB_TABLESPACES_BRIEF`	简要的按表存储、通用、回滚及系统表空间元数据Brief file-per-table, general, undo, and system tablespace metadata
`INNODB_TABLESTATSINNODB_TABLESTATS`	InnoDB 表底层状态信息InnoDB table low-level status information
`INNODB_TEMP_TABLE_INFOINNODB_TEMP_TABLE_INFO`	关于活动的用户创建的 InnoDB 临时表的信息Information about active user-created InnoDB temporary tables
`INNODB_TRXINNODB_TRX`	活动的 InnoDB 事务信息Active InnoDB transaction information
`INNODB_VIRTUALINNODB_VIRTUAL`	InnoDB 虚拟生成列的元数据InnoDB virtual generated column metadata
`KEY_COLUMN_USAGEKEY_COLUMN_USAGE`	哪些键列有约束Which key columns have constraints
`KEYWORDSKEYWORDS`	MySQL 关键字MySQL keywords
`MYSQL_FIREWALL_USERSMYSQL_FIREWALL_USERS`	帐户配置文件的防火墙内存数据Firewall in-memory data for account profiles	是Yes
`MYSQL_FIREWALL_WHITELISTMYSQL_FIREWALL_WHITELIST`	帐户配置文件允许列表的防火墙内存数据Firewall in-memory data for account profile allowlists	是Yes
`ndb_transid_mysql_connection_mapndb_transid_mysql_connection_map`	NDB 事务信息NDB transaction information
`OPTIMIZER_TRACEOPTIMIZER_TRACE`	优化器跟踪活动产生的信息Information produced by optimizer trace activity
`PARAMETERSPARAMETERS`	存储例程参数和存储函数返回值Stored routine parameters and stored function return values
`PARTITIONSPARTITIONS`	表分区信息Table partition information
`PLUGINSPLUGINS`	插件信息Plugin information
`PROCESSLISTPROCESSLIST`	当前执行线程的信息Information about currently executing threads
`PROFILINGPROFILING`	语句性能分析信息Statement profiling information
`REFERENTIAL_CONSTRAINTSREFERENTIAL_CONSTRAINTS`	外键信息Foreign key information
`RESOURCE_GROUPSRESOURCE_GROUPS`	资源组信息Resource group information
`ROLE_COLUMN_GRANTSROLE_COLUMN_GRANTS`	当前启用角色可用或授予的角色列权限Column privileges for roles available to or granted by currently enabled roles
`ROLE_ROUTINE_GRANTSROLE_ROUTINE_GRANTS`	当前启用角色可用或授予的角色例程权限Routine privileges for roles available to or granted by currently enabled roles
`ROLE_TABLE_GRANTSROLE_TABLE_GRANTS`	当前启用角色可用或授予的角色表权限Table privileges for roles available to or granted by currently enabled roles
`ROUTINESROUTINES`	存储例程信息Stored routine information
`SCHEMA_PRIVILEGESSCHEMA_PRIVILEGES`	在架构上定义的权限Privileges defined on schemas
`SCHEMATASCHEMATA`	架构信息Schema information
`SCHEMATA_EXTENSIONSSCHEMATA_EXTENSIONS`	模式选项Schema options
`ST_GEOMETRY_COLUMNSST_GEOMETRY_COLUMNS`	每个存储空间数据的表中的列Columns in each table that store spatial data
`ST_SPATIAL_REFERENCE_SYSTEMSST_SPATIAL_REFERENCE_SYSTEMS`	可用的空间参考系统Available spatial reference systems
`ST_UNITS_OF_MEASUREST_UNITS_OF_MEASURE`	ST_Distance() 的可接受单位Acceptable units for ST_Distance()
`STATISTICSSTATISTICS`	表索引统计信息Table index statistics
`TABLE_CONSTRAINTSTABLE_CONSTRAINTS`	哪些表有约束Which tables have constraints
`TABLE_CONSTRAINTS_EXTENSIONSTABLE_CONSTRAINTS_EXTENSIONS`	主存储和辅助存储引擎的表约束属性Table constraint attributes for primary and secondary storage engines
`TABLE_PRIVILEGESTABLE_PRIVILEGES`	表上定义的权限Privileges defined on tables
`TABLESTABLES`	表信息Table information
`TABLES_EXTENSIONSTABLES_EXTENSIONS`	主存储引擎和次存储引擎的表属性Table attributes for primary and secondary storage engines
`TABLESPACES_EXTENSIONSTABLESPACES_EXTENSIONS`	主存储引擎的表空间属性Tablespace attributes for primary storage engines
`TP_THREAD_GROUP_STATETP_THREAD_GROUP_STATE`	线程池线程组状态Thread pool thread group states
`TP_THREAD_GROUP_STATSTP_THREAD_GROUP_STATS`	线程池线程组统计信息Thread pool thread group statistics
`TP_THREAD_STATETP_THREAD_STATE`	线程池线程信息Thread pool thread information
`TRIGGERSTRIGGERS`	触发器信息Trigger information
`USER_ATTRIBUTESUSER_ATTRIBUTES`	用户评论和属性User comments and attributes
`USER_PRIVILEGESUSER_PRIVILEGES`	按用户全局定义的权限Privileges defined globally per user
`VIEW_ROUTINE_USAGEVIEW_ROUTINE_USAGE`	视图中使用的存储函数Stored functions used in views
`VIEW_TABLE_USAGEVIEW_TABLE_USAGE`	视图中使用的表和视图Tables and views used in views
`VIEWSVIEWS`	视图信息View information

首页上一级下一节