Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
![[ERROR] mysqld: Sort aborted: Server shutdown in progress](https://www.percona.com/blog/wp-content/uploads/2023/03/lucas.speyer_an_icon_of_an_electronic_cloud_f55d1720-c726-4761-89f2-978718ffcfd9.png){kind=icon}
December 30, 2013
[ERROR] mysqld: Sort aborted: Server shutdown in progress
Recently, one of our support customers faced this: “[ERROR] mysqld: Sort aborted: Server shutdown in progress.” At first it would [...]
December 26, 2013
2 cases for MySQL server overload
Your MySQL server is overloaded. You see hundreds of running queries in the SHOW PROCESSLIST taking many seconds to run, [...]
December 24, 2013
Renaming database schema in MySQL
One of the routine tasks for a DBA is MySQL renaming database schemas, and as such MySQL added a command [...]
December 13, 2013
Seconds_Behind_Master fluctuating wildly? Check for events caught in a loop
Recently I was working with a customer where we noticed that Seconds_Behind_Master fluctuating from an expected value of 0 seconds [...]
December 12, 2013
One more InnoDB gap lock to avoid
While troubleshooting deadlocks for a customer, I came around an interesting situation involving InnoDB gap locks. For a non-INSERT write [...]
December 10, 2013
Q&A: Geographical disaster recovery with Percona Replication Manager
My December 4 webinar, “Geographical disaster recovery with Percona Replication Manager (PRM),” gave rise to a few questions. The recording of [...]
December 4, 2013
Multi-Data Center MySQL with Continuent Tungsten: Dec. 11 webinar
I’m looking forward to next week’s MySQL webinar with Robert Hodges, CEO of Continuent. We’ll be speaking on the topic [...]
December 3, 2013
INFORMATION_SCHEMA: innodb_stats_on_metadata and slow queries
INFORMATION_SCHEMA is usually the place to go when you want to get facts about a system (how many tables do [...]
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 [...]