How can I split mySQL query logs by database?
- by barnaby
I've been trying to implement a mySQL Proxy solution that can separate out the queries into per-database logs. Everything I've Googled has pointed to mySQL Proxy but I can only seem to capture the database a connection was opened to, not which the current query is being issued against.
Is it even possible? Is there a different tool to use?
Thanks for any suggestions.