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

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

A micro-benchmark of stored routines in MySQL

 | August 16, 2009 |  Posted In: Benchmarks

Ever wondered how fast stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of a stored function against a “roughly equivalent” subquery. The idea — and there may be shortcomings that are poisoning the results here, your comments welcome — is to see how fast the SQL procedure code […]

Read More

High-Performance Click Analysis with MySQL

 | December 22, 2008 |  Posted In: Insight for Developers

We have a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types of work.  The first thing these have in common is that they’re generally some kind of loggable event. The next characteristic of a lot of these systems (real or planned) is […]

Read More