Skip to content

Instantly share code, notes, and snippets.

@mathewjosephh

mathewjosephh/Enabling Mysql Query Logging

Created March 10, 2015 10:28
Show Gist options
  • Save mathewjosephh/182d48a9f16c0e4d3394 to your computer and use it in GitHub Desktop.
Save mathewjosephh/182d48a9f16c0e4d3394 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Enabling Mysql Query Logging
# Set Slow Query Log
long_query_time = 1
slow_query_log = 1
slow_query_log_file = D:/wamp/logs/slowquery.log
log_queries_not_using_indexes = 1
#Set General Log
general_log = on
general_log_file=D:/wamp/logs/general.log
#Note that enabling general_log on a production server has overhead you should avoid it.
#You can check problematic queries from slow log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment