How to capture a query in MySQL from a given table in real time?


I'm wanting to capture the queries that are sent to MySQL from a given application, is it possible?


If you have the paid version, there is Enterprise Monitor .

In the "poor" version, you can enable General Log , but it is not possible to enable or disable per database.

With logging active, you have the option to dynamically turn it off and on again with the commands:

SET GLOBAL general_log = 'OFF';


SET GLOBAL general_log = 'ON';
Scroll to Top