EmergencyEMERGENCY? Get 24/7 Help Now!

Introducing backup locks in Percona Server

 | March 11, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona Software, Percona XtraBackup

TL;DR version: The backup locks feature introduced in Percona Server 5.6.16-64.0 is a lightweight alternative to FLUSH TABLES WITH READ LOCK and can be used to take both physical and logical backups with less downtime on busy servers. To employ the feature with mysqldump, use mysqldump –lock-for-backup –single-transaction. The next release of Percona XtraBackup will […]

Read More

More on MySQL transaction descriptors optimization

 | April 26, 2013 |  Posted In: Benchmarks, MySQL

Since my first post on MySQL transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both posts look rather different. We were curious as well, so we tried to answer that question by retrying benchmarks on […]

Read More

Improved InnoDB fast index creation

 | November 6, 2011 |  Posted In: Benchmarks, Insight for DBAs, MySQL

One of the serious limitations in the fast index creation feature introduced in the InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE or CREATE INDEX. Peter has already blogged about it before, here I’ll just briefly reiterate other cases that might benefit from that feature: when ALTER TABLE […]

Read More