Buy Percona ServicesBuy Now!

Merge Tables Gotcha

 | May 9, 2007 |  Posted In: Insight for DBAs

I had the interesting customer case today which made me to do a bit research on the problem. You can create merge table over MyISAM tables which contain primary key and global uniqueness would not be enforced in this case, this is as far as most people will think about it. In fact however it […]

Read More

How to estimate time it takes Innodb to Recover ?

 | May 9, 2007 |  Posted In: Insight for DBAs

Today seems to be Innodb day in our Blog, but well this is the question which pops ups quite frequently in Innodb talks and during consulting engagements. It is well known to get better performance you should normally set innodb_log_file_size large. We however usually recommend caution as it may significantly increase recovery time if Innodb […]

Read More

MySQL Users Conference – Innodb

 | May 9, 2007 |  Posted In: Events and Announcements

It might look like it is too late to write about stuff happened at Users Conference but I’m just starting find bits of time from processing accumulated backlog. The Theme of this Users Conference was surely Storage Engines both looking at number of third party storage engine presented, main marketing message – Storage Engine partnership […]

Read More

Linux failing to boot screen on the plane

 | May 4, 2007 |  Posted In: Insight for DBAs

I’ve seen Windows Blue Screen of Death, stalled boot process or simply application error dialog on many big information screens in shops, airports and other places as well in other systems such as cache machines, airport self checking systems or photo print kiosk. Today coming back from US on NorthWest Airbus A330 we got stalled […]

Read More

Countless storage engines

 | May 3, 2007 |  Posted In: Insight for DBAs

Today everybody writes about MySQL Conference & Expo and I am not an exclusion. I am under impression of count of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture. In that time nobody was able to predict what is the […]

Read More

UC2007 Presentation and Notes

 | May 2, 2007 |  Posted In: Events and Announcements

I can’t write I’m just back from MySQL Users Conference both because I’m still in USA visiting customers and because it has ended almost a week ago but I was too busy to write anything about it or post my presentations. This was my 5th MySQL Users Conference so I met a lot of good […]

Read More

Back from RIT2007

 | April 20, 2007 |  Posted In: Events and Announcements

So I’m back from RIT2007 which took place April 16,17 in Moscow,Russia. The conference was well organized, while the conference center was a bit small for event – halls were jam packed during the breaks and there was limited sitting available for many sessions. It was great to see attendees from almost all serious Internet […]

Read More

How simple answer are you looking for ?

 | April 11, 2007 |  Posted In: Insight for Developers

I’ve got an interesting comment the other day saying “I’ve heard Jay Pipes saying indexes with cardinality lower than 30% are worthless, true?” That is interesting question and it has different answers depending on who is asking. A lot of people want to hear simple answers to the questions because they would be overwhelmed by […]

Read More

COUNT(*) vs COUNT(col)

 | April 10, 2007 |  Posted In: Insight for Developers

Looking at how people are using COUNT(*) and COUNT(col) it looks like most of them think they are synonyms and just using what they happen to like, while there is substantial difference in performance and even query result. Lets look at the following series of examples:

Read More

PBXT benchmarks

 | April 8, 2007 |  Posted In: Benchmarks

The PBXT Storage Engine ( is getting stable and we decided to benchmark it in different workloads. This time I tested only READ queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon ( The difference is I used new sysbench with Lua scripting language, so all queries were scripted for sysbench.

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.