…MySQL has traditionally been challenging. Most data can be obtained from the slow or general log…to the log (all the lists in these variables are comma separated). As pointed here, anything that would generate a write to the general log…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…failing over is the simple matter of moving the virtual IP. In practice, it’s slightly more complicated. To…slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to… database write. The slow logs were…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…writing). New Features: This version of Percona XtraBackup has implemented full support for new MySQL… are thousands of tables and slow IO then XtraBackup can…fail when copying logs. Fixed by terminating xtrabackup process immediately on log… which could cause backup to fail. Bug fixed #1169726. For…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… to lag. Failed…to periodically go through battery learning cycle which switches RAID cache in write…to analyze your replication traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it is easy to…to see it by comparing IO MySQL is doing to IO going to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… developed a few years ago to allow more precise logging of query execution times into the slow log. Originally MySQL database offered a second time… logged while doing it only for every n-th of them thus limiting the number of writes to the log. Note: this feature will fail to…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…to traditional MySQL replication. For those who don’t know, it gives you: Fully Synchronous replication with a write latency increase equivalent to… would really slow down transactions. …s), undo log entries 1 MySQL thread id…fails, clients fail over gracefully. Update your application DB library to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…to wait for metadata locks, at that point the ALTER simply blocks any type of queries to the table, we know that writes… cached result to clien | 0.000011 | | logging slow query …MySQL 5.1 the second CREATE would just fail…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… innodb_log_file_size=1900M innodb_flush_log_…to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important to…writing, the code is already different in the trunk. Huh? The dedicated purge threads in 5.6.2 completely fail to… enough: they only slow the growth of the …
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
…slow by safe upgrade procedures – dump your data and reload. Little tip to mention – upgrading to…. Anyway I was going to write not about MySQL Server upgrade process but …logged some of my experiences as a bug but here are some more details about the problems Upgrade Script fails to shut down MySQL…
