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

Question

Navigation

#1 by (3 votes)

4

I want to capture queries that are sent to MySQL from a particular application, is it possible?

mysql query

asked by anonymous 22.10.2014 / 19:03

1 answer

score 3 · Answer 1

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

In the "poor" version, you can enable the General Log , but can not be enabled or disabled per database.

With logging active, you have the option to dynamically hang up and reconnect with the commands:

SET GLOBAL general_log = 'OFF';

E ...

SET GLOBAL general_log = 'ON';