Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
October 23, 2012
Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!
Continuous integration of new features and bug fixes is great – but what if a small change in seemingly insignificant [...]
October 19, 2012
Recovering from a bad UPDATE statement
Did you just run an UPDATE against your 10 million row users table without a WHERE clause? Did you know [...]
October 15, 2012
Using pt-table-checksum with Percona XtraDB Cluster
As of Percona Toolkit v2.1.5, pt-table-checksum works correctly with Percona XtraDB Cluster, but it doesn’t work quite like a traditional [...]
October 8, 2012
Review of MySQL 5.6 Defaults Changes
James Day just posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there [...]
October 8, 2012
Measuring the amount of writes in InnoDB redo logs
Choosing a good InnoDB log file size is key to InnoDB write performance. This can be done by measuring the [...]
October 4, 2012
Tools and Techniques for Index Design Webinar Questions Followup
I presented a webinar this week to give an overview of Tools and Techniques for Index Design. Even if you [...]
October 1, 2012
Upcoming Webinar on Index Design
The proper tools and techniques for designing indexes in MySQL is a broad subject, which causes grief for many developers [...]
September 25, 2012
Timezone and pt-table-checksum
I recently worked through an issue with a client trying to detect data drift across some servers that were located [...]
September 19, 2012
Automation: A case for synchronous replication
Just yesterday I wrote about math of automatic failover today I’ll share my thoughts about what makes MySQL failover different [...]
September 18, 2012
The Math of Automated Failover
There are number of people recently blogging about MySQL automated failover, based on production incident which GitHub disclosed. Here is [...]
September 11, 2012
How to find MySQL queries worth optimizing ?
One question I often get is how one can find out queries which should be optimized. By looking at pt-query-digest [...]
September 10, 2012
Introducing the “Version Check” Feature in Percona Toolkit
Recently there has been a storm of bugs and problems in all variants of MySQL including MySQL, Percona Server, and [...]
September 9, 2012
How to obtain the “LES” (Last Executed Statement) from an Optimized Core Dump?
Ever ran into a situation where you saw “some important variable you really needed to know about=<optimized out>” while debugging?
September 5, 2012
Write contentions on the query cache
While doing a performance audit for a customer a few weeks ago, I tried to improve the response time of [...]
September 4, 2012
When is MIN(DATE) != MIN(DATE) ?
Inspiration for this post is courtesy of a friend and former colleague of mine, Greg Youngblood, who pinged me last [...]
August 31, 2012
Visualization tools for pt-query-digest tables
When you process MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and [...]
August 30, 2012
Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
I got the message in the morning today about the bug being fixed in MySQL 5.6.6…. which I reported in [...]
August 29, 2012
Is Replication Slave ever going to catch up? When?!
If you ever had a replication slave that is severely behind, you probably noticed that it’s not catching up with [...]
August 28, 2012
REPEATABLE-READ and READ-COMMITTED Transaction Isolation Levels
As an instructor with Percona, I’m sometimes asked about the differences between the REPEATABLE-READ and READ-COMMITTED transaction isolation levels. There [...]
August 28, 2012
Sell-an-Elephant-to-your-Boss-HOWTO
Spoiler alert: If your boss does not need an elephant, he is definitely NOT going to buy one from you. [...]