Skip to content

Instantly share code, notes, and snippets.

@afonsoaugusto

afonsoaugusto/enable_query_log_mysql.sql

Created January 10, 2018 16:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save afonsoaugusto/4d7f8bd0b0cc47dad6a30d4d08d9645f to your computer and use it in GitHub Desktop.
Save afonsoaugusto/4d7f8bd0b0cc47dad6a30d4d08d9645f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
enable_query_log_mysql.sql
20 CONFIGURAR LOGS DE PROFILING
EXECUTAR SET GLOBAL GENERAL_LOG_FILE = '/PATH/FILENAME1' ;
EXECUTAR SET GLOBAL LONG_QUERY_TIME = 0.2;
EXECUTAR SET GLOBAL SLOW_QUERY_LOG_FILE = '/PATH/FILENAME2';
30 LIGAR COLETA DE SLOW QUERIES
EXECUTAR SET GLOBAL SLOW_QUERY_LOG = 'ON';
40 DESLIGAR COLETA DE SLOW_QUERIES
EXECUTAR SET GLOBAL SLOW_QUERY_LOG = 'OFF';
50 INICIAR CÓPIA DE ARQUIVO SLOW QUERIES
60 LIGAR COLETA GENERAL LOG
EXECUTAR SET GLOBAL GENERAL_LOG = 'ON';
70 DESLIGAR COLETA GENERAL LOG
EXECUTAR SET GLOBAL GENERAL_LOG = 'OFF';
80 INICIAR CÓPIA DE ARQUIVO GENERAL LOG
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment