Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 26, 2014
ClusterControl: Percona XtraDB Cluster Monitoring
First of all we would like to thank all of you who attended the Feb. 19 MySQL webinar, “Performance Monitoring [...]
February 24, 2014
The MySQL ARCHIVE storage engine – Alternatives
In my previous post I pointed out that the existing ARCHIVE storage engine in MySQL may not be the one that [...]
February 14, 2014
ClusterControl: Percona XtraDB Cluster Monitoring – Webinar
Next Wednesday, Severalnines CTO Johan Andersson and I will co-present a webinar about ClusterControl, a cluster management tool created by Severalnines [...]
February 13, 2014
Keynote Speakers for Percona Live MySQL Conference 2014 and $5 Expo Only Passes
The Percona Live MySQL Conference 2014 in Santa Clara, California is just around the corner: April 1-4. There is a [...]
February 12, 2014
8 common (but deadly) MySQL operations mistakes and how to avoid them
January 22 I gave a presentation on “How to Avoid Common (but Deadly) MySQL Operations Mistakes” for Percona MySQL Webinars. [...]
February 11, 2014
PERFORMANCE_SCHEMA vs Slow Query Log
A couple of weeks ago, shortly after Vadim wrote about Percona Cloud Tools and using Slow Query Log to capture [...]
February 5, 2014
Analyze MySQL Query Performance with Percona Cloud Tools: Feb. 12 webinar
Next week (Wednesday, February 12 at 10 a.m. Pacific) I will host a webinar titled “Analyze MySQL Query Performance with [...]
February 3, 2014
Quick installation guide for Percona Cloud Tools for MySQL
Here in Percona Support, we’re receiving several requests per day for help with Percona Cloud Tools installation steps. So I [...]
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, [...]