Interesting Things
- MySql only allows indexes on 64 columns per table. This is a hard limit, set in the header file, and therefore can’t even be changed at compile time without editing that file first. It was suggested that anyone who wants more than 64 indexes should not be using a database for searches anyway — use something like Solr instead.
Also, considering that MySQL will only ever use one index per table in a query, if you hit this limit, you’re probably doing something wrong. (I wrote up this and a few other lesser-known tips here.)
September 4, 2008 at 12:09 pm
@Brad — Thank you for the tips!
September 4, 2008 at 5:13 pm