← Back to context

Comment by GeorgeDewar

3 years ago

If you are in the hole where you really cannot add load to your database server but want to log the queries, there is a technique called zero impact monitoring where you literally mirror the network traffic going to your database server, and use a separate server to reconstruct it into query logs. These logs identify the queries that are being run, and critically, who/what is running them.

A past workplace of mine has used this approach.

Excellent pointer! Do you happen to know of anything which can do this out of the box?