I tried with Percona Server 5.5.55 via yum install on debian wheezy and I found really strange behavior.
mysql> show global variables like '%version%';
+-------------------------+------------------------------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------------------------------+
| innodb_version | 5.5.55-38.8 |
| protocol_version | 10 |
| slave_type_conversions | |
| tls_version | TLSv1.1,TLSv1.2 |
| version | 5.5.55-38.8-log |
| version_comment | Percona Server (GPL), Release 38.8, Revision 11f5bbd |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+------------------------------------------------------+
I un-commented below line from default my.cnf
log_slow_queries = /var/log/mysql/mysql-slow.log
After Percona Server restart
mysql> show global variables like '%slow%';
+------------------------------------+-------------------------------+
| Variable_name | Value |
+------------------------------------+-------------------------------+
| log_slow_admin_statements | OFF |
| log_slow_filter | |
| log_slow_queries | ON |
| log_slow_rate_limit | 1 |
| log_slow_rate_type | session |
| log_slow_slave_statements | OFF |
| log_slow_sp_statements | ON |
| log_slow_verbosity | |
| max_slowlog_files | 0 |
| max_slowlog_size | 0 |
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_always_write_time | 10.000000 |
| slow_query_log_file | /var/log/mysql/mysql-slow.log |
| slow_query_log_timestamp_always | OFF |
| slow_query_log_timestamp_precision | second |
| slow_query_log_use_global_control | |
+------------------------------------+-------------------------------+
17 rows in set (0.00 sec)
Slow query log enabled despite of it's disabled from slow log. Further, log_slow_queries should accept ON|OFF bit instead showing value for slow_query_log_file. Other than that, log_slow_queries should be removed completely as slow_query_log is the correct parameter to enable slow log. I'm going to open new bug report for this and this is true for upstream too.
Despite of all those MySQL server restart should be failing as monitored in version 5.6 for deprecated variable log_slow_queries
I tried with Percona Server 5.5.55 via yum install on debian wheezy and I found really strange behavior.
mysql> show global variables like '%version%'; ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ----+ ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ----+ conversions | | compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ----+
+------
| Variable_name | Value |
+------
| innodb_version | 5.5.55-38.8 |
| protocol_version | 10 |
| slave_type_
| tls_version | TLSv1.1,TLSv1.2 |
| version | 5.5.55-38.8-log |
| version_comment | Percona Server (GPL), Release 38.8, Revision 11f5bbd |
| version_
| version_compile_os | debian-linux-gnu |
+------
I un-commented below line from default my.cnf
log_slow_queries = /var/log/ mysql/mysql- slow.log
After Percona Server restart
mysql> show global variables like '%slow%'; ------- ------- ------- ------- --+---- ------- ------- ------- ------+ ------- ------- ------- ------- --+---- ------- ------- ------- ------+ admin_statement s | OFF | slave_statement s | OFF | sp_statements | ON | log_always_ write_time | 10.000000 | mysql/mysql- slow.log | log_timestamp_ always | OFF | log_timestamp_ precision | second | log_use_ global_ control | | ------- ------- ------- ------- --+---- ------- ------- ------- ------+
+------
| Variable_name | Value |
+------
| log_slow_
| log_slow_filter | |
| log_slow_queries | ON |
| log_slow_rate_limit | 1 |
| log_slow_rate_type | session |
| log_slow_
| log_slow_
| log_slow_verbosity | |
| max_slowlog_files | 0 |
| max_slowlog_size | 0 |
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_
| slow_query_log_file | /var/log/
| slow_query_
| slow_query_
| slow_query_
+------
17 rows in set (0.00 sec)
Slow query log enabled despite of it's disabled from slow log. Further, log_slow_queries should accept ON|OFF bit instead showing value for slow_query_ log_file. Other than that, log_slow_queries should be removed completely as slow_query_log is the correct parameter to enable slow log. I'm going to open new bug report for this and this is true for upstream too.
Despite of all those MySQL server restart should be failing as monitored in version 5.6 for deprecated variable log_slow_queries