Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
February 19, 2012
Why don’t our new Nagios plugins use caching?
In response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios [...]
February 15, 2012
Optimize Your SQL With Percona’s Online Query Advisor!
Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the [...]
February 15, 2012
Troubleshooting MySQL Upgrade Performance Regressions
So lets say you upgraded from MySQL 5.1 to Percona Server 5.5 and instead of expected performance improvement you see [...]
February 10, 2012
Why not make a tool to improve existing configurations?
A couple of users of our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love to input [...]
February 6, 2012
Announcing Percona Toolkit Release 2.0.3
We’ve released Percona Toolkit 2.0.3, with a couple of major improvements and many minor ones. You can download it, read [...]
February 2, 2012
STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
DELETE IGNORE suppresses errors and downgrades them as warnings, if you are not aware how IGNORE behaves on tables with FOREIGN KEYs, [...]
February 1, 2012
Verifying backup integrity with CHECK TABLES
An attendee to Espen’s recent webinar asked how to check tables for corruption. This kind of ties into my recent [...]
January 26, 2012
MySQL Configuration Wizard Updated
We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you [...]