show profile

原创已于 2022-05-10 16:13:40 修改 · 142 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

于 2020-01-14 19:10:13 首次发布

数据库专栏收录该内容

27 篇文章

订阅专栏

打开show profile开关

set profiling = 1;

查看值 show variables like "%pro%";

mysql> show profile;
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000364 |
| Waiting for query cache lock   | 0.000154 |
| checking query cache for query | 0.000154 |
| checking privileges on cached  | 0.000148 |
| checking permissions           | 0.000156 |
| checking permissions           | 0.000148 |
| checking permissions           | 0.000148 |
| sending cached result to clien | 0.000156 |
| logging slow query             | 0.000151 |
| cleaning up                    | 0.000148 |
+--------------------------------+----------+

进行性能调优