Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 7, 2015
More on (transactional) MySQL metadata locks
Two years ago Ovais Tariq had explained in detail what kinds of problems existed before MySQL introduced metadata locks in [...]
March 18, 2015
Getting started guide for OpenStack contributors
So you want to contribute to OpenStack? I can help! For the last year or so I have been involved [...]
March 17, 2015
MySQL QA Episode 1: Bash/GNU Tools & Linux Upskill & Scripting Fun
MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting Fun This episode consists of 13 parts, and an [...]
March 17, 2015
Free MySQL QA & Bash/Linux Training Series
Welcome to the MySQL QA Training Series! If you have not read our introductory blog post on pquery yet, I’d [...]
March 13, 2015
Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7
My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available an [...]
March 3, 2015
Introducing ‘MySQL 101,’ a 2-day intensive educational track at Percona Live this April 15-16
Talking with Percona Live attendees last year I heard a couple of common themes. First, people told me that there [...]
March 2, 2015
Emulating MySQL roles with the Percona PAM plugin and proxy users
From time to time people wonder how to implement roles in MySQL. This can be useful for companies having to [...]
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 [...]