Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
June 10, 2013
Migrating between MySQL schemas with Percona Xtrabackup
Recently, I was working with a client that asked about using Percona Xtrabackup to take a snapshot of a particular [...]
June 7, 2013
Choosing a MySQL HA Solution – Post-Webinar Q&A
Thanks to everyone who was in attendance on 05 June 2013 for my “Choosing a MySQL HA Solution” webinar. If [...]
June 4, 2013
Implementing SchemaSpy in your MySQL environment
Lately I have been working with a set of customers on a longer term basis which has given me time [...]
May 31, 2013
The small improvements of MySQL 5.6: Duplicate Index Detection
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB [...]
May 30, 2013
Replication in MySQL 5.6: GTIDs benefits and limitations – Part 2
The main benefit of using GTIDs is to have much easier failover than with file-based replication. We will see how [...]
May 28, 2013
Choosing a MySQL HA Solution – MySQL Webinar: June 5
Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it [...]
May 24, 2013
ZFS on Linux and MySQL
I am currently working with a large customer and I am involved with servers located in two data centers, one [...]
May 23, 2013
Experiences with the McAfee MySQL Audit Plugin
I recently had to do some customer work involving the McAfee MySQL Audit Plugin and would like to share my experience [...]