Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 10, 2015
Online GTID rollout now available in Percona Server 5.6
Global Transaction IDs (GTIDs) are one of my favorite features of MySQL 5.6. The main limitation is that you must [...]
February 4, 2015
The future of MySQL quality assurance: Introducing pquery
Being a QA Engineer, how would you feel if you had access to a framework which can generate 80+ crashes [...]
January 30, 2015
OpenStack Live 2015: FAQs on the who, what, where, when, why & how
This April 13-14 Percona is introducing an annual conference called OpenStack Live. I’ve seen a few questions about the new [...]
January 29, 2015
Multi-threaded replication with MySQL 5.6: Use GTIDs!
MySQL 5.6 allows you to execute replicated events in parallel as long as data is split across several databases. This [...]
January 27, 2015
Percona University: Back to school Feb. 12 in Raleigh, N.C.
About two years ago we held our first-ever Percona University event in Raleigh, N.C. It was a great success with [...]
January 21, 2015
Importing big tables with large indexes with Myloader MySQL tool
Mydumper is known as the faster (much faster) mysqldump alternative. So, if you take a logical backup you will choose [...]
January 20, 2015
Identifying Useful Info from MySQL Row-Based Binary Logs
As a MySQL DBA/consultant, it is part of my job to decode the MySQL binary logs – and there are [...]
January 15, 2015
Hyper-threading -How does it double CPU throughput?
The other day a customer asked me to do capacity planning for their web server farm. I was looking at [...]
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 [...]