Find out slow sql of mysql
来源:互联网 发布:数控铣床编程好学吗 编辑:程序博客网 时间:2024/06/06 08:28
Recent days, I should do a sql tuning for a mysql database, and I know a bit of mysql db. In order to find the slow sql, i do the slow_query_log on to collect the slow sql.
mysql> show variables like 'slow%';+---------------------+-------------------------------------------+| Variable_name | Value |+---------------------+-------------------------------------------+| slow_launch_time | 2 || slow_query_log | ON || slow_query_log_file | /opt/mysql_data/mysql/mysql-test-slow.log |+---------------------+-------------------------------------------+3 rows in set (0.00 sec)mysql> set global slow_launch_time=5;Query OK, 0 rows affected (0.00 sec)mysql> show variables like 'slow%';+---------------------+-------------------------------------------+| Variable_name | Value |+---------------------+-------------------------------------------+| slow_launch_time | 5 || slow_query_log | ON || slow_query_log_file | /opt/mysql_data/mysql/mysql-test-slow.log |+---------------------+-------------------------------------------+3 rows in set (0.00 sec)
We can read /opt/mysql_data/mysql/mysql-test-slow.log to find slow sql.
- Find out slow sql of mysql
- Find Slow Oracle SQL
- 处理 mysql slow sql
- Free, simple code to find out what SQL statements are running slow in SQL Server right now
- find out all attributes of an object
- mysql Commands out of sync
- MySQL慢查询的两种分析方案 slow sql
- MySQL慢查询的两种分析方案 slow sql
- MySQL慢查询的两种分析方案 slow sql
- sql find out record one-to-one
- 一图解决:navicat for mysql 导入.sql大文件 报out of memory 错误
- SQL Server slow query
- mysql slow query
- MySQL Slow Query 设置
- mysql slow query
- MySQL 之 slow log
- MySQL Slow Query EXPLAIN
- MySQL 之 slow log
- hdu--1518--DFS(C&&java深搜之简单)
- PHP中CURL方法curl_setopt()函数的一些参数
- Windows文件关联和VC实现
- 几款手机点评
- 简单工厂模式
- Find out slow sql of mysql
- (转)C++ stringstream介绍,使用方法与例子
- Silverlight Business Application 与 WCF Ria Service的使用 (2)
- Struts2 从前端jsp向action传递自定义类型的链表数据
- ActionContext和ServletActionContext小结
- linux free命令详解: cache和buff的区别
- cocos2dx 使用jni方法获取android mac地址
- 旗舰机型mini化
- How to remove access point from saved list