Showing posts with label Enable Slow Query Logging. Show all posts
Showing posts with label Enable Slow Query Logging. Show all posts

Monday, October 19

Enable Slow Query Logging in mysql 5.6

This tutorial will show you the settings you need to make in order to enable slow query logging
  • slow_query_log = 1 <0|1>
  • log-queries-not-using-indexes <if you want to log all queries that don't use indexes>
  • long_query_time=1 <Set this to the number of seconds a query must take to be considered "slow">
  • log-slow-queries=/var/log/mysql/log-slow-queries.log <Log file path>