记录开发过程中实际运用案例(二)
如有不足请大家多多指教
连接数分析
-- 分析连接数参数及使用情况
SHOW VARIABLES LIKE '%connect%';
-- 查看当前MYSQL库的客户端连接
SELECT SUBSTRING_INDEX(HOST, ':',1) AS HOST_NAME,STATE,COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST GROUP BY STATE,HOST_NAME;
-- 线程占用情况
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
-- 释放线程
kill 16576422;
数据库表分析
-- 表使用情况
SELECT CONCAT(table_schema, '.', table_name) AS TABLE_NAME
,engine AS TABLE_ENGINE
,table_type AS TABLE_TYPE
,table_rows