Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
May 16, 2012
Benchmarking single-row insert performance on Amazon EC2
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that [...]
May 8, 2012
Zero-downtime schema changes webinar recording
The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar [...]
May 6, 2012
Load management Techniques for MySQL
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain [...]
May 3, 2012
Zero-Downtime Schema Changes In MySQL
The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch [...]
April 20, 2012
Joining many tables in MySQL – optimizer_search_depth
Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by [...]
April 5, 2012
Percona Toolkit 2.1 with New Online Schema Change Tool
I’m proud to announce the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of [...]
April 4, 2012
Join Optimizations in MySQL 5.6 and MariaDB 5.5
This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer [...]
April 2, 2012
Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships
I’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz [...]
March 26, 2012
How to diagnose errors in the MySQL error log
I frequently see questions about how to understand the nature of errors in MySQL’s error log. Now, there is a [...]
March 23, 2012
How MySQL FLUSH TABLES WITH READ LOCK works w/ Innodb Tables
Many backup tools including Percona Xtrabackup, MyLVMBackup, and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read-only. [...]
March 23, 2012
Best kept MySQLDump Secret
Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most [...]
March 22, 2012
BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
The Percona Live MySQL Conference & Expo is going to be awesome! Great speakers, an A-list of sponsors, countless opportunities [...]
March 21, 2012
Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
This is the second blog post in the series of blog posts leading up to the talk comparing the optimizer [...]
March 13, 2012
Webinar “How to Turbocharge Your MySQL Performance Using Flash Storage”
Next Wednesday, March-21, 11:00am Pacific Time, Baron and me will be co-presenting with Virident webinar: “How to Turbocharge Your MySQL [...]
March 12, 2012
Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB [...]
February 23, 2012
Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
LVM snapshots is one powerful way of taking a consistent backup of your MySQL databases – but did you know [...]
February 23, 2012
Black-Box MySQL Performance Analysis with TCP Traffic
For about the past year I’ve been formulating a series of tools and practices that can provide deep insight into [...]
February 22, 2012
How to Monitor MySQL with Percona’s Nagios Plugins
In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended [...]
February 21, 2012
DBD::mysql 4.014 breaks pt-table-checksum 2.0
DBD::mysql 4.014 breaks pt-table-checksum 2.0. The cause is unknown, but the effect is a lot of errors like: DBD::mysql::st execute [...]
February 20, 2012
How to recover deleted rows from an InnoDB Tablespace
In my previous post I explained how it could be possible to recover, on some specific cases, a single table [...]