…. Here is where tools like mysqlsla and Maatkit’s mk-log-parser come into their own as they both allow you… by statement. Looking through the binary logs I could see this table is actually an audit table for changes to the Foo table. The trail is kept using two triggers on that table. select trigger_name…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… start to this. What to look for during the audit During the audit I look for outliers and anomalies in every aspect… a very basic audit, whose scope I’ll keep within just a MySQL server. The first step is to log into the… from InnoDB, for example. (The INFORMATION_SCHEMA query will surely trigger errors about this.) There are a bunch of other things…
Post: Preprocessing Data
August 8, 2011 By 3 Comments
… into the database. Your application or the database itself (using TRIGGERs) does additional calculations or data insertions. This adds some overhead… a form of event processing. Examples could be counter tables, audit logs and cache invalidation. This use case works better in environments…
