On Sun, Jun 30, 2002 at 05:55:12PM +0200, Magnus Manske wrote:
cur_user_text and old_user_text are "tinyblob", so MySQL won't index them.
Hmm, any reason why you didn't make them binary varchar's? But are you sure our MySQL can't index those? The manual says that since version 3.23.2 you can index BLOB's if you are using MyISAM tables and we use those.
As we will switch to that codebase when we switch servers, there's probably no need to fix minor bugs here for the time being.
The query without an index looks really really expensive to me. If this is what makes Wikipedia unusable at the moment, I wouldn't call it a minor bug. Maybe we could simply turn it off for a short period and see what happens?
-- Jan Hidders