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