Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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. [...]
August 28, 2012
Hidden columns of query_review_history table
You can use pt-query-digest to process a MySQL slow query log and store historical values for review trend analysis into [...]
August 16, 2012
MySQL Indexing Best Practices: Webinar Questions Followup
I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) [...]
August 10, 2012
Recovery deleted ibdata1
Recently I had a case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs [...]
July 31, 2012
Innodb Table Locks
Innodb uses row level locks right ? So if you see locked tables reported in SHOW ENGINE INNODB STATUS you [...]
July 1, 2012
Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS
When executing an ALTER TABLE, InnoDB (and XtraDB) will create two InnoDB transactions: One transaction is created when the table [...]
June 30, 2012
Find unused indexes
I wrote one week ago about how to find duplicate indexes. This time we’ll learn how to find unused indexes [...]
June 28, 2012
MySQL Upgrade Webinar Questions Followup
I did a Webinar about MySQL Upgrade – Best Practices Yesterday and there were some questions we could not answer [...]
June 27, 2012
ALTER TABLE: Creating Index by Sort and Buffer Pool Size
Today I was looking at the ALTER TABLE performance with fast index creation and without it with different buffer pool [...]