Mysql5.6开启慢查询日志

[root@slave1 logs]# cat /etc/my.cnf 
[mysqld]
basedir=/usr/local/mysql/  
datadir=/usr/local/mysql/data/ 
user=mysql
#打开慢查询日志
slow_query_log=on
#慢查询日志的位置
slow_query_log_file=/usr/local/mysql/logs/mysql-slow
#慢查询的基准线超过5s的查询将会被记录
long_query_time=5

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin=/usr/local/mysql/logs/mysql-bin
server-id=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql]
socket=/var/lib/mysql/mysql.sock

[root@slave1 logs]# /etc/init.d/mysqld restart
[root@slave1 logs]# mysql -uroot -p
mysql> show variables like '%query%';
+------------------------------+----------------------------------+
| Variable_name                | Value                            |
+------------------------------+----------------------------------+
| binlog_rows_query_log_events | OFF                              |
| ft_query_expansion_limit     | 20                               |
| have_query_cache             | YES                              |
| long_query_time              | 5.000000                         |
| query_alloc_block_size       | 8192                             |
| query_cache_limit            | 1048576                          |
| query_cache_min_res_unit     | 4096                             |
| query_cache_size             | 1048576                          |
| query_cache_type             | OFF                              |
| query_cache_wlock_invalidate | OFF                              |
| query_prealloc_size          | 8192                             |
| slow_query_log               | ON