maria-discuss team mailing list archive

[Jean Weisbuch <jean@xxxxxxxxxx>]

You can enable/disable the general query log on the fly : 
https://mariadb.com/kb/en/mariadb/general-query-log/

Another solution is to use MaxScale as a proxy between the app and the 
database to log only specific queries : 
https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-14/maxscale-query-log-all-filter/

And if you dont like MaxScale you can do something similar with MySQLProxy.


Le 20/07/2017 à 15:12, lemmel a écrit :
> Hi.
>
> 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 ?
>
> Thanks !
>
> 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
> realize.