Showing slow logs

k2tec

• June 25, 2014 12:12

I am running MySQL 5.6 and I read that the log-slow-queries = changed to slow-query-log I tried both but the mysql server did not restart. this are the changes I tried. This is the old one. log-slow-queries=/var/lib/mysql/slow_queries.log long_query_time = 3
this the new one slow-query-log=/var/lib/mysql/slow_queries.log long_query_time = 3

• 

  cPanelMichael

  • June 25, 2014 19:07

  Hello :) I believe you should use the following syntax in MySQL 5.6: slow_query_log=1 slow_query_log_file=file_name
  Reference: [url=http://dev.mysql.com/doc/refman/5.6/en/slow-query-log.html]MySQL :: MySQL 5.6 Reference Manual :: 5.2.5 The Slow Query Log Thank you.

  0
• 

  k2tec

  • June 25, 2014 20:05

  Thanks Michael, I will give it a try tomorrow.

  0
• 

  k2tec

  • June 26, 2014 18:45

  Michael This okay [QUOTE]slow_query_log=1 slow_query_log_file=file_name
  I put this also in my.cnf [QUOTE]long_query_time
  And if you want to see the queries without indexes, but this will fill your log file very fast [QUOTE]log_queries_not_using_indexes
  

  0

Please sign in to leave a comment.