CODEWITHSUNDEEP
mysqlprofilingserver-variables
Uday
Uday

Reputation: 1490

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

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

Upvotes: 12

Views: 9209

Answers (2)

Sean
Sean

Reputation: 767

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

Upvotes: 20

Rahul
Rahul

Reputation: 77926

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

Upvotes: 8

Related Questions