LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   Mysql logging for specific table activity (http://www.linuxquestions.org/questions/linux-software-2/mysql-logging-for-specific-table-activity-756885/)

mycoolwater 09-21-2009 08:26 PM

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

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.


All times are GMT -5. The time now is 10:29 PM.