maria-discuss team mailing list archive
Mailing list archive
Re: How spy database alterations
You can enable/disable the general query log on the fly :
Another solution is to use MaxScale as a proxy between the app and the
database to log only specific queries :
And if you dont like MaxScale you can do something similar with MySQLProxy.
Le 20/07/2017 à 15:12, lemmel a écrit :
Working with a web application (PHP, Nginx, MariaDB) that doesn't really work
as expected, I'm looking for a way to monitor/spy database alterations done
when some action is performed on the FrontEnd. It would be faster by far than
to read the application's source code.
So is there a non-invasive way to monitor/spy database alterations performed
after a given time, or triggered manually ?
P.S. : I know that I could add triggers on all database operation, but that
would require adding a awful quantity of triggers and would not be easy to