show_compatibility_56
来源:互联网 发布:linux怎么关闭tomcat 编辑:程序博客网 时间:2024/06/07 01:31
--从mysql5.7.6开始information_schema.global_status已经开始被舍弃,为了兼容性,此时需要打开 show_compatibility_56mysql> select * from information_schema.global_status limit 3;ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'--查看show_compatibility_56其值mysql> show variables like '%show_compatibility_56%';+-----------------------+-------+| Variable_name | Value |+-----------------------+-------+| show_compatibility_56 | OFF |+-----------------------+-------+1 row in set (0.01 sec)--把show_compatibility_56打开mysql> set global show_compatibility_56=on;Query OK, 0 rows affected (0.00 sec)mysql> show variables like '%show_compatibility_56%';+-----------------------+-------+| Variable_name | Value |+-----------------------+-------+| show_compatibility_56 | ON |+-----------------------+-------+1 row in set (0.00 sec)mysql> select * from information_schema.global_status limit 3;+-----------------------+----------------+| VARIABLE_NAME | VARIABLE_VALUE |+-----------------------+----------------+| ABORTED_CLIENTS | 0 || ABORTED_CONNECTS | 0 || BINLOG_CACHE_DISK_USE | 0 |+-----------------------+----------------+3 rows in set, 1 warning (0.00 sec)In MySQL 5.6, system and status variable information is available from these SHOW statements:SHOW VARIABLESSHOW STATUSAnd from these INFORMATION_SCHEMA tables:INFORMATION_SCHEMA.GLOBAL_VARIABLESINFORMATION_SCHEMA.SESSION_VARIABLESINFORMATION_SCHEMA.GLOBAL_STATUSINFORMATION_SCHEMA.SESSION_STATUSMySQL 5.7As of MySQL 5.7.6, the Performance Schema includes these tables as new sources of system and statusvariable information:performance_schema.global_variablesperformance_schema.session_variablesperformance_schema.variables_by_threadperformance_schema.global_statusperformance_schema.session_statusperformance_schema.status_by_threadperformance_schema.status_by_accountperformance_schema.status_by_hostperformance_schema.status_by_user
1 0
- show_compatibility_56
- 实现UITextView的placeholder效果
- C++了解2
- JavaScript基础——错误处理与测试
- Spring Junit测试模板
- 从myeclipse导入eclipse导致不能识别为web项目(java项目转为web项目)
- show_compatibility_56
- jQuery.extend 函数详解
- Ehcache 整合Spring 使用页面、对象缓存
- IOS学习笔记之KVC、KVO
- MySQL锁详解
- MyBatis学习总结(2)——使用MyBatis对表执行CRUD操作
- js数组 应该注意的问题
- Posix线程编程指南(3)
- 解决Listview局部刷新,item地址复用所产生的问题