Buy Percona ServicesBuy Now!

MySQL 5.7 key features

 | May 27, 2015 |  Posted In: InnoDB, MySQL, Percona MySQL Support

The other day I was discussing new features of MySQL 5.7 with a Percona Support customer. After that conversation, I thought it would be a good idea to compile list of important features of MySQL 5.7. The latest MySQL 5.7.6 release candidate (RC) is out and is packed with nice features. Here’s a list of […]

Read More

InnoDB locks and deadlocks with or without index for different isolation level

 | April 9, 2015 |  Posted In: InnoDB, MySQL, Percona Live

Recently, I was working on one of the issue related to locks and deadlocks with InnoDB tables and I found very interesting details about how InnoDB locks and deadlocks works with or without index for different Isolation levels. Here, I would like to describe a small test case about how SELECT ..FOR UPDATE (with and without limit) behave […]

Read More

Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?

and  | February 26, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL

If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later you’ll see the following lines on the server’s error log and chances are you’ll be worried about them:

Worry not as this is mostly harmless. It’s becoming a February tradition for me (Fernando) […]

Read More

Is MySQL’s innodb_file_per_table slowing you down?

 | February 24, 2015 |  Posted In: Benchmarks, InnoDB, MySQL, Percona MySQL Consulting, Percona Server for MySQL

MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many of you in the audience are responsible for running automated tests on your […]

Read More