-- 运行时间
show status LIKE 'uptime'
-- 多少次查询 com_select com_update com_insert com_delete
show GLOBAL status LIKE 'connections'
-- 默认session,从启动开始到现在GLOBAL
show [SESSION|GLOBAL] status LIKE 'com_select'
-- 显示慢查询次数 10s,才是慢查询
show status like 'slow_queries'
-- 修改mysql的慢查询为1s
set long_query_time=10
-- 修改mysql的慢查询
show VARIABLES like 'long_query_time'
show status LIKE 'uptime'
-- 多少次查询 com_select com_update com_insert com_delete
show GLOBAL status LIKE 'connections'
-- 默认session,从启动开始到现在GLOBAL
show [SESSION|GLOBAL] status LIKE 'com_select'
-- 显示慢查询次数 10s,才是慢查询
show status like 'slow_queries'
-- 修改mysql的慢查询为1s
set long_query_time=10
-- 修改mysql的慢查询
show VARIABLES like 'long_query_time'