2013/3/28 Rafał Radecki <radecki.ra...@gmail.com> > Hi All. > > I have a production setup of four databases connected with > replication. I would like to log every command that clients execute > for auditing. >
Take a look at general query log it's exactly what you need. http://dev.mysql.com/doc/refman/5.5/en/query-log.html > > I've read > http://www.percona.com/doc/percona-server/5.5/diagnostics/mysql_syslog.html?id=percona-server:features:mysql_syslog&redirect=1#client-variables > but despite the fact that I use percona > Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64 it does not > seem to work. I've added "syslog"/"syslog ON" to my my.cnf server > configuration file but no info about executed commands in logs. > > I've also read > http://www.mysqlperformanceblog.com/2008/07/08/logging-your-mysql-command-line-client-sessions/ > . > > What is the best way to log all client commands? > > Best regards, > Rafal. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
