We are using MYSQL as our production database and we have setup another salve for read requests. Time to time various database users can execute insert/update queries on master database. If we want identify those executed queries (auditing/troubleshooting) we are using mysql bingos for it (reading after decoding it). From mysql binlog we can identify the query but we cant identify the executed user. is their a way to get that query executed user info into binlog. Enable general log wont be a option due to performance issues.

  • 2
    Adding information to the binlog requires modifying the code.
    – Rick James
    Sep 29, 2016 at 22:13

1 Answer 1


Not sure about general log, but this behavior belongs to auditing system. If you don't insist to write into binlog, both Oracle and Percona offer solutions:

  • 1
    I agree, I use the Percona audit_log plugin with my MySQL databases, and it works really well. Gives you everything you want, and then some.
    – IGGt
    Sep 30, 2016 at 7:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.