Standup 09/03/2008

edit Posted by Joe Moore on Wednesday September 03, 2008 at 04:16PM

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.

Comments

  1. Brad Greenlee Brad Greenlee on September 04, 2008 at 12:09PM

    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.)


    remove

  2. Joe Moore Joe Moore on September 04, 2008 at 05:13PM

    @Brad -- Thank you for the tips!


    remove

Add a Comment (MarkDown available)