Skip to content

Instantly share code, notes, and snippets.

@siteslave
Created February 7, 2022 17:24
Show Gist options
  • Save siteslave/67145b6ab9c2882dab153e6850f8c4e8 to your computer and use it in GitHub Desktop.
Save siteslave/67145b6ab9c2882dab153e6850f8c4e8 to your computer and use it in GitHub Desktop.
Tracking mysql logg

Enable MySql logging.

Check for updates in the logs. Enable logging in MySQL:

Type the following in mysql backend console.

SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';

Check for updates with queries: (you can customize this to your need)

select argument from mysql.general_log where argument REGEXP '*INSERT*';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment