Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 8, 2015
Managing data using open source technologies? Learn what’s hot in 2015!
Whether you’re looking at the overall MySQL ecosystem or the all-data management landscape, the choice of technologies has never been [...]
January 6, 2015
Getting mutex information from MySQL’s performance_schema
We have been using SHOW ENGINE INNODB MUTEX command for years. It shows us mutex and rw-lock information that could [...]
January 5, 2015
Using YUM to install specific MySQL/Percona Server versions
Sometimes it is desired to use particular software versions in production, and not necessary the latest ones. There may be [...]
December 29, 2014
How well does your table fit in the InnoDB buffer pool in MySQL 5.6+?
Some time ago, Peter Zaitsev posted a blog titled “How well does your table fits in innodb buffer pool?” He [...]
December 24, 2014
InnoDB crash recovery speed in MySQL 5.6
It has been a while since I have looked at InnoDB crash recovery. A lot has change in the last [...]
December 23, 2014
File carving methods for the MySQL DBA
This is a long overdue blog post from London’s 44con Cyber Security conference back in September. A lot of old memories [...]
December 18, 2014
Making HAProxy 1.5 replication lag aware in MySQL
HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how [...]
December 17, 2014
InnoDB’s multi-versioning handling can be Achilles’ heel
I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets [...]
December 16, 2014
OpenStack Live tutorials & sessions to bring OpenStack users up to speed
I attended the OpenStack Paris summit last month (Percona had a booth there). It was my first opportunity to meet [...]
December 10, 2014
Reset MySQL root password without restarting MySQL (no downtime!)
Disclaimer: Reset the MySQL root password at your own risk! It doesn’t apply if you’re using Pluggable authentication and certainly won’t [...]
December 9, 2014
MySQL 5.6 Transportable Tablespaces best practices
In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for [...]
December 8, 2014
Application Cannot Open Another Connection to MySQL
Have you ever experienced a situation where one moment you can connect to the MySQL database and the next moment [...]
December 4, 2014
MySQL and OpenStack deep dive: Dec. 10 webinar
Fact: MySQL is the most commonly used database in OpenStack deployments. Of course that includes a number of MySQL variants [...]
December 2, 2014
Tips from the trenches for over-extended MySQL DBAs
This post is a follow-up to my November 19 webinar, “Tips from the Trenches: A Guide to Preventing Downtime for [...]
December 1, 2014
Faster restarts for MySQL and Percona Server 5.6.21+
By default in MySQL 5.6, each time MySQL is started (regular start or crash recovery), it iterates through all the [...]
November 24, 2014
Schema changes in MySQL for OpenStack Trove users
People using OpenStack Trove instances can hit a common issue in the MySQL world: how to perform schema change operations [...]
November 20, 2014
Sys Schema for MySQL 5.6 and MySQL 5.7
Performance Schema (P_S) has been available since MySQL 5.5, more than 4 years ago. It is still difficult to see [...]
November 19, 2014
How a set of queries can be killed in MySQL using Percona Toolkit’s pt-kill
You might have encountered situations where you had to kill some specific select queries that were running for long periods [...]
November 18, 2014
Avoiding MySQL ALTER table downtime
MySQL table alterations can interrupt production traffic causing bad customer experience or in worst cases, loss of revenue. Not all [...]
November 17, 2014
Typical misconceptions on Galera Replication for MySQL
Even if a Galera node looks like a regular MySQL server, the underlying replication mechanism is very different. This implies [...]