… lock wait instead of a dead lock. No, that would cause blocking that would defeat the purpose of the tool. Q… that this is a very dangerous thing to do and causes way too many bugs in the server and the tool…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… will be blocked to the server, which in the end causes “field list” operation to be blocked too, which among other…) As result this means single run away select can effectively cause downtime if you use backup solution which does FLUSH TABLES WITH…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… enables you to ALTER large tables with no blocking or downtime. As you know, MySQL locks tables for most ALTER operations… replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches for load on the master, and so… pt-online-schema-change tool and how it enables zero-downtime schema changes on May 2nd. In addition to pt-online…
Post: What Causes Downtime in MySQL?
March 21, 2011 By 10 Comments
We’ve just published a new white paper analyzing the causes of emergency incidents filed by our customers. The numbers contradict… number of surprises in other areas, too, such as the causes of data loss. This is the companion to my earlier…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… are based on our analysis of several hundred customer downtime incidents, and their causes and preventions. You can read more about that… monitoring plugins to check for some of the conditions that caused downtime for our customers: Failed or full LVM snapshots. LVM backup… common and severe conditions that we’ve observed to cause actual production downtime. Please download and try out the plugins, and help…
Comment: Data Corruption, DRBD and story of bug
November 30, 2010 By 6 Comments
… system can survive failure with short downtime (like switching to standby) and when the longer downtime such as recovery from backup is needed. Some people need to ensure even database/OS/FS bugs causing corruption and replicated by DRBD are not causing downtime – for these guys DRBD alone is…
Comment: When is it a time to upgrade memory ?
September 17, 2008 By 11 Comments
…. 3) Upgrade and testing is time and effort too and causes downtime unless there is redundancy in the system which need to…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… that nearly all the maintenance task can be handled without downtime with rolling restarts, even software upgrades. The exceptions I see… replication. I must admit that those issues were nearly all caused by stored procs and triggers and most likely switching to… corruption issues than InnoDB corruption ones. Looking at the other downtime reasons you are giving, most of them would have covered…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… answer WHY you need to restore single table. What condition causes this ? Typically there are following conditions 1) Server Down. Switch… do roll forward recovery from backup. Note with very high downtime costs you can use high end systems doing snapshots every… per minute you could pay us for few minutes of downtime and get .ibd files movable for XtraDB 
In any case…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… they typically would have order of magnitude more availability issues caused by their own software bugs, DOS attacks and other issues… (in particular if you’re using MyISAM tables) which can cause the error to propagate further in the system and make… some power work (like moving server to different circuit) without downtime which may be or may not be something important for…
