Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 27, 2015
3 handy tools to remove problematic MySQL processes
DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL [...]
February 26, 2015
Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?
If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or [...]
February 25, 2015
Using MySQL Event Scheduler and how to prevent contention
MySQL introduced the Event Scheduler in version 5.1.6. The Event Scheduler is a MySQL-level “cron job”, which will run events [...]
February 20, 2015
How to setup a PXC cluster with GTIDs (and have async slaves replicating from it!)
This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) [...]
February 18, 2015
Percona submits 7 talks for Vancouver OpenStack Summit (voting ends Feb. 23)
Percona has submitted seven talks for the next Voting ends February 23, and if you aren’t already an OpenStack Foundation [...]
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 [...]