Home >Database >Mysql Tutorial >Find out slow sql of mysql_MySQL
Find out slow sql of mysql_MySQL
- WBOYOriginal
- 2016-06-01 13:31:02862browse
bitsCN.com
Find out slow sql of mysql
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.
[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.
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：为MySQL数据文件ibdata1瘦身_MySQLNext article：MYSQL命令行工具自动登录的方法_MySQL