EmergencyEMERGENCY? Get 24/7 Help Now!

Why InnoDB index cardinality varies strangely

 | September 28, 2009 |  Posted In: Insight for DBAs, MySQL

This is a very old draft, from early 2007 in fact. At that time I started to look into something interesting with the index cardinality statistics reported by InnoDB tables. The cardinality varies because it’s derived from estimates, and I know a decent amount about that. The interesting thing I wanted to look into was […]

Read More

InnoDB/XtraDB Training in New York City!

 | September 25, 2009 |  Posted In: Events and Announcements, MySQL

Our Santa Clara/San Francisco training went great – 100% of survey respondents said they would recommend the same course to a friend.  I’m pleased to announce that such an opportunity exists – our next training location will be New York City on October 30, 2009. We’ve booked a training venue in the financial district of […]

Read More

Speaking at Highload.ru

 | September 24, 2009 |  Posted In: Events and Announcements, MySQL

This is a quick announcement to say that I’ll be speaking at HighLoad++ this year (October 12-14 in Moscow).  I’ll be presenting on a few topics: MySQL Performance Tuning (Conference Session) Quick Wins with Third Party Patches for MySQL (Conference Session) Performance Optimization for MySQL with InnoDB and XtraDB * (Full day class) This will […]

Read More

Guidance for MySQL Optimizer Developers

 | September 20, 2009 |  Posted In: Insight for Developers, MySQL

I spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably last 10 years I chased first Monty and later Igor with Optimizer complains and suggestions. Here are some general ideas which I think can help to make optimizer in MySQL, MariaDB or […]

Read More

Multi Column indexes vs Index Merge

 | September 19, 2009 |  Posted In: Insight for DBAs, MySQL

The mistake I commonly see among MySQL users is how indexes are created. Quite commonly people just index individual columns as they are referenced in where clause thinking this is the optimal indexing strategy. For example if I would have something like AGE=18 AND STATE=’CA’ they would create 2 separate indexes on AGE and STATE […]

Read More