MySQL 5.7版本说明
C|E|F|G|我|K|米|N|O|P|R|年代|T|U|V
CHARACTER_SETS
COLLATION_CHARACTER_SET_APPLICABILITY
整理
COLUMN_PRIVILEGES
列
- 章节8.2.3,“优化INFORMATION_SCHEMA查询”
- 第13.7.5.5节,“SHOW COLUMNS语句”
- 第24.3.5节,“INFORMATION_SCHEMA列表”
- Section 24.4.2“INFORMATION_SCHEMA INNODB_BUFFER_PAGE表”
- 章节24.4.3“INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU表”
- Section 24.4.4“INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS表”
- Section 24.4.5“INNODB_CMP和INNODB_CMP_RESET表的信息模式”
- Section 24.4.7“INNODB_CMP_PER_INDEX和INNODB_CMP_PER_INDEX_RESET表的信息模式”
- Section 24.4.6“INNODB_CMPMEM和INNODB_CMPMEM_RESET表的信息模式”
- Section 24.4.8,“INFORMATION_SCHEMA INNODB_FT_BEING_DELETED表”
- 章节24.4.9,“INNODB_FT_CONFIG信息模式表”
- Section 24.4.10“INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD表”
- Section 24.4.11,“INFORMATION_SCHEMA INNODB_FT_DELETED表”
- Section 24.4.12,“INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE表”
- Section 24.4.13,“INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE表”
- Section 24.4.15“INFORMATION_SCHEMA INNODB_LOCK_WAITS表”
- Section 24.4.14“INFORMATION_SCHEMA INNODB_LOCKS表”
- Section 24.4.16,“INFORMATION_SCHEMA INNODB_METRICS表”
- Section 24.4.17“INFORMATION_SCHEMA INNODB_SYS_COLUMNS表”
- Section 24.4.18,“INFORMATION_SCHEMA INNODB_SYS_DATAFILES表”
- Section 24.4.19“INFORMATION_SCHEMA INNODB_SYS_FIELDS表”
- Section 24.4.20,“INFORMATION_SCHEMA INNODB_SYS_FOREIGN表”
- Section 24.4.21“INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS表”
- Section 24.4.22,“INFORMATION_SCHEMA INNODB_SYS_INDEXES表”
- Section 24.4.23,“INFORMATION_SCHEMA INNODB_SYS_TABLES表”
- 第24.4.24节“INFORMATION_SCHEMA INNODB_SYS_TABLESPACES表”
- Section 24.4.25,“INFORMATION_SCHEMA INNODB_SYS_TABLESTATS视图”
- Section 24.4.26,“INFORMATION_SCHEMA INNODB_SYS_VIRTUAL表”
- Section 24.4.27“INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO表”
- Section 24.4.28“INFORMATION_SCHEMA INNODB_TRX表”
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
引擎
事件
文件
- 章节21.6.16,“NDB集群的INFORMATION_SCHEMA表”
- 章节21.6.11.1,“NDB集群磁盘数据对象”
- 21.6.15节“ndbinfo: NDB集群信息数据库”
- 章节6.2.2,“MySQL提供的特权”
- Section 24.3.9,“INFORMATION_SCHEMA FILES表”
- Section 24.4.18,“INFORMATION_SCHEMA INNODB_SYS_DATAFILES表”
- 第24.4.24节“INFORMATION_SCHEMA INNODB_SYS_TABLESPACES表”
- 章节24.3.26,“INFORMATION_SCHEMA TABLESPACES Table”
GLOBAL_STATUS
GLOBAL_VARIABLES
INFORMATION_SCHEMA
INFORMATION_SCHEMA。CHARACTER_SETS
INFORMATION_SCHEMA。整理
INFORMATION_SCHEMA。列
INFORMATION_SCHEMA。引擎
INFORMATION_SCHEMA。事件
INFORMATION_SCHEMA。文件
- 第13.1.5节,ALTER LOGFILE GROUP语句
- 第13.1.9节,ALTER TABLESPACE语句
- 第13.1.15节“创建LOGFILE组语句”
- 第13.1.19节,创建表空间语句
- 第21.6.11.3节“NDB集群磁盘数据存储要求”
- 第21.5.10节,“ndb_desc -描述NDB表”
- 章节14.16.8,“从INFORMATION_SCHEMA中检索InnoDB表空间元数据。”文件”
- 节21.6.15.15“ndbinfo dict_obj_info表”
- 第21.6.15.23节“ndbinfo logbuffers表”
- 第21.6.15.24节“ndbinfo logspaces表”
- 第14.6.3.5节“临时表空间”
INFORMATION_SCHEMA。GLOBAL_STATUS
INFORMATION_SCHEMA。INNODB_BUFFER_PAGE
INFORMATION_SCHEMA。INNODB_CMP
INFORMATION_SCHEMA。INNODB_CMP_PER_INDEX
INFORMATION_SCHEMA。INNODB_CMPMEM
INFORMATION_SCHEMA。INNODB_FT_CONFIG
INFORMATION_SCHEMA。我NNODB_FT_DEFAULT_STOPWORD
INFORMATION_SCHEMA。我NNODB_FT_INDEX_CACHE
INFORMATION_SCHEMA。我NNODB_FT_INDEX_TABLE
INFORMATION_SCHEMA。INNODB_LOCK_WAITS
INFORMATION_SCHEMA。INNODB_LOCKS
INFORMATION_SCHEMA。INNODB_METRICS
INFORMATION_SCHEMA。INNODB_SYS_INDEXES
INFORMATION_SCHEMA。INNODB_SYS_TABLES
INFORMATION_SCHEMA。INNODB_SYS_TABLESPACES
INFORMATION_SCHEMA。INNODB_SYS_TABLESTATS
INFORMATION_SCHEMA。我NNODB_TEMP_TABLE_INFO
INFORMATION_SCHEMA。INNODB_TRX
INFORMATION_SCHEMA。KEY_COLUMN_USAGE
INFORMATION_SCHEMA。米YSQL_FIREWALL_USERS
INFORMATION_SCHEMA。米YSQL_FIREWALL_WHITELIST
INFORMATION_SCHEMA。分区
INFORMATION_SCHEMA。插件
- 章节6.4.2.1,“连接控制插件安装”
- 第14.14节“InnoDB静态数据加密”
- 章节5.5.1,“安装和卸载插件”
- 章节6.4.5.2“安装或卸载MySQL企业审计”
- 章节6.4.4.10,“密匙环元数据”
- 章节6.4.4.1,“Keyring插件安装”
- 章节6.4.1.9,“LDAP可插式身份验证”
- 章节6.4.1.10“无登录可插拔认证”
- 章节5.5.2“获取服务器插件信息”
- 第6.4.1.7节,“PAM可插入身份验证”
- 22章,分区
- 章节6.4.3.1,“密码验证插件安装”
- 章节21.6.17“快速参考:NDB集群SQL语句”
- 第16.3.9.2节,“半同步复制的安装和配置”
- 章节6.4.1.11,“套接字对等凭据可插拔身份验证”
- 第6.4.1.12节,“测试可插拔身份验证”
- 5.5.3.2“线程池安装”
- 第6.4.1.8节,“Windows可插式身份验证”
INFORMATION_SCHEMA。PROCESSLIST
INFORMATION_SCHEMA。例程
INFORMATION_SCHEMA。SESSION_STATUS
INFORMATION_SCHEMA。统计数据
INFORMATION_SCHEMA。TABLE_CONSTRAINTS
INFORMATION_SCHEMA。表
INFORMATION_SCHEMA。触发器
INFORMATION_SCHEMA。的观点
INNODB_BUFFER_PAGE
- 第14.5.2节,“更改缓冲区”
- 章节14.16.5,InnoDB INFORMATION_SCHEMA缓冲池表
- 第26.1节,“使用sys模式的先决条件”
- Section 24.4.2“INFORMATION_SCHEMA INNODB_BUFFER_PAGE表”
- 章节24.4.3“INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU表”
- 第26.4.3.7节“innodb_buffer_stats_by_schema和x$innodb_buffer_stats_by_schema视图”
- 第26.4.3.8节,innodb_buffer_stats_by_table和x$innodb_buffer_stats_by_table视图
INNODB_BUFFER_PAGE_LRU
INNODB_BUFFER_POOL_STATS
INNODB_CMP
INNODB_CMP_PER_INDEX
INNODB_CMP_PER_INDEX_RESET
INNODB_CMP_RESET
INNODB_CMPMEM
INNODB_CMPMEM_RESET
INNODB_FT_BEING_DELETED
INNODB_FT_CONFIG
INNODB_FT_DEFAULT_STOPWORD
INNODB_FT_DELETED
INNODB_FT_INDEX_CACHE
INNODB_FT_INDEX_TABLE
INNODB_LOCK_WAITS
INNODB_LOCKS
INNODB_METRICS
INNODB_SYS_COLUMNS
INNODB_SYS_DATAFILES
INNODB_SYS_FIELDS
INNODB_SYS_FOREIGN
INNODB_SYS_FOREIGN_COLS
INNODB_SYS_INDEXES
INNODB_SYS_TABLES
INNODB_SYS_TABLESPACES
INNODB_SYS_TABLESTATS
INNODB_SYS_VIRTUAL
INNODB_TEMP_TABLE_INFO
INNODB_TRX
MYSQL_FIREWALL_USERS
MYSQL_FIREWALL_WHITELIST
NDB_TRANSID_MYSQL_CONNECTION_MAP
ndb_transid_mysql_connection_map
OPTIMIZER_TRACE
参数
分区
插件
PROCESSLIST
- 章节8.14.1,“访问过程列表”
- 第13.7.6.4节“KILL声明”
- 第8.8.4节“获取命名连接的执行计划信息”
- 第25.12.11节,“性能模式复制表”
- 章节14.16.2.3,InnoDB事务和锁信息的持久性和一致性
- 第13.7.5.29节“SHOW PROCESSLIST语句”
- Section 24.4.28“INFORMATION_SCHEMA INNODB_TRX表”
- 章节24.3.18,“INFORMATION_SCHEMA PROCESSLIST表”
- 第26.4.3.22节,processlist和x$processlist视图
- 第25.12.16.3节,“processlist表”
- 第25.12.16.4节“线程表”
- 章节14.16.2.1,使用InnoDB事务和锁定信息