One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…your transactions affecting the concurrency and the performance you can disable them in two different ways…repeatable reads) so in order to prevent problems with the replication you should change the binary log …1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is…replication performance dramatically and even if nothing has changed to the replication traffic, changes to concurrent traffic on the slave can affect replication…
Page: Consulting for MySQL
July 31, 2006 By
… using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL Replication performance problems. MySQL…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
Jeremy Cole recently posted very nice post about MySQL Replication Performance. There are however few points I should comment on. Jeremy … mention this covers only Master overhead of Replication. Slave is where you can expect more problems, especially on high end systems. Slave…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…Replication flow: [1] When you setup MySQL replication…replicated again. Step 3: the binary event with the wrong server-id are performed on the two slaves (mysql 3 and mysql…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…. So your “read” performance will drop 4 times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means… that becomes the problem. So am I against simple replication ? Not really this is great solution which offers great MySQL Performance in many cases…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… of common problems, too. Missing PID file. A variety of problems can delete MySQL‘s …check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is…there are several others that can be performed with existing plugins, so there was…
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
…’s see how regular MySQL replication performs there. So we see that running regular replication we have better result: 11180 for MySQL replication vs 10384 for… rotation And, second, much more serious problem: After 1800 sec of run, slave in regular MySQL replication was behind of master by 1000…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…result and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL …so you can run MySQL 5.0 database with MySQL 5.1 with no problems in most cases. …to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave …
