mysql之sql语句执行过程分析

最新推荐文章于 2024-09-10 14:55:57 发布

竹意雅韵（马）

最新推荐文章于 2024-09-10 14:55:57 发布

阅读量354

点赞数 6

分类专栏： mysql数据库 # mysql之sql语句优化文章标签： mysql sql 数据库

本文链接：https://blog.csdn.net/weixin_44348521/article/details/142070286

版权

mysql数据库同时被 2 个专栏收录

26 篇文章 0 订阅

订阅专栏

mysql之sql语句优化

2 篇文章 0 订阅

订阅专栏

文章目录

一：查看性能详情是否开启
二：开启性能记录功能
三：查看性能记录
四：查看语句执行的详情

一：查看性能详情是否开启

mysql> show variables like '%profiling%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| have_profiling | YES |
| profiling | OFF |
| profiling_history_size | 15 |
+------------------------+-------+

二：开启性能记录功能

set profiling = on ;

三：查看性能记录

mysql> show profiles;
+----------+------------+---------------------------------------------------+
| Query_ID | Duration | Query |
+----------+------------+---------------------------------------------------+
| 1 | 0.00177775 | show variables like '%profiling%' |
| 2 | 0.00037900 | select * from test where id='087878' |
| 3 | 0.34618025 | select * from test where servnumber='1367008787' |
| 4 | 0.31986825 | select * from test where servnumber='13670087879' |
+----------+------------+---------------------------------------------------+

四：查看语句执行的详情

mysql> show profile for query 4;
+----------------------+----------+
| Status | Duration |
+----------------------+----------+
| starting | 0.000100 |
| checking permissions | 0.000010 |
| Opening tables | 0.000023 |
| init | 0.000045 |
| System lock | 0.000015 |
| optimizing | 0.000016 |
| statistics | 0.000028 |
| preparing | 0.000020 |
| executing | 0.000006 |
| Sending data | 0.319489 |
| end | 0.000037 |
| query end | 0.000012 |
| closing tables | 0.000012 |
| freeing items | 0.000040 |
| cleaning up | 0.000017 |
+----------------------+----------+