Mysql动态打开日志 show profiles详细信息
来源:互联网 发布:无锡源石数据招聘骗局 编辑:程序博客网 时间:2024/05/21 22:23
查看表索引 show index from t_user; show keys from t_user; 动态打开general 日志 show global variables like '%general%'; set global general_log = on; 动态打开slow 日志 show global variables like '%slow%'; set global slow_query_log = on; set global long_query_time = 0.2; set profiling = on; 或set profiling = 1;reset query cacheshow profile ;show profiles;mysql> select @@profiling;+-------------+| @@profiling |+-------------+| 0 |+-------------+show profiles;+----------+----------+-------------------------------------+| Query_ID | Duration | Query |+----------+----------+-------------------------------------+| 0 | 0.000045 | set profiling = 1 || 1 | 0.000071 | select @@profiling || 2 | 0.000087 | drop table if exists t1 || 3 | 0.031741 | create table t1 (id int not null) || 4 | 0.000615 | insert into t1 values (1), (2), (3) || 5 | 0.000198 | select * from t1 |+----------+----------+-------------------------------------+根据query_id 查看某个查询的详细时间耗费mysql> show profile for query 2;+----------------------+----------+| Status | Duration |+----------------------+----------+| starting | 0.000231 || checking permissions | 0.000015 || checking permissions | 0.000010 || checking permissions | 0.000010 || checking permissions | 0.000014 || Opening tables | 0.000118 || init | 0.000051 || System lock | 0.000023 || optimizing | 0.000012 || optimizing | 0.000019 || statistics | 0.000039 || preparing | 0.000034 || Sorting result | 0.000029 || statistics | 0.000070 || preparing | 0.000034 || Creating tmp table | 0.000038 || Sorting result | 0.000048 || executing | 0.000025 || Sending data | 0.016414 || executing | 0.000015 || Sending data | 0.536580 || Creating sort index | 0.000353 || end | 0.000014 || removing tmp table | 0.000018 || end | 0.000014 || query end | 0.000017 || closing tables | 0.000011 || removing tmp table | 0.000176 || closing tables | 0.000031 || freeing items | 0.001331 || logging slow query | 0.000084 || cleaning up | 0.000028 |+----------------------+----------+32 rows in set, 1 warning (0.00 sec)mysql> show profile cpu for query 2;+----------------------+----------+----------+------------+| Status | Duration | CPU_user | CPU_system |+----------------------+----------+----------+------------+| starting | 0.000231 | 0.000000 | 0.000000 || checking permissions | 0.000015 | 0.000000 | 0.000000 || checking permissions | 0.000010 | 0.000000 | 0.000000 || checking permissions | 0.000010 | 0.000000 | 0.000000 || checking permissions | 0.000014 | 0.000000 | 0.000000 || Opening tables | 0.000118 | 0.000000 | 0.000000 || init | 0.000051 | 0.000000 | 0.000000 || System lock | 0.000023 | 0.000000 | 0.000000 || optimizing | 0.000012 | 0.000000 | 0.000000 || optimizing | 0.000019 | 0.000000 | 0.000000 || statistics | 0.000039 | 0.000000 | 0.000000 || preparing | 0.000034 | 0.000000 | 0.000000 || Sorting result | 0.000029 | 0.000000 | 0.000000 || statistics | 0.000070 | 0.000000 | 0.000000 || preparing | 0.000034 | 0.000000 | 0.000000 || Creating tmp table | 0.000038 | 0.000000 | 0.000000 || Sorting result | 0.000048 | 0.000000 | 0.000000 || executing | 0.000025 | 0.000000 | 0.000000 || Sending data | 0.016414 | 0.015998 | 0.000000 || executing | 0.000015 | 0.000000 | 0.000000 || Sending data | 0.536580 | 0.539917 | 0.000000 || Creating sort index | 0.000353 | 0.000000 | 0.000000 || end | 0.000014 | 0.000000 | 0.000000 || removing tmp table | 0.000018 | 0.000000 | 0.000000 || end | 0.000014 | 0.000000 | 0.000000 || query end | 0.000017 | 0.000000 | 0.000000 || closing tables | 0.000011 | 0.000000 | 0.000000 || removing tmp table | 0.000176 | 0.000000 | 0.000000 || closing tables | 0.000031 | 0.000000 | 0.000000 || freeing items | 0.001331 | 0.001000 | 0.000000 || logging slow query | 0.000084 | 0.000000 | 0.000000 || cleaning up | 0.000028 | 0.000000 | 0.000000 |+----------------------+----------+----------+------------+32 rows in set, 1 warning (0.00 sec)mysql> show profile source for query 2;+----------------------+----------+---------------------------+------------------+-------------+| Status | Duration | Source_function | Source_file | Source_line |+----------------------+----------+---------------------------+------------------+-------------+| starting | 0.000231 | NULL | NULL | NULL || checking permissions | 0.000015 | check_access | sql_parse.cc | 5297 || checking permissions | 0.000010 | check_access | sql_parse.cc | 5297 || checking permissions | 0.000010 | check_access | sql_parse.cc | 5297 || checking permissions | 0.000014 | check_access | sql_parse.cc | 5297 || Opening tables | 0.000118 | open_tables | sql_base.cc | 5069 || init | 0.000051 | mysql_prepare_select | sql_select.cc | 1050 || System lock | 0.000023 | mysql_lock_tables | lock.cc | 304 || optimizing | 0.000012 | optimize | sql_optimizer.cc | 138 || optimizing | 0.000019 | optimize | sql_optimizer.cc | 138 || statistics | 0.000039 | optimize | sql_optimizer.cc | 362 || preparing | 0.000034 | optimize | sql_optimizer.cc | 485 || Sorting result | 0.000029 | make_tmp_tables_info | sql_select.cc | 5307 || statistics | 0.000070 | optimize | sql_optimizer.cc | 362 || preparing | 0.000034 | optimize | sql_optimizer.cc | 485 || Creating tmp table | 0.000038 | create_intermediate_table | sql_executor.cc | 210 || Sorting result | 0.000048 | make_tmp_tables_info | sql_select.cc | 5307 || executing | 0.000025 | exec | sql_executor.cc | 110 || Sending data | 0.016414 | exec | sql_executor.cc | 190 || executing | 0.000015 | exec | sql_executor.cc | 110 || Sending data | 0.536580 | exec | sql_executor.cc | 190 || Creating sort index | 0.000353 | sort_table | sql_executor.cc | 2504 || end | 0.000014 | mysql_execute_select | sql_select.cc | 1105 || removing tmp table | 0.000018 | free_tmp_table | sql_tmp_table.cc | 1868 || end | 0.000014 | free_tmp_table | sql_tmp_table.cc | 1897 || query end | 0.000017 | mysql_execute_command | sql_parse.cc | 4996 || closing tables | 0.000011 | mysql_execute_command | sql_parse.cc | 5044 || removing tmp table | 0.000176 | free_tmp_table | sql_tmp_table.cc | 1868 || closing tables | 0.000031 | free_tmp_table | sql_tmp_table.cc | 1897 || freeing items | 0.001331 | mysql_parse | sql_parse.cc | 6433 || logging slow query | 0.000084 | log_slow_do | sql_parse.cc | 1874 || cleaning up | 0.000028 | dispatch_command | sql_parse.cc | 1778 |+----------------------+----------+---------------------------+------------------+-------------+32 rows in set, 1 warning (0.00 sec)
0 0
- Mysql动态打开日志 show profiles详细信息
- MySQL Error :SHOW PROFILES
- MySQL Query Profiler 的使用 show profiles
- mysql show profiles 使用分析sql 性能
- MySQL查找SQL耗时瓶颈 SHOW profiles
- MySQL查找SQL耗时瓶颈 SHOW profiles
- mysql show profiles 使用分析sql 性能
- mysql show profiles使用分析sql性能
- mysql show profiles 使用分析sql 性能
- mysql show profiles 查看sql语句性能
- mysql show profiles 使用分析sql 性能
- MYSQL性能分析之show profiles
- MySQL性能分析语句 show profile/show profiles
- mysql中的show profiles在5.6.14版本被丢弃
- mysql运维与分析-性能分析工具-show profiles
- mysql profiles
- mysql日志打开
- mysql打开如何日志
- poj 1251 Jungle Roads
- 【VR】Leap Motion 官网文档 LeapRecorder (Leap记录器)
- hdu 1465 不容易系列之一(递推。错排公式)
- Supesite配置错误
- 软件测试、ios中的测试概念以及步骤
- Mysql动态打开日志 show profiles详细信息
- POJ3050Hopscotch【dfs 暴搜水题】
- HDU 1863 畅通工程 (克鲁斯卡尔—最小生成树)
- hdu 3309 Roll The Cube(bfs)
- java学习之数组(二)
- HTML5入门-2
- Ubuntu下忘记MySQL root密码解决方法
- 克鲁斯卡尔求最小生成树
- poj 3171 rmq+dp