Mysql logging for specific table activity

mycoolwater · 09-21-2009, 08:26 PM

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...

chrism01 · 09-21-2009, 09:17 PM

I think you can either read the binary log
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
http://www.mydigitallife.info/2007/1...h-mysqlbinlog/
http://search.cpan.org/~dnichter/MyS...ParseFilter.pm

Or

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.