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'