Skip to content

Instantly share code, notes, and snippets.

@jdeathe

jdeathe/mysql-query-logging.md

Last active July 20, 2018 08:40
Show Gist options
  • Save jdeathe/f924849f202183d12b819c68ff4f4654 to your computer and use it in GitHub Desktop.
Save jdeathe/f924849f202183d12b819c68ff4f4654 to your computer and use it in GitHub Desktop.
Download ZIP
How to Enable MySQL Query Logging at Runtime
Raw
mysql-query-logging.md

How to Enable MySQL Query Logging at Runtime

From the mysql client run:

mysql> SET GLOBAL general_log=true;
mysql> SET GLOBAL general_log_file='general.log';

After this queries will be logged to the named file located in the MySQL data directory. e.g. /var/lib/mysql/general.log.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment