Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
November 28, 2013
MySQL Error: Too many connections
Editor’s Note: Follow up to this post here MySQL 5.7 Performance Tuning After Installation. We have always received quite a [...]
November 26, 2013
Geographical disaster recovery with PRM: Register for Dec. 4 Webinar
Downtime caused by a disaster is probable in your application’s lifetime. While caused by a large-scale geographical disaster, cyber attack, [...]
November 21, 2013
Integrating pt-online-schema-change with a Scripted Deployment
Recently, I helped a client that was having issues with deployments causing locking in their production databases. At a high [...]
November 20, 2013
How to add VIPs to Percona XtraDB Cluster or MHA with Pacemaker
It is a rather frequent problem to have to manage Virtual IP addresses (VIPs) with a Percona XtraDB Cluster (PXC) [...]
November 18, 2013
MySQL encryption performance, revisited
This is part two on a two-part series on the performance implications of in-flight data encryption with MySQL. In the [...]
November 13, 2013
MySQL & Sphinx: Register now for Nov. 20 Webinar
Sphinx is a free, open-source search server that integrates nicely with MySQL. It provides a fast, scalable, and pluggable search [...]
November 11, 2013
How Percona tested Percona Server 5.6: A world premiere in advanced testing
8PM. One of the servers found a critical bug. Hop online and discuss, log bug. 10PM. Patch ready. 10:30PM. New [...]
November 11, 2013
QA: Advanced Option Combinatorics (Pairwise Testing): Combinatorial mysqld Option Test Case Generation
How do we ensure that, when we have 35+ testable option combinations for mysqld, we test each and every combination [...]
November 11, 2013
How to Extract All Running Queries (Including the Last Executed Statement) from a Core File?
This post builds on the How to obtain the “LES” (Last Executed Statement) from an Optimized Core Dump? post written [...]
November 5, 2013
How to recover an orphaned .ibd file with MySQL 5.6
A few years ago Yves Trudeau and Aleksandr Kuzminsky wrote posts about different ways for recovering orphaned .ibd files: Connecting [...]
October 29, 2013
MySQL on Windows: A survival guide for Linux-based DBAs
Next week, on Nov. 6, I will be delivering a webinar about running MySQL on Windows, with a strong focus [...]
October 23, 2013
High Availability Options for MySQL – October 2013 Update
The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and [...]
October 22, 2013
The power of MySQL GROUP_CONCAT
In the very early days of Percona, Vadim wrote very nice post about MySQL GROUP_CONCAT (GROUP_CONCAT). But I want to show [...]
October 18, 2013
InnoDB scalability issues due to tables without primary keys
Each day there is probably work done to improve performance of the InnoDB storage engine and remove bottlenecks and scalability [...]
October 16, 2013
utf8 data on latin1 tables: converting to utf8 without downtime or double encoding
Here’s a problem some or most of us have encountered. You have a latin1 table defined like below, and your [...]
October 14, 2013
Innotop: A real-time, advanced investigation tool for MySQL
GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed [...]
October 11, 2013
Handling long-running queries in MySQL with Percona XtraBackup
I recently had a case where replication lag on a slave was caused by a backup script. First reaction was [...]
October 10, 2013
SSL Performance Overhead in MySQL
NOTE: This is part 1 of what will be a two-part series on the performance implications of using in-flight data [...]
October 7, 2013
Tuning MySQL 5.6 configuration – Webinar followup
We had a wonderful time during the Sept. 25 webinar, “MySQL 5.6 Configuration Optimization,” and I got a lot more [...]
October 3, 2013
Inexpensive SSDs for Database Workloads
The cost of SSDs has been dropping rapidly, and at the time of this writing, 2.5-drives have reached the 1TB [...]