清风 mysql_linux下配置Mysql SLOW QUERY LOG

1.Stop MySQL service

[root@localhost /]# /etc/init.d/mysql stop

Shutting down

MySQL.. [ OK ]

2.Check /var/lib/mysql下是否存在mysql_slow.log文件

[root@localhost mysql]# pwd

/var/lib/mysql

[root@localhost mysql]# ls -l mysql_slow.log

ls: mysql_slow.log: No such file or directory

3.新建或者编辑my.cnf

[root@localhost etc]# vi my.cnf

[mysqld]

log-output=FILE

slow_query_log_file=/var/lib/mysql/mysql_slow.log

long-query-time=1

log-queries-not-using-indexes

4.检查权限

[root@localhost etc]# ls -l |grep my.cnf

-rw-r--r-- 1 root

root 111 Dec 7 02:32 my.cnf

5.重启MySQL Service

[root@localhost etc]# /etc/init.d/mysqld restart

Shutting down

MySQL...... [ OK ]

Starting

MySQL. [ OK ]

6.连接上MySQL，查看是否开启slow_query_log

mysql> show variables like

'%slow_query_log%';

+---------------------+-----------------------------------+

|

Variable_name |

Value |

+---------------------+-----------------------------------+

|

slow_query_log |

OFF |

| slow_query_log_file | /var/lib/mysql/localhost-slow.log |

+---------------------+-----------------------------------+

7.如果没有打开，请开启slow_query_log

mysql> set @@global.slow_query_log = on;

8.再次检查是否开启成功

mysql> show variables like

'%slow_query_log%';

+---------------------+-----------------------------------+

|

Variable_name |

Value |

+---------------------+-----------------------------------+

|

slow_query_log |

ON |

| slow_query_log_file | /var/lib/mysql/mysql_slow.log |

+---------------------+-----------------------------------+

9.检查当前/var/lib/mysql目录下是否存在mysql_slow.log(现在已经存在该文件)

[root@localhost mysql]# ls -l mysql_slow.log

-rw-rw---- 1 mysql mysql 189

Dec 7 03:14 mysql_slow.log