EmergencyEMERGENCY? Get 24/7 Help Now!

Quick comparison of MyISAM, Infobright, and MonetDB

 | September 29, 2009 |  Posted In: MySQL

Recently I was doing a little work for a client who has MyISAM tables with many columns (the same one Peter wrote about recently). The client’s performance is suffering in part because of the number of columns, which is over 200. The queries are generally pretty simple (sums of columns), but they’re ad-hoc (can access […]

Read More

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

Attempting to Quantify Fragmentation Effects

 | September 18, 2009 |  Posted In: Tokutek, TokuView

We often hear from customers and MySQL experts that fragmentation causes problems such as wasting disk space, increasing backup times, and degrading performance. Typical remedies include periodic “optimize table” or dump and re-load (for example, see Project Golden Gate). Unfortunately, these techniques impact database availability and/or require additional administrative cost and complexity. Tokutek’s Fractal Tree […]

Read More