Skip to content

Instantly share code, notes, and snippets.

@simonrenoult

simonrenoult/slow_query_log_configuration.sql

Created July 1, 2019 08:54
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 simonrenoult/edbf7547ad74cb974494ec7786ca4361 to your computer and use it in GitHub Desktop.
Save simonrenoult/edbf7547ad74cb974494ec7786ca4361 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
slow_query_log_configuration.sql
$> mysql --host=127.0.0.1 --protocol=TCP --user=root --password=password
mysql> SET GLOBAL log_output=FILE;
mysql> SET GLOBAL log_queries_not_using_indexes=ON;
mysql> SET GLOBAL long_query_time=0.1;
mysql> SET GLOBAL slow_query_log=ON;
mysql> SET GLOBAL slow_query_log_file='/var/log/mysql/slow-query.log';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment