Mysql: What is the difference between "slow_query_log" vs "log_slow_queries"

Question

If there is not any difference, why having two server parameters to achieve one behavior?

score 20 · Accepted Answer · edited May 17 '14 at 23:27

20

log_slow_queries was deprecated in MySQL 5.1.29 by slow-query-log. The MySQL 5.1 Reference Manual has more details.

edited May 17 '14 at 23:27

BenMorel

34,448
50
182
322

answered May 25 '12 at 13:23

Sean

747
4
8

score 8 · Answer 2 · answered May 25 '12 at 13:28

From mysql documentation:

The --log-slow-queries option is deprecated and is removed (along with the log_slow_queries system variable) in MySQL 5.6. Instead, use the --slow_query_log option to enable the slow query log and the --slow_query_log_file=file_name option to set the slow query log file name.

See here: http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_log-slow-queries

Mysql: What is the difference between "slow_query_log" vs "log_slow_queries"

2 Answers2