Mysql logging for specific table activity
How do you guys to do just that? I know the option for global logging, with parameters --log on service run or log-bin and err-log for inside my.cnf. But what i am looking for is a way to log specifically a table activity, any activity, be it select or update queries.
3rd party solution is welcome too...
I think you can either read the binary log
Add triggers to the table in qn, and write to an audit table
http://dev.mysql.com/doc/refman/5.0/en/triggers.html and then 'read' the audit table.
|All times are GMT -5. The time now is 10:29 PM.|