Buy Percona ServicesBuy Now!

Analyzing air traffic performance with InfoBright and MonetDB

 | October 2, 2009 |  Posted In: Benchmarks, MySQL

Accidentally me and Baron played with InfoBright (see https://www.percona.com/blog/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And following Baron’s example I also run the same load against MonetDB. Reading comments to Baron’s post I tied to load the same data to LucidDB, but I was not successful in this. I tried to analyze a bigger dataset and I took public […]

Read More

EdUIConf 2009 recap

 | October 2, 2009 |  Posted In: Events and Announcements, MySQL

I spoke at EdUIConf 2009, a new conference in my hometown of Charlottesville, Virginia. My presentation was on web interface performance; it’s basically a twist on front-end performance in general. I slanted the talk towards web developers, rather than assuming the audience has full control over their Apache configuration. The conference was relatively short — […]

Read More

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