MySQL :: MySQL 8.3 Reference Manual :: INFORMATION_SCHEMA Index

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 8.3

8.0 current
5.7

MySQL 8.3 Reference Manual / Indexes / INFORMATION_SCHEMA Index

INFORMATION_SCHEMA Index

A | C | E | F | I | K | M | N | O | P | R | S | T | U | V

A

[]

ADMINISTRABLE_ROLE_AUTHORIZATIONS

Section 28.3.2, “INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS 表”

APPLICABLE_ROLES

Section 28.3.3, “INFORMATION_SCHEMA APPLICABLE_ROLES 表”

C

[]

CHARACTER_SETS

Section 12.3.8, “字符集介绍符”
Section 12.2, “MySQL 中的字符集和排序规则”
Section 12.3.6, “字符串文字的字符集和排序规则”
Section 12.3.5, “列字符集和排序规则”
Section 12.3.3, “数据库字符集和排序规则”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 15.7.7.4, “显示字符集语句”
Section 12.10, “支持的字符集和排序规则”
Section 12.3.4, “表字符集和排序规则”
Section 28.3.4, “INFORMATION_SCHEMA CHARACTER_SETS 表”

CHECK_CONSTRAINTS

Section 15.1.20.6, “CHECK 约束”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 28.3.5, “INFORMATION_SCHEMA CHECK_CONSTRAINTS 表”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 10.2.3, “优化INFORMATION_SCHEMA查询”
Section 28.3.7, “INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY 表”

COLLATIONS

Section 12.15, “字符集配置”
Section 12.2, “MySQL 中的字符集和排序规则”
Section 12.14.2, “选择排序规则 ID”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 10.9.6, “优化器统计”
Section 15.7.7.5, “显示排序规则语句”
Section 12.8.5, “二进制排序规则与 _bin 排序规则的比较”
Section 13.3.2, “CHAR 和 VARCHAR 类型”
Section 28.3.6, “INFORMATION_SCHEMA COLLATIONS 表”
Section 12.10.1, “Unicode 字符集”

COLUMN_PRIVILEGES

Section 28.3.10, “INFORMATION_SCHEMA COLUMN_PRIVILEGES 表”

COLUMN_STATISTICS

Section 15.7.3.1, “ANALYZE TABLE 语句”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 10.9.6, “优化器统计”
Section 28.3.11, “INFORMATION_SCHEMA COLUMN_STATISTICS 表”

COLUMNS

Section 15.1.20, “CREATE TABLE 语句”
Section 15.1.20.11, “生成的不可见主键”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 28.1, “简介”
Section 15.1.20.10, “不可见列”
Section 7.1.8, “服务器系统变量”
Section 15.7.7.6, “显示列语句”
Section 28.3.8, “INFORMATION_SCHEMA COLUMNS 表”
Section 28.4.2, “INFORMATION_SCHEMA INNODB_BUFFER_PAGE 表”
Section 28.4.3, “INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU 表”
Section 28.4.4, “INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS 表”
Section 28.4.5, “INFORMATION_SCHEMA INNODB_CACHED_INDEXES 表”
Section 28.4.6, “INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET 表”
Section 28.4.8, “INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET 表”
Section 28.4.7, “INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET 表”
Section 28.4.9, “INFORMATION_SCHEMA INNODB_COLUMNS 表”
Section 28.4.10, “INFORMATION_SCHEMA INNODB_DATAFILES 表”
Section 28.4.11, “INFORMATION_SCHEMA INNODB_FIELDS 表”
Section 28.4.12, “INFORMATION_SCHEMA INNODB_FOREIGN 表”
Section 28.4.13, “INFORMATION_SCHEMA INNODB_FOREIGN_COLS 表”
Section 28.4.14, “INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表”
Section 28.4.15, “INFORMATION_SCHEMA INNODB_FT_CONFIG 表”
Section 28.4.16, “INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 表”
Section 28.4.17, “INFORMATION_SCHEMA INNODB_FT_DELETED 表”
Section 28.4.18, “INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE 表”
Section 28.4.19, “INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE 表”
Section 28.4.20, “INFORMATION_SCHEMA INNODB_INDEXES 表”
Section 28.4.21, “INFORMATION_SCHEMA INNODB_METRICS 表”
Section 28.4.22, “INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES 表”
Section 28.4.23, “INFORMATION_SCHEMA INNODB_TABLES 表”
Section 28.4.24, “INFORMATION_SCHEMA INNODB_TABLESPACES 表”
Section 28.4.25, “INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 表”
Section 28.4.26, “INFORMATION_SCHEMA INNODB_TABLESTATS 视图”
Section 28.4.27, “INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO 表”
Section 28.4.28, “INFORMATION_SCHEMA INNODB_TRX 表”
Section 28.4.29, “INFORMATION_SCHEMA INNODB_VIRTUAL 表”
Section 28.3.35, “INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS 表”
Section 3.7, “升级 MySQL Binary or Package-based Installations on Unix/Linux”

COLUMNS_EXTENSIONS

Section 28.3.9, “INFORMATION_SCHEMA COLUMNS_EXTENSIONS 表”

CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS

Section 8.4.2.1, “连接控制插件安装”
Section 8.4.2.2, “连接控制系统和状态变量”
Section 8.4.2, “连接控制插件”
Section 28.6.2, “INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS 表”

E

[]

ENABLED_ROLES

Section 28.3.12, “INFORMATION_SCHEMA ENABLED_ROLES 表”

ENGINES

Section 29.1, “性能模式快速入门”
Section 25.6.20, “Quick Reference: NDB Cluster SQL 语句”
Section 7.1.8, “服务器系统变量”
Section 15.7.7.17, “显示引擎语句”
Section 28.3.13, “INFORMATION_SCHEMA ENGINES 表”
Section 17.1.3, “验证 InnoDB 是否为默认存储引擎”

EVENTS

Section 19.1.2.8, “Adding Replicas to a 复制 Environment”
Section 27.4.4, “事件元数据”
Section 27.4.2, “事件调度器配置”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 19.5.1.16, “复制 of Invoked Features”
Section 27.8, “存储程序的限制”
Section 19.1.2.6.2, “Setting Up 复制 with Existing Data”
Section 15.7.7.19, “显示事件语句”
Section 27.4.6, “事件调度器和 MySQL 权限”
Section 28.3.14, “INFORMATION_SCHEMA EVENTS 表”

F

[]

FILES

Section 15.1.6, “更改日志文件组语句”
Section 15.1.10, “更改表空间语句”
Section 7.6.7.3, “克隆远程数据”
Section 15.1.16, “创建日志文件组语句”
Section 15.1.21, “创建表空间语句”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 25.6.18, “INFORMATION_SCHEMA 表 for NDB Cluster”
Section 17.6.3.6, “Moving 表pace Files While the Server is Offline”
Section 25.6.11.1, “NDB 集群磁盘数据对象”
Section 25.6.11.2, “NDB 集群磁盘数据存储要求”
Section 25.5.9, “ndb_desc — Describe NDB 表”
Section 25.6.17, “ndbinfo：NDB 集群信息数据库”
Section 8.2.2, “MySQL 提供的权限”
Section 17.15.8, “Retrieving InnoDB 表pace Metadata from INFORMATION_SCHEMA.FILES”
Section 17.6.3.5, “Temporary 表paces”
Section 28.3.15, “INFORMATION_SCHEMA FILES 表”
Section 28.4.10, “INFORMATION_SCHEMA INNODB_DATAFILES 表”
Section 28.4.24, “INFORMATION_SCHEMA INNODB_TABLESPACES 表”
Section 28.3.40, “INFORMATION_SCHEMA TABLESPACES 表”
Section 25.6.17.25, “ndbinfo dict_obj_info 表”
Section 25.6.17.26, “ndbinfo dict_obj_tree 表”
Section 25.6.17.43, “ndbinfo logbuffers 表”
Section 25.6.17.44, “ndbinfo logspaces 表”
Section 17.6.3.4, “Undo 表paces”

I

[]

INFORMATION_SCHEMA

Section 16.1, “数据字典架构”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 25.6.18, “INFORMATION_SCHEMA 表 for NDB Cluster”
Section 17.15, “InnoDB INFORMATION_SCHEMA 表”
Chapter 16, MySQL 数据字典
MySQL 词汇表
Section 25.6.21.2, “NDB集群和MySQL权限”
Section 17.12.1, “在线 DDL 操作”
Section 8.2.9, “保留的帐户”
Section 7.2, “MySQL 数据目录”
Section 12.9.3, “The utf8 Character Set (Deprecated alias for utf8mb3)”
Section 30.2, “使用 sys Schema”
Section 3.4, “MySQL 升级过程升级的内容”

INFORMATION_SCHEMA.CHARACTER_SETS

Section A.11, “MySQL 8.3 常见问题解答：MySQL 中日韩字符集”

INFORMATION_SCHEMA.COLUMN_STATISTICS

Section 10.9, “控制查询优化器”
Section 10.9.6, “优化器统计”

INFORMATION_SCHEMA.COLUMNS

Section 25.5.14, “ndb_index_stat — NDB 索引统计实用程序”
Section 29.1, “性能模式快速入门”

INFORMATION_SCHEMA.EVENTS

Section 19.5.1.16, “复制 of Invoked Features”

INFORMATION_SCHEMA.FILES

Section 15.1.21, “创建表空间语句”
Section 25.6.17.26, “ndbinfo dict_obj_tree 表”
Section 17.6.3.4, “Undo 表paces”

INFORMATION_SCHEMA.INNODB_CMP

MySQL 词汇表
Section 17.9.1.3, “Tuning Compression for InnoDB 表”
Section 17.15.1.3, “Using the Compression Information Schema 表”

INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX

Section 17.9.1.3, “Tuning Compression for InnoDB 表”

INFORMATION_SCHEMA.INNODB_CMPMEM

Section 17.15.1.3, “Using the Compression Information Schema 表”

INFORMATION_SCHEMA.INNODB_TABLES

Section 26.3.3, “Exchanging Partitions and Subpartitions with 表”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”

INFORMATION_SCHEMA.INNODB_TABLESPACES

Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”

INFORMATION_SCHEMA.INNODB_TABLESTATS

Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”

INFORMATION_SCHEMA.PARTITIONS

Section 26.2.7, “How MySQL 分区 Handles NULL”

INFORMATION_SCHEMA.PLUGINS

Section A.2, “MySQL 8.3 常见问题解答：存储引擎”

INFORMATION_SCHEMA.PROCESSLIST

Section 28.3.23, “INFORMATION_SCHEMA PROCESSLIST 表”
Section 1.3, “MySQL 8.3 的新特性”

information_schema.processlist

Section 7.1.10, “服务器状态变量”

INFORMATION_SCHEMA.ROUTINES

Section A.4, “MySQL 8.3 常见问题解答：存储过程和函数”

INFORMATION_SCHEMA.STATISTICS

Section 25.5.14, “ndb_index_stat — NDB 索引统计实用程序”
Section 7.3, “mysql 系统模式”

INFORMATION_SCHEMA.TABLES

Section 17.13, “InnoDB 静态数据加密”

INFORMATION_SCHEMA.TRIGGERS

Section A.5, “MySQL 8.3 常见问题解答：触发器”

INNODB_BUFFER_PAGE

Section 17.5.2, “更改缓冲区”
Section 17.15.5, “InnoDB INFORMATION_SCHEMA 缓冲池 Tables”
Section 30.1, “使用 sys Schema 的先决条件”
Section 28.4.2, “INFORMATION_SCHEMA INNODB_BUFFER_PAGE 表”
Section 28.4.3, “INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU 表”
Section 30.4.3.7, “The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views”
Section 30.4.3.8, “The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views”

INNODB_BUFFER_PAGE_LRU

Section 17.15.5, “InnoDB INFORMATION_SCHEMA 缓冲池 Tables”
Section 17.8.3.6, “Saving and Restoring the 缓冲池 State”
Section 28.4.3, “INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU 表”

INNODB_BUFFER_POOL_STATS

Section 17.5.1, “缓冲池”
Section 17.15.5, “InnoDB INFORMATION_SCHEMA 缓冲池 Tables”
Section 28.4.4, “INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS 表”

INNODB_CACHED_INDEXES

Section 28.4.5, “INFORMATION_SCHEMA INNODB_CACHED_INDEXES 表”

INNODB_CMP

Section 17.15.1, “InnoDB INFORMATION_SCHEMA 表 about Compression”
Section 17.15.1.1, “INNODB_CMP 和 INNODB_CMP_RESET”
Section 17.15.1.2, “INNODB_CMPMEM 和 INNODB_CMPMEM_RESET”
Section 17.9.1.4, “Monitoring InnoDB 表压缩 at Runtime”
Section 28.4.6, “INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET 表”
Section 17.9.1.3, “Tuning Compression for InnoDB 表”
Section 17.15.1.3, “Using the Compression Information Schema 表”

INNODB_CMP_PER_INDEX

Section 17.14, “InnoDB 启动选项和系统变量”
Section 17.9.1.4, “Monitoring InnoDB 表压缩 at Runtime”
Section 28.4.8, “INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET 表”
Section 17.9.1.3, “Tuning Compression for InnoDB 表”
Section 17.15.1.3, “Using the Compression Information Schema 表”

INNODB_CMP_PER_INDEX_RESET

Section 28.4.8, “INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET 表”

INNODB_CMP_RESET

Section 17.15.1, “InnoDB INFORMATION_SCHEMA 表 about Compression”
Section 17.15.1.1, “INNODB_CMP 和 INNODB_CMP_RESET”
Section 17.15.1.2, “INNODB_CMPMEM 和 INNODB_CMPMEM_RESET”
Section 28.4.6, “INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET 表”

INNODB_CMPMEM

Section 17.15.1, “InnoDB INFORMATION_SCHEMA 表 about Compression”
Section 17.15.1.2, “INNODB_CMPMEM 和 INNODB_CMPMEM_RESET”
Section 28.4.7, “INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET 表”
Section 17.15.1.3, “Using the Compression Information Schema 表”

INNODB_CMPMEM_RESET

Section 17.15.1, “InnoDB INFORMATION_SCHEMA 表 about Compression”
Section 17.15.1.2, “INNODB_CMPMEM 和 INNODB_CMPMEM_RESET”
Section 28.4.7, “INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET 表”

INNODB_COLUMNS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 28.4.9, “INFORMATION_SCHEMA INNODB_COLUMNS 表”
Section 28.4.29, “INFORMATION_SCHEMA INNODB_VIRTUAL 表”

INNODB_DATAFILES

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 17.15.8, “Retrieving InnoDB 表pace Metadata from INFORMATION_SCHEMA.FILES”
Section 28.3.15, “INFORMATION_SCHEMA FILES 表”
Section 28.4.10, “INFORMATION_SCHEMA INNODB_DATAFILES 表”
Section 28.4.25, “INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 表”
Section 28.3.40, “INFORMATION_SCHEMA TABLESPACES 表”

INNODB_FIELDS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 28.4.11, “INFORMATION_SCHEMA INNODB_FIELDS 表”

INNODB_FOREIGN

Section 1.6.3.2, “外键约束”
Section 15.1.20.5, “外键约束”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 28.4.12, “INFORMATION_SCHEMA INNODB_FOREIGN 表”

INNODB_FOREIGN_COLS

Section 1.6.3.2, “外键约束”
Section 15.1.20.5, “外键约束”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 28.4.13, “INFORMATION_SCHEMA INNODB_FOREIGN_COLS 表”

INNODB_FT_BEING_DELETED

Section 17.6.2.4, “InnoDB Full-Text 索引”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index 表”
Section 17.14, “InnoDB 启动选项和系统变量”
Section 28.4.14, “INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表”

INNODB_FT_CONFIG

Section 17.6.2.4, “InnoDB Full-Text 索引”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index 表”
Section 17.14, “InnoDB 启动选项和系统变量”
Section 28.4.15, “INFORMATION_SCHEMA INNODB_FT_CONFIG 表”

INNODB_FT_DEFAULT_STOPWORD

Section 14.9.4, “全文停用词”
Section 17.6.2.4, “InnoDB Full-Text 索引”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index 表”
Section 28.4.16, “INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 表”

INNODB_FT_DELETED

Section 17.6.2.4, “InnoDB Full-Text 索引”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index 表”
Section 17.14, “InnoDB 启动选项和系统变量”
Section 28.4.14, “INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表”
Section 28.4.17, “INFORMATION_SCHEMA INNODB_FT_DELETED 表”

INNODB_FT_INDEX_CACHE

Section 17.6.2.4, “InnoDB Full-Text 索引”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index 表”
Section 17.14, “InnoDB 启动选项和系统变量”
Section 14.9.9, “MeCab 全文解析器插件”
Section 14.9.8, “ngram 全文解析器”
Section 28.4.18, “INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE 表”

INNODB_FT_INDEX_TABLE

Section 14.9.4, “全文停用词”
Section 17.6.2.4, “InnoDB Full-Text 索引”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index 表”
Section 17.14, “InnoDB 启动选项和系统变量”
Section 28.4.14, “INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表”
Section 28.4.17, “INFORMATION_SCHEMA INNODB_FT_DELETED 表”
Section 28.4.19, “INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE 表”

INNODB_INDEXES

Section 17.8.11, “配置索引页的合并阈值”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.6.2.4, “InnoDB Full-Text 索引”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 28.4.5, “INFORMATION_SCHEMA INNODB_CACHED_INDEXES 表”
Section 28.4.20, “INFORMATION_SCHEMA INNODB_INDEXES 表”

INNODB_METRICS

Section 15.7.3.1, “ANALYZE TABLE 语句”
Section 17.5.2, “更改缓冲区”
Section 17.8.11, “配置索引页的合并阈值”
Section 17.15.6, “InnoDB INFORMATION_SCHEMA 指标表”
Section 17.14, “InnoDB 启动选项和系统变量”
MySQL 词汇表
Section 28.4.21, “INFORMATION_SCHEMA INNODB_METRICS 表”
Section 30.4.3.21, “metrics 视图”
Section 17.7.6, “事务调度”
Section 17.6.3.4, “Undo 表paces”

INNODB_SESSION_TEMP_TABLESPACES

Section 17.6.3.5, “Temporary 表paces”
Section 28.4.22, “INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES 表”

INNODB_TABLES

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.6.2.4, “InnoDB Full-Text 索引”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 17.10, “InnoDB 行格式”
Section 11.2.4, “标识符到文件名的映射”
Section 28.4.5, “INFORMATION_SCHEMA INNODB_CACHED_INDEXES 表”
Section 28.4.23, “INFORMATION_SCHEMA INNODB_TABLES 表”

INNODB_TABLESPACES

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.13, “InnoDB 静态数据加密”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 17.9.2, “InnoDB 页面压缩”
Section 17.15.8, “Retrieving InnoDB 表pace Metadata from INFORMATION_SCHEMA.FILES”
Section 15.7.7.40, “显示表状态语句”
Section 17.6.3.9, “表pace AUTOEXTEND_SIZE Configuration”
Section 28.3.15, “INFORMATION_SCHEMA FILES 表”
Section 28.4.24, “INFORMATION_SCHEMA INNODB_TABLESPACES 表”
Section 28.4.25, “INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 表”
Section 28.3.38, “INFORMATION_SCHEMA TABLES 表”
Section 28.3.40, “INFORMATION_SCHEMA TABLESPACES 表”
Section 17.6.3.4, “Undo 表paces”

INNODB_TABLESPACES_BRIEF

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 28.4.25, “INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 表”

INNODB_TABLESTATS

Section 15.7.3.1, “ANALYZE TABLE 语句”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object 表”
Section 28.4.26, “INFORMATION_SCHEMA INNODB_TABLESTATS 视图”

INNODB_TEMP_TABLE_INFO

Section 17.15.7, “InnoDB INFORMATION_SCHEMA 临时表信息表”
Section 17.6.3.5, “Temporary 表paces”
Section 28.4.27, “INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO 表”

INNODB_TRX

Section 17.15.2, “InnoDB INFORMATION_SCHEMA 事务和锁定信息”
Section 17.15.2.2, “InnoDB 锁和锁等待信息”
Section 17.14, “InnoDB 启动选项和系统变量”
Section 17.15.2.3, “InnoDB 事务和锁定信息的持久性和一致性”
Section 29.12.13.1, “data_locks 表”
Section 28.4.28, “INFORMATION_SCHEMA INNODB_TRX 表”
Section 17.7.6, “事务调度”
Section 17.15.2.1, “使用 InnoDB 事务和锁定信息”

INNODB_VIRTUAL

Section 28.4.29, “INFORMATION_SCHEMA INNODB_VIRTUAL 表”

K

[]

KEY_COLUMN_USAGE

Section 1.6.3.2, “外键约束”
Section 15.1.20.5, “外键约束”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 28.3.16, “INFORMATION_SCHEMA KEY_COLUMN_USAGE 表”
Section 7.3, “mysql 系统模式”

KEYWORDS

Section 28.3.17, “INFORMATION_SCHEMA KEYWORDS 表”

M

[]

MYSQL_FIREWALL_USERS

Section 8.4.7.4, “MySQL 企业防火墙 Reference”
Section 28.7.2, “INFORMATION_SCHEMA MYSQL_FIREWALL_USERS 表”
Section 8.4.7.3, “Using MySQL 企业防火墙”

MYSQL_FIREWALL_WHITELIST

Section 8.4.7.4, “MySQL 企业防火墙 Reference”
Section 28.7.3, “INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST 表”

N

[]

NDB_TRANSID_MYSQL_CONNECTION_MAP

Section 25.6.17.55, “ndbinfo server_operations 表”
Section 25.6.17.56, “ndbinfo server_transactions 表”

ndb_transid_mysql_connection_map

Section 25.6.18, “INFORMATION_SCHEMA 表 for NDB Cluster”

Section 25.6.17, “ndbinfo：NDB 集群信息数据库”

O

[]

OPTIMIZER_TRACE

Section 10.2.1.2, “Range 优化”
Section 28.3.19, “INFORMATION_SCHEMA OPTIMIZER_TRACE 表”

P

[]

PARAMETERS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section A.4, “MySQL 8.3 常见问题解答：存储过程和函数”
Section 15.7.7.30, “显示存储过程状态语句”
Section 28.3.20, “INFORMATION_SCHEMA PARAMETERS 表”
Section 28.3.30, “INFORMATION_SCHEMA ROUTINES 表”

PARTITIONS

Section 26.3.3, “Exchanging Partitions and Subpartitions with 表”
Section 26.2.7, “How MySQL 分区 Handles NULL”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 26.2.5, “KEY 分区”
Section 26.3.5, “获取有关分区的信息”
Chapter 26, 分区
Section 26.2.3.1, “RANGE COLUMNS 分区”
Section 15.7.7.40, “显示表状态语句”
Section 28.3.21, “INFORMATION_SCHEMA PARTITIONS 表”
Section 28.3.38, “INFORMATION_SCHEMA TABLES 表”

PLUGINS

Section 7.6.7.3, “克隆远程数据”
Section 8.4.2.1, “连接控制插件安装”
Section 8.4.1.12, “FIDO 插件式认证”
Section 15.7.4.4, “安装插件语句”
Section 7.6.1, “安装和卸载插件”
Section 7.6.5.1, “安装或卸载 ddl_rewriter”
Section 8.4.5.2, “Installing or Uninstalling MySQL 企业版审计”
Section 19.4.10.1, “Installing Semisynchronous 复制”
Section 7.6.7.1, “安装克隆插件”
Section 8.4.1.8, “Kerberos 插件式认证”
Section 8.4.4.17, “密钥环元数据”
Section 8.4.4.3, “密钥环插件安装”
Section 8.4.1.7, “LDAP 插件式认证”
Section 8.4.1.9, “No-Login 插件式认证”
Section 7.6.2, “获取服务器插件信息”
Section 8.4.1.5, “PAM 插件式认证”
Section 25.6.20, “Quick Reference: NDB Cluster SQL 语句”
Section 7.1.7, “服务器命令选项”
Section 8.4.1.10, “Socket Peer-Credential 插件式认证”
Section 8.4.1.13, “Test 插件式认证”
Section 28.3.22, “INFORMATION_SCHEMA PLUGINS 表”
Section 7.6.3.2, “线程池安装”
Section 8.4.1.11, “WebAuthn 插件式认证”
Section 8.4.1.6, “Windows 插件式认证”

PROCESSLIST

Section 10.14.1, “访问进程列表”
Section 14.15, “信息函数”
Section 15.7.8.4, “杀死语句”
Section 10.8.4, “获取命名连接的执行计划信息”
Section 29.6, “性能模式检测信号命名约定”
Section 29.12.11, “Performance Schema 复制 Tables”
Section 29.12.5, “Performance Schema Stage Event 表”
Section 17.15.2.3, “InnoDB 事务和锁定信息的持久性和一致性”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.31, “显示进程列表语句”
Section 7.6.7.11, “停止克隆操作”
Section 29.12.22.2, “error_log 表”
Section 28.4.28, “INFORMATION_SCHEMA INNODB_TRX 表”
Section 28.3.23, “INFORMATION_SCHEMA PROCESSLIST 表”
Section 30.4.3.22, “The processlist and x$processlist Views”
Section 29.12.22.7, “processlist 表”
Section 29.12.22.8, “threads 表”
Section 17.15.2.1, “使用 InnoDB 事务和锁定信息”

PROFILING

Section 15.7.7.32, “显示配置文件语句”
Section 28.3.24, “INFORMATION_SCHEMA PROFILING 表”

R

[]

REFERENTIAL_CONSTRAINTS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 28.3.25, “INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS 表”
Section 7.3, “mysql 系统模式”

RESOURCE_GROUPS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 7.1.16, “资源组”
Section 28.3.26, “INFORMATION_SCHEMA RESOURCE_GROUPS 表”

ROLE_COLUMN_GRANTS

Section 28.3.27, “INFORMATION_SCHEMA ROLE_COLUMN_GRANTS 表”

ROLE_ROUTINE_GRANTS

Section 28.3.28, “INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS 表”

ROLE_TABLE_GRANTS

Section 28.3.29, “INFORMATION_SCHEMA ROLE_TABLE_GRANTS 表”

ROUTINES

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 28.1, “简介”
Section A.4, “MySQL 8.3 常见问题解答：存储过程和函数”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.30, “显示存储过程状态语句”
Section 27.6, “存储对象访问控制”
Section 27.2.3, “存储例程元数据”
Section 27.2.2, “存储例程和 MySQL 权限”
Section 28.3.30, “INFORMATION_SCHEMA ROUTINES 表”

S

[]

SCHEMA_PRIVILEGES

Section 28.3.33, “INFORMATION_SCHEMA SCHEMA_PRIVILEGES 表”

SCHEMATA

Section 12.3.3, “数据库字符集和排序规则”
Section 8.2.3, “授权表”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.13, “InnoDB 静态数据加密”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”
Section 15.7.7.15, “显示数据库语句”
Section 28.3.31, “INFORMATION_SCHEMA SCHEMATA 表”
Section 28.3.32, “INFORMATION_SCHEMA SCHEMATA_EXTENSIONS 表”

SCHEMATA_EXTENSIONS

Section 15.1.2, “更改数据库语句”
Section 28.3.31, “INFORMATION_SCHEMA SCHEMATA 表”
Section 28.3.32, “INFORMATION_SCHEMA SCHEMATA_EXTENSIONS 表”

ST_GEOMETRY_COLUMNS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 28.3.8, “INFORMATION_SCHEMA COLUMNS 表”
Section 28.3.35, “INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS 表”

ST_SPATIAL_REFERENCE_SYSTEMS

Section 15.1.19, “创建空间参考系统语句”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 13.4.5, “空间参考系统支持”
Section 28.3.36, “INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS 表”

ST_UNITS_OF_MEASURE

Section 14.16.7.3, “线串和多线串属性函数”
Section 14.16.9.1, “使用对象形状的空间关系函数”
Section 28.3.37, “INFORMATION_SCHEMA ST_UNITS_OF_MEASURE 表”

STATISTICS

Section 15.7.3.1, “ANALYZE TABLE 语句”
Section 17.8.10.2, “Configuring Non-Persistent 优化器统计 Parameters”
Section 16.7, “数据字典使用差异”
Section 15.1.20.11, “生成的不可见主键”
Section 10.9.4, “索引提示”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.14, “InnoDB 启动选项和系统变量”
Section 28.1, “简介”
Section 10.3.12, “Invisible 索引”
Section 15.7.7.23, “显示索引语句”
Section 28.3.34, “INFORMATION_SCHEMA STATISTICS 表”

T

[]

TABLE_CONSTRAINTS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.12.1, “在线 DDL 操作”
Section 28.3.25, “INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS 表”
Section 28.3.42, “INFORMATION_SCHEMA TABLE_CONSTRAINTS 表”

TABLE_CONSTRAINTS_EXTENSIONS

Section 28.3.43, “INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS 表”

TABLE_PRIVILEGES

Section 28.3.44, “INFORMATION_SCHEMA TABLE_PRIVILEGES 表”

TABLES

Section 25.6.7.3, “在线添加 NDB 集群数据节点: Detailed Example”
Section 15.1.9, “ALTER TABLE 语句”
Section 17.8.10.2, “Configuring Non-Persistent 优化器统计 Parameters”
Section 15.1.20, “CREATE TABLE 语句”
Section 16.7, “数据字典使用差异”
Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 17.9.2, “InnoDB 页面压缩”
Section 17.14, “InnoDB 启动选项和系统变量”
Section 28.1, “简介”
Section 11.2.4, “标识符到文件名的映射”

Section 16.2, “删除基于文件的元数据存储”
Section 15.1.20.12, “设置 NDB 注释选项”
Section 15.7.7.40, “显示表状态语句”
Section 15.7.7.41, “显示表语句”
Section 30.4.4.2, “The diagnostics() Procedure”
Section 28.3.38, “INFORMATION_SCHEMA TABLES 表”
Section 30.4.2.1, “sys_config 表”
Section 7.6.3.2, “线程池安装”

TABLES_EXTENSIONS

Section 28.3.39, “INFORMATION_SCHEMA TABLES_EXTENSIONS 表”

TABLESPACES_EXTENSIONS

Section 28.3.41, “INFORMATION_SCHEMA TABLESPACES_EXTENSIONS 表”

TP_THREAD_GROUP_STATE

Section 28.5, “INFORMATION_SCHEMA 线程池表”

TP_THREAD_GROUP_STATS

Section 28.5, “INFORMATION_SCHEMA 线程池表”

TP_THREAD_STATE

Section 28.5, “INFORMATION_SCHEMA 线程池表”

TRIGGERS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 3.6, “准备升级安装”
Section 15.7.7.12, “SHOW 创建触发器语句”
Section 15.7.7.42, “显示触发器语句”
Section 28.3.45, “INFORMATION_SCHEMA TRIGGERS 表”
Section 27.3.2, “触发器元数据”

U

[]

USER_ATTRIBUTES

Section 15.7.1.1, “更改用户语句”
Section 15.7.1.3, “创建用户语句”
Section 8.2.3, “授权表”
Section 28.3.46, “INFORMATION_SCHEMA USER_ATTRIBUTES 表”

USER_PRIVILEGES

Section 8.2.2, “MySQL 提供的权限”
Section 28.3.47, “INFORMATION_SCHEMA USER_PRIVILEGES 表”

V

[]

VIEW_ROUTINE_USAGE

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 28.3.49, “INFORMATION_SCHEMA VIEW_ROUTINE_USAGE 表”

VIEW_TABLE_USAGE

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 28.3.50, “INFORMATION_SCHEMA VIEW_TABLE_USAGE 表”

VIEWS

Section 16.5, “INFORMATION_SCHEMA 和数据字典集成”
Section 3.6, “准备升级安装”
Section 15.7.7.14, “显示创建视图语句”
Section 28.3.48, “INFORMATION_SCHEMA VIEWS 表”
Section 27.5.3, “可更新和可插入视图”
Section 27.5.5, “视图元数据”

PREV HOME UP NEXT