… in the beginning to prevent dead locks? So you would get a lock wait instead of a dead lock. No, that would cause blocking that would defeat the purpose of the tool. Q: When… MySQL bug. Are you sure this is really happening? I would be extremely surprised for such a bug to be happening. In…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… of pt-online-schema-change, a tool that enables you to ALTER large tables with no blocking or downtime. As you know, MySQL… its operation to avoid causing replication delay, watches for load on the master, and so forth. In this respect it is quite…-schema-change tool and how it enables zero-downtime schema changes on May 2nd. In addition to pt-online-schema-change, we…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… look at what the problem is. As of MySQL 5.5 FLUSH TABLES WITH READ … 5 rows in set (0.00 sec) As result this means single run away select can effectively cause downtime…
Post: What Causes Downtime in MySQL?
March 21, 2011 By 10 Comments
… the most common problem in databases. There are a number of surprises in other areas, too, such as the causes of data loss. This is the companion to my earlier white paper suggesting ways to prevent emergencies in MySQL. It is a re-published and re-edited version of an article that just appeared in IOUG’s SELECT…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… on our analysis of several hundred customer downtime incidents, and their causes and preventions. You can read more about that research in our white… list of suggestions for what to monitor in MySQL. Those are only suggestions; any given deployment might want to monitor only some of them…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… Enterprise Linux, SuSE Linux and Ubuntu. Of course CentOS and Ubuntu …in such shape, you prepared for downtime, stopped MySQL and… error – text editor has not been properly installed, so you cannot upgrade MySQL…’ would cause MySQL to shut down. The MySQL package scripts for Debian force MySQL stop…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… lot of publicity over years is change of TIMESTAMP output format in MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause different result set or make query not runnable in MySQL… the Slave(s) If you want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup…
Post: Announcing MySQL Monitoring Plugins from Percona
February 17, 2012 By 20 Comments
… are informed by the research we did into the causes and preventions of MySQL downtime. Like all Percona software, the plugins are open-source… to download now, and the reference manual is also online. In the next release we will integrate this into our package… them to the list of software included in our support contracts. If you’re an existing customer of Percona’s MySQL Support services, your…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…in redundant power supply will often allow to do some power work (like moving server to different circuit) without downtime…MySQL). It is best if you just put couple of spare servers in…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… of data processing in MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL… get there, it can change the lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there are… essentially negate the benefits of partitioning for those operations. An finally, it doesn’t save you from the downtime caused by ALTER TABLE…
