… for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication-delay… error on directory permissions issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_pages_writtenblogpercona.commanual innodb_purge_batch_sizeblogpercona.commanual innodb_purge_threadsblogpercona.commanual innodb_read_ahead_thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_replication_delayblogpercona.commanual innodb…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… the propagation delay was pretty good until this given query had to be replicated, in which case we could observe the replication delay for over 45 seconds which is quite nasty. Note though delay was…_name=DPE binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 wsrep_sst_auth…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… innodb_read_ahead_threshold 56 innodb_read_io_threads 4 innodb_replication_delay 0 innodb_rollback_on_timeout OFF innodb_spin_wait_delay 6 innodb_stats_on_metadata ON innodb_stats_sample_pages 8 innodb…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb-stats-auto-update=0 innodb-stats-on-metadata=0 innodb…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that …. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… run in production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb Transactional log which would be… with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication is…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… and write on every node without needing to worry about replication delay However, good engineers know there is always a trade-off… matched: 1 Changed: 1 Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… was taking quite a while to catch up, which highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on… restart MySQL but this would make replication to be delayed few more hours because of the time Innodb takes to open tables first…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… shard your data properly so you would not have to replicate everything 
There are also cases when storage size becomes the… for example these 50 drives will unlikely be helpful solving replication delay or speeding up this 3 hours reporting query or 5… can keep the same RAID volume. I tend to keep Innodb data files (and whole datadir) and log files on the…
