常用性能分析语句:
explain sql 语句; 查看sql执行情况
通过profile
SHOW VARIABLES LIKE 'profi%'; SELECT @@profiling; show TABLES; SHOW PROFILES ; SHOW PROFILE FOR QUERY 453; show PROFILE block io,cpu,memory,swaps FOR QUERY 561;
Powered by: 博客园 Copyright © 2024 one_stone Powered by .NET 8.0 on Kubernetes