show profiles 分析sql耗时瓶颈

查看是否开启 profiling 功能

show variables like  '%profiling%';

或者

select @@profiling;

开启profiling功能

set profiling=on;

执行需要分析的SQL语句

查看结果

mysql> show profiles; -- 列出所有的分析结果
+----------+------------+-----------------------------------+
| Query_ID | Duration   | Query                             |
+----------+------------+-----------------------------------+
|        1 | 0.01071200 | show variables like '%profiling%' |
|        2 | 0.01594600 | show databases                    |
|        3 | 0.00584000 | SELECT DATABASE()                 |
|        4 | 0.00047300 | show databases                    |
|        5 | 0.00067100 | show tables                       |
|        6 | 0.00031100 | show tables                       |
+----------+------------+-----------------------------------+
6 rows in set, 1 warning (0.00 sec)

查看 Query_ID 为 1 的sql语句信息

show profile for query 1;

查看详细信息

show profile all for query 1;