…. Here is where tools like mysqlsla and Maatkit’s mk-log-parser come into their own as they both allow you to quickly parse the binary log files, extracting the relevant statements. mysqlbinlog bin_log.000001 | mysqlsla -lt binary – Check out… by statement. Looking through the binary logs I could see this table is actually an audit table for changes to the Foo…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
Post: Preprocessing Data
August 8, 2011 By 3 Comments
… a form of event processing. Examples could be counter tables, audit logs and cache invalidation. This use case works better in environments…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… well. The audit itself OK, so here’s a very basic audit, whose scope I’ll keep within just a MySQL server. The first step is to log into the machine…/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
… immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query to find not… had three options: logging turned off; logging queries which take more than a second to execute; logging every query; MySQL was run with default…-bound workload even if all queries are logged. In general logging all queries can hurt MySQL and you should consider the load while…
Post: Does Slow query log logs all slow queries ?
June 25, 2007 By 2 Comments
… think one may use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries are not logged to slow query log…
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
….1 downloads and from the Percona Software Repositories). Based on MySQL 5.1.60, including all the bug fixes in it…-master replication and –log-slave-updates enabled. This is also filed in MySQL bug tracker, but not fixed in upstream MySQL at the… 4.6 has expanded diagnostics and compiler warnings. We have audited and fixed these warnings for Percona Server 5.1, finding…
Comment: The #1 mistake hosting providers make for MySQL servers
July 25, 2008 By 30 Comments
… arbitrary feature segmentation to productise their possible offerings. Just like MySQL does. Rob Young was just writing about the enterprise-only… the “demand” on are actually about the server delivering inadequate auditing/logging facilities. It would stand to reason to just fix that…
Comment: MySQL Replication and Slow Queries
June 25, 2007 By 3 Comments
[...] queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries are not logged to slow query log and it looks like I was wrong connecting it just with [...]
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…, by doing away with the usual buffer pools, logs, latching, and so on. The benchmark is VoltDB’s…to provide services for VoltDB. We’re focused on MySQL software and services. I am not a VoltDB expert…even higher performance on faster machines. I did not audit or repeat Tim’s benchmarks in the level …
Comment: Tuning for heavy writing workloads
October 16, 2009 By 9 Comments
… found a lot of clients (they are using Pythian’s auditing services, for one-time short-term health checks) that have…: Change the table to MyISAM. Many people are using MySQL to keep logs, or other information that’s mostly INSERT. I think…
