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

Question:

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

Answer:

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';

E…

SET GLOBAL general_log = 'ON';
Scroll to Top