Skip to content

Instantly share code, notes, and snippets.

@jayjanssen

jayjanssen/gist:3453904

Last active January 30, 2019 03:44
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jayjanssen/3453904 to your computer and use it in GitHub Desktop.
Save jayjanssen/3453904 to your computer and use it in GitHub Desktop.
Download ZIP
Percona Server live query capture settings
Raw
gistfile1.txt
set global slow_query_log = OFF;
set global long_query_time = 0;
set global log_slow_verbosity = full;
set global slow_query_log_timestamp_always = ON;
set global slow_query_log_timestamp_precision=microsecond;
set global slow_query_log_use_global_control="log_slow_filter,log_slow_rate_limit,log_slow_verbosity,long_query_time";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment