Skip to content

Instantly share code, notes, and snippets.

@dgoguerra

dgoguerra/mysql-query-log.md

Created November 22, 2018 08:43
Show Gist options
  • Save dgoguerra/a90e093710f1cc279d168e8e0d38b94b to your computer and use it in GitHub Desktop.
Save dgoguerra/a90e093710f1cc279d168e8e0d38b94b to your computer and use it in GitHub Desktop.
Download ZIP
MySQL general query log
Raw
mysql-query-log.md

## When you have SUPER privileges

# enable query log
SET GLOBAL general_log = 'ON';
SET GLOBAL log_output = 'TABLE';

# disable query log
SET GLOBAL general_log = 'OFF';

In Google Cloud SQL, via gcloud

# enable query log
gcloud sql instances patch ccc-dev-shared-db --project=PROJECT --database-flags general_log=ON,log_output=TABLE

# disable query log
gcloud sql instances patch ccc-dev-shared-db --project=PROJECT --clear-database-flags
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment