Mysql 性能监控

 

 

 

 

 查看具体命令花费多长时间

SELECT * FROM `account`
show PROFILES;
show PROFILE;
SELECT * FROM `account`
show PROFILE for QUERY 48  查看第query id 为48 表的运行状态
show profile cpu  耗费系统资源
show profile all

 

 

 

-----------------------------------------------------------------------------------------------------------------------------------------------------

show VARIABLES like 'performance_schema'

 

posted @ 2022-04-27 23:05  花心大萝卜li  阅读(41)  评论(0)    收藏  举报