Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 3, 2014
Percona Toolkit collection: pt-visual-explain
This is the first in a series of posts highlighting a few of the seldom-used but still handy Percona Toolkit [...]
January 28, 2014
MySQL Performance Tuning Settings
Note: This blog has been updated for MySQL 5.7 here! In this blog, we’re going to discuss the top ten [...]
January 24, 2014
MySQL server memory usage troubleshooting tips
There are many blog posts already written on topics related to “MySQL server memory usage,” but nevertheless there are some [...]
January 21, 2014
Beware of MySQL 5.6 Server UUID when Cloning Slaves
The other day I was working on an issue where one of the slaves was showing unexpected lag. Interestingly with [...]
January 20, 2014
Percona Replication Manager (PRM) now supporting 5.6 GTID
Over the last few days, I integrated the MySQL 5.6 GTID version of the Percona Replication Manager (PRM) work of [...]
January 17, 2014
keepalived with reader and writer VIPs for Percona XtraDB Cluster
This is a followup to Jay Janssen’s October post, “HaProxy would. keepalived is a simple load balancer with HA capabilities, [...]
January 13, 2014
Webinars: Common (but deadly) MySQL mistakes
On January 22 I’ll be presenting the first of a series of two new webinars focusing on avoiding common MySQL [...]
January 10, 2014
The use of Iptables ClusterIP target as a load balancer for PXC, PRM, MHA and NDB
Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even [...]
January 9, 2014
Percona Cloud Tools: Making MySQL performance easy
One of our primary focuses at Percona is performance. Let me make some statements on what is “performance.” In doing [...]
January 6, 2014
The ARCHIVE Storage Engine – does it do what you expect?
Sometimes there is a need for keeping large amounts of old, rarely used data without investing too much on expensive [...]
January 3, 2014
Multiple column index vs multiple indexes with MySQL 5.6
A question often comes when talking about indexing: should we use multiple column indexes or multiple indexes on single columns? Peter [...]
January 2, 2014
How to recover table structure from .frm files with MySQL Utilities
MySQL table structures are stored in .frm files and in the InnoDB Data Dictionary. Sometimes, usually in data recovery issues, [...]
![[ERROR] mysqld: Sort aborted: Server shutdown in progress](https://www.percona.com/blog/wp-content/uploads/2023/03/international-business-communication-concept.jpg)
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 [...]