By fernando | August 12, 2009

Indexing text columns in MySQL

This time, I’m talking about indexes for string typed columns. In particular, I’ll show a procedure I find useful while looking for good index length values for these columns.

I’ll use a sample table called people.

Here’s what it looks like:

mysql> desc people;
+————+——————+——+—–+———+—————-+
| Field | Type [...]

RSS my ohloh journal

Events

O'Reilly MySQL Conference & Expo 2010