MySQL SELECT history

Question

How can I keep a record of recent SELECTs performed on a table/DB? I am trying to fix an old codebase that runs very slow queries that are built in multiple nested functions. It would be much easier to just see what querys are being run then trying to follow the code when building them.

Answer 1

You dont have to restart mysql to enable this feature (slow query log).

See here : How can I enable MySQL's slow query log without restarting MySQL?

Answer 2

Use the Slow Query Log.