by Alexey Kopytov | Mar 11, 2014 | Insight for DBAs, MySQL, Percona Software
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... by Alexey Kopytov | Apr 26, 2013 | 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... by Alexey Kopytov | Apr 12, 2013 | Benchmarks, MySQL
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL bug #49169 and can be described as follows. Whenever a connection... by Alexey Kopytov | Nov 6, 2011 | 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...