I would like to know a solution to splitting very large MySQL general query logs by specific clients that have accessed the server.
Ideally a separate log will be created for each client.
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
I would think that you could relatively easily achieve this using MySQL-Proxy.
You'd have to put together a LUA script that would be able to differentiate your clients (username, DB Name, connecting host), and then log each one to a separate file.