Skip to content

Instantly share code, notes, and snippets.

@timglabisch

timglabisch/gist:3486822

Created August 27, 2012 09:09
Show Gist options
  • Save timglabisch/3486822 to your computer and use it in GitHub Desktop.
Save timglabisch/3486822 to your computer and use it in GitHub Desktop.
Download ZIP
mysql enable logging
Raw
gistfile1.sql
SET GLOBAL Profiling = "ON";
SET GLOBAL log_output = "TABLE";
SET GLOBAL long_query_time = 1;
SET GLOBAL log_queries_not_using_indexes = "ON";
SET GLOBAL general_log = "ON";
SET GLOBAL slow_query_log = "ON";
SET GLOBAL min_examined_row_limit = 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment