回答

收藏

mysql 如何查看sql语句执行时间

Mysql专区 Mysql专区 958 人阅读 | 0 人回复 | 2021-09-04

查看执行时间

1 show profiles;
2 show variables;查看profiling 是否是on状态;
3 如果是off,则 set profiling = 1;
4 执行自己的sql语句;
5 show profiles;就可以查到sql语句的执行时间;
实例操作:
[Bash shell] 纯文本查看 复制代码
mysql> show variables like '%profiling%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| have_profiling         | YES   |
| profiling              | ON    |
| profiling_history_size | 15    |
+------------------------+-------+
3 rows in set (0.14 sec)

如果 profiling 是off,  则

mysql> set profiling=1;


执行自己的 sql 语句后

mysql> show  profiles;
+----------+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query_ID | Duration    | Query                                                                                                                                                                                                                                                                                                      |
+----------+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|        1 | 55.04466800 | select a.s*****************otScore, a.hot_star as hotLevel, b.title as itemName, b.pic_url as picUrl,
     ifnull(b.cprice,b.sprice) as price, b.first_day_sale as sale
     from ( select item_id, shop_id, zhiyi_tag, hot_score, hot_s |
分享到:
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

351 积分
40 主题