Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
August 15, 2013
Percona University at Washington, D.C. – Sept. 12
Following our events earlier this year in Raleigh, Montevideo, Buenos Aires, Toronto and Portland, we bring Percona University to Washington, [...]
July 31, 2013
InnoDB Full-text Search in MySQL 5.6: Part 3, Performance
This is part 3 of a 3 part series covering the new InnoDB full-text search features in MySQL 5.6. To [...]
July 30, 2013
Let’s talk about Percona Server 5.6: Enterprise Grade MySQL (webinar)
The new Percona Server 5.6 is the most manageable, highest performance, and most scalable version of MySQL available. Percona Server [...]
July 26, 2013
Checking B+tree leaf nodes list consistency in InnoDB
If we have InnoDB pages there are two ways to learn how many records they contain: PAGE_N_RECS field in the [...]
July 19, 2013
What kind of queries are bad for MySQL?
In writing a recommendation for our Web development team on how to use MySQL, I came up with the following [...]
July 16, 2013
Recovering temporal types in MySQL 5.6: TIME, TIMESTAMP and DATETIME
MySQL 5.6 introduces a new feature – microseconds resolution in some temporal types. As of 5.6.4 TIME, TIMESTAMP and DATETIME [...]
July 11, 2013
MySQL and Hadoop Integration
Dolphin and Elephant: an Introduction This post is intended for MySQL DBAs or Sysadmins who need to start using Apache [...]
July 9, 2013
LVM read performance during snapshots
For the same customer I am exploring ZFS for backups, the twin server is using regular LVM and XFS. On [...]
July 5, 2013
Schema changes – what’s new in MySQL 5.6?
Among many of the improvements you can enjoy in MySQL 5.6, there is one that addresses a huge operational problem [...]
June 26, 2013
Limited disk space? Compact backups with Percona Xtrabackup 2.1
One very interesting feature, “Compact Backup,” is introduced in Percona XtraBackup 2.1. You can run “compact backups” with the –compact option, [...]
June 24, 2013
pt-online-schema-change and binlog_format
Statement-based or row-based, or mixed? We’ve all seen this discussed at length so I’m not trying to rehash tired arguments. [...]
June 22, 2013
Setting up MySQL SSL and Secure Connections
There are different articles on how to setup MySQL with SSL but it’s sometimes difficult to end up with a [...]