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

Question

I am wanting to capture the queries that are sent to Mysql of a particular application, it is possible?

Answer 1

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

In the "poor" version, you can activate the General Log, but cannot enable or disable by database.

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

SET GLOBAL general_log = 'OFF';

And...

SET GLOBAL general_log = 'ON';