Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
October 1, 2013
Join my Oct. 2 webinar: ‘Implementing MySQL and Hadoop for Big Data’
MySQL DBAs know that integrating MySQL and a big data solution can be challenging. That’s why I invite you to [...]
September 25, 2013
How to reclaim space in InnoDB when innodb_file_per_table is ON
Editor’s Note: This post was written for MySQL 5.1/5.5 and that the default for innodb_file_per_table was turned ON in 5.6 [...]
September 24, 2013
MySQL 5.6 Configuration Optimization Webinar, Sept. 25
This Wednesday in our next webinar I’ll share how to configure a better-performing MySQL 5.6 server. You’ll lean a practical [...]
September 18, 2013
Percona Live London 2013: an insider’s view of the schedule
With the close of call for papers earlier this month, the Percona Live London conference committee was in full swing this [...]
September 17, 2013
Switching between versions using yum
One type of question we get very often (even in the form of filed bugs!) is how to switch from [...]
September 16, 2013
5 reasons why MySQL replication lag is flapping between 0 and XXXXX
Working day to day with Percona Remote DBA customers, we have been facing an issue from time to time when [...]
September 13, 2013
Enabling crash-safe slaves with MySQL 5.6
Being able to configure slaves to be crash-safe is one of the major improvements of MySQL 5.6 with regards to [...]
September 11, 2013
How to move the InnoDB log sequence number (LSN) forward
This post focuses on the problem of the InnoDB log sequence number being in the future. Preface: What is an InnoDB [...]
September 10, 2013
How InnoDB promotes UNIQUE constraints
The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB [...]
August 26, 2013
MySQL Security Webinar: Follow-up Q&A
Thanks to everyone who attended last week’s webinar on MySQL security; hopefully you’ve all gone out and set SELinux to [...]
August 20, 2013
Why is the ibdata1 file continuously growing in MySQL?
We often receive this question about the ibdata1 file in MySQL at Percona Support. The panic starts when the monitoring [...]
August 16, 2013
MySQL Security: Armoring Your Dolphin
My colleague and teammate Ernie Souhrada will be presenting a webinar on Wednesday, August 21, 2013 at 10 a.m. PDT [...]