mysql5.6 常用查询sql

mysql5.6 常用查询sql

1.查询版本

mysql -uroot -p -P 3306


/*MySQL 版本*/
select  version();

2.MySQL 运行状态（Ping）

/*MySQL 运行状态（Ping）*/
SELECT 'mysqld is alive';

3.慢查询数量

/*慢查询数量*/
SHOW GLOBAL STATUS LIKE 'Slow_queries';

4.连接数

/*连接数*/
SHOW GLOBAL STATUS LIKE 'Threads_connected';

5.最大连接数

/*最大连接数*/
SHOW VARIABLES LIKE 'max_connections';

6.InnoDB 缓冲池命中率

/*InnoDB 缓冲池命中率*/
SELECT VARIABLE_VALUE AS Innodb_buffer_pool_reads, 
       (SELECT VARIABLE_VALUE FROM information_schema.global_status WHERE VARIABLE_NAME = 'Innodb_buffer_pool_read_requests') AS Innodb_buffer_pool_read_requests,
       ROUND((VARIABLE_VALUE / (SELECT VARIABLE_VALUE FROM information_schema.global_status WHERE VARIABLE_NAME = 'Innodb_buffer_pool_read_requests')) * 100, 2) AS Hit_Rate
FROM information_schema