登录

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

方式一

修改配置

vim /etc/my.cnf

[mysqld]
slow_query_log = ON   #开启
slow_query_log_file = /xxx/slow.log  #存放目录
long_query_time = 1   #超过1秒记录

service mysqld restart#重启

查

mysql> show variables like 'slow_query%';
+---------------------+-------------------------------+
| Variable_name       | Value                         |
+---------------------+-------------------------------+
| slow_query_log      | ON                            |
| slow_query_log_file | /var/lib/mysql/mysql_slow.log |
+---------------------+-------------------------------+
2 rows in set (0.00 sec)

mysql> show variables like 'long_query_time';
+-----------------+----------+
| Variable_name   | Value    |
+-----------------+----------+
| long_query_time | 3.000000 |
+-----------------+----------+
1 row in set (0.00 sec)

方式二

mysql> set global slow_query_log='ON';
Query OK, 0 rows affected (0.00 sec)

mysql> set global slow_query_log_file='/xxx/slow.log';
Query OK, 0 rows affected (0.00 sec)

mysql> set global long_query_time=1;
Query OK, 0 rows affected (0.00 sec)

测试

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

退出

mysql> quit