登录

mysql -hhost -uroot -p #host:ip root:账号 p:输入密码

方式一

修改配置

vim /etc/my.cnfnn[mysqld]nslow_query_log = ON #开启nslow_query_log_file = /xxx/slow.log #存放目录nlong_query_time = 1 #超过1秒记录nnservice mysqld restart#重启

查

mysql> show variables like 'slow_query%';n+---------------------+-------------------------------+n| Variable_name | Value |n+---------------------+-------------------------------+n| slow_query_log | ON |n| slow_query_log_file | /var/lib/mysql/mysql_slow.log |n+---------------------+-------------------------------+n2 rows in set (0.00 sec)nnmysql> show variables like 'long_query_time';n+-----------------+----------+n| Variable_name | Value |n+-----------------+----------+n| long_query_time | 3.000000 |n+-----------------+----------+n1 row in set (0.00 sec)

方式二

mysql> set global slow_query_log='ON';nQuery OK, 0 rows affected (0.00 sec)nnmysql> set global slow_query_log_file='/xxx/slow.log';nQuery OK, 0 rows affected (0.00 sec)nnmysql> set global long_query_time=1;nQuery OK, 0 rows affected (0.00 sec)

测试

mysql> select sleep(2);nls /xxx/slow.log

退出

mysql> quit