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 [...]
