information_schema系统表——GLOBAL_STATUS and SESSION_STATUS
来源:互联网 发布:英语单词翻译软件 编辑:程序博客网 时间:2024/06/05 21:06
As of MySQL 5.7.6, the value of the show_compatibility_56
system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.5, “Server System Variables”.
As of MySQL 5.7.6, information available from the tables described here is also available from the Performance Schema. The INFORMATION_SCHEMA
tables are deprecated in preference to the Performance Schema tables and will be removed in a future MySQL release. For advice on migrating away from the INFORMATION_SCHEMA
tables to the Performance Schema tables, see Section 25.19, “Migrating to Performance Schema System and Status Variable Tables”.
The GLOBAL_STATUS
and SESSION_STATUS
tables provide information about server status variables. Their contents correspond to the information produced by the SHOW GLOBAL STATUS
and SHOW SESSION STATUS
statements (see Section 13.7.5.35, “SHOW STATUS Syntax”).
INFORMATION_SCHEMA
NameSHOW
Name- information_schema系统表——GLOBAL_STATUS and SESSION_STATUS
- information_schema系统表——CHARACTER_SETS
- information_schema系统表——COLLATIONS
- information_schema系统表——COLLATION_CHARACTER_SET_APPLICABILITY
- information_schema系统表——COLUMNS
- information_schema系统表——COLUMN_PRIVILEGES
- information_schema系统表——ENGINES
- information_schema系统表——EVENTS
- information_schema系统表——FILES
- information_schema系统表——PROCESSLIST
- information_schema系统表——TABLES
- information_schema系统表——TABLESPACES
- information_schema系统表——TABLE_CONSTRAINTS
- information_schema系统表——TABLE_PRIVILEGES
- information_schema系统表——TRIGGERS
- information_schema系统表——USER_PRIVILEGES
- Mysql information_schema系统表元数据
- MySQL元数据库——information_schema
- 金融中TA的概念
- Python与机器学习之实战(二)
- 文章标题
- tomcat加载两次项目
- 采购模块存储过程获取
- information_schema系统表——GLOBAL_STATUS and SESSION_STATUS
- 最优分解(贪心算法)
- mtcnn训练
- C语言之结构体初步了解
- 自定义带头结点的单链表类(C++)----------测试(二)
- iOS 顶部滚动标题视图SGPagingView
- 最新 Spring 4.2.2 集成 Quartz Scheduler 2.2.2 任务调度示例
- jd-gui反编译jar后清除后面的注释信息
- java.text.ParseException: Unparseable date: "Sat Nov 11 00:00:00 CST 2017"