MySQL Query Profiler使用
来源:互联网 发布:网络软营销 编辑:程序博客网 时间:2024/06/06 04:27
MySQL 5.0.37版本加入了MySQL Query Profiler工具。
http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html
简单的实例
mysql> set profiling=1;
Query OK, 0 rows affected (0.04 sec)
mysql> show profiles;
Empty set (0.00 sec)
mysql> SELECT COUNT(nickname), gender FROM users GROUP BY gender;
+-----------------+--------+
| COUNT(nickname) | gender |
+-----------------+--------+
| 106773 | 0 |
| 106462 | 1 |
+-----------------+--------+
2 rows in set (0.88 sec)
mysql> show profiles;
+----------+------------+-----------------------------------------------------------+
| Query_ID | Duration | Query |
+----------+------------+-----------------------------------------------------------+
| 1 | 0.88324700 | SELECT COUNT(nickname), gender FROM users GROUP BY gender |
+----------+------------+-----------------------------------------------------------+
1 row in set (0.03 sec)
mysql> show profile for query 1;
+----------------------+-----------+
| Status | Duration |
+----------------------+-----------+
| (initialization) | 0.0000699 |
| Opening tables | 0.000039 |
| System lock | 0.000008 |
| Table lock | 0.000014 |
| init | 0.000043 |
| optimizing | 0.000396 |
| statistics | 0.000024 |
| preparing | 0.000079 |
| Creating tmp table | 0.000118 |
| executing | 0.000008 |
| Copying to tmp table | 0.871251 |
| Sorting result | 0.000063 |
| Sending data | 0.009601 |
| end | 0.000017 |
| removing tmp table | 0.000028 |
| end | 0.000009 |
| query end | 0.000006 |
| freeing items | 0.000015 |
| closing tables | 0.001449 |
| logging slow query | 0.000009 |
+----------------------+-----------+
20 rows in set (0.02 sec)
mysql>show profile cpu for query 1;
+----------------------+-----------+-----------+------------+
| Status | Duration | CPU_user | CPU_system |
+----------------------+-----------+-----------+------------+
| (initialization) | 0.0000699 | 0 | 0 |
| Opening tables | 0.000039 | 0 | 0 |
| System lock | 0.000008 | 0 | 0 |
| Table lock | 0.000014 | 0 | 0 |
| init | 0.000043 | 0 | 0.001 |
| optimizing | 0.000396 | 0 | 0 |
| statistics | 0.000024 | 0 | 0 |
| preparing | 0.000079 | 0 | 0 |
| Creating tmp table | 0.000118 | 0 | 0 |
| executing | 0.000008 | 0 | 0 |
| Copying to tmp table | 0.871251 | 0.59391 | 0.253961 |
| Sorting result | 0.000063 | 0 | 0 |
| Sending data | 0.009601 | 0.001 | 0.003 |
| end | 0.000017 | 0 | 0 |
| removing tmp table | 0.000028 | 0 | 0 |
| end | 0.000009 | 0 | 0 |
| query end | 0.000006 | 0 | 0 |
| freeing items | 0.000015 | 0 | 0 |
| closing tables | 0.001449 | 0.0009990 | 0.001 |
| logging slow query | 0.000009 | 0 | 0 |
+----------------------+-----------+-----------+------------+
20 rows in set (0.00 sec)
mysql> set profiling=0;
Query OK, 0 rows affected (0.00 sec)
- 顶
- 使用mysql query profiler
- MySQL Query Profiler使用
- MySQL Query Profiler 的使用 show profiles
- MYSQL自带工具Query Profiler使用
- MySQL Query Profiler
- Mysql Query Profiler
- MySQL Query Profiler
- MySQL Query Profiler的使用方法
- Using the New MySQL Query Profiler
- 使用SQL Query Analyzer和SQL Profiler
- 使用SQL Query Analyzer和SQL Profiler
- MySQL Query Profiler 查看Mysql具体执行时间以及资源占用
- MySQL Query Profiler(性能分析工具)的使用方法
- MySQL Query Profile 简单使用
- MySQL Query Profile 简单使用
- 【mysql】mysql query cache配置与使用
- [MySQL优化] -- 如何使用SQL Profiler 性能分析器
- 使用pt-query-digest分析mysql slow query log
- maven项目打包成可执行的jar
- mysql插入一条数据,返回其对应的id
- viewpager加载fragment 时加载多页
- 明朝首辅/太师,辅佐明朝四代国之重臣杨士奇后世传人在松滋
- 嵌入式linux+ARM 4
- MySQL Query Profiler使用
- vue初学 v-if
- Zookeeper异常ConnectionLossException解决
- Flask专题之注册接口开发
- 《数据结构实战》中缀表达式转后缀表达式----栈的应用
- 架构设计之Spring-Session分布式集群会话管理
- 嵌入式linux+ARM 5
- Vue.js学习之路—环境配置
- jquery 杂七杂八小方法