How to watch database additions

[carpenox]

Is there a perl script I can run with --debugX to watch database additions to find out whats going on during astgui functions to try to debug errors?

[williamconley]

Code: Select all

NEWPASS=RootMySQLPass
watch -n1  "mysql asterisk -p$NEWPASS -e \"select * from information_schema.processlist where command not in ('Sleep') and info not like '%processlist%' and info is not null and STATE not like '%Waiting%'\""


Sorry. Not perl.

[carpenox]

Bill,

Cool, that'll work. Thanks

Nox

[williamconley]

If you want to get really technical, mysql also has a logging feature to log ALL queries. This can be a little bloated, but useful if used sparingly and only when needed to actually be ON.

But if you truly ONLY want "changes in the DB", that's what the binary log is!