On 3/21/06, Andrew Donkin <[EMAIL PROTECTED]> wrote: > Jason, if you haven't moved to innodb already, try "SHOW PROCESSLIST" > in mysql. Do you have many threads locked on "SELECT FROM > bayes_token" and "INSERT INTO bayes_token"?
Yep, that's it completely. > I had about 100 threads locked, so I am changing to InnoDB for its > fine-grained locking. About three days ago I issued "ALTER TABLE > bayes_token ENGINE innodb". I'll let you know when it finishes. *grin* I'm debating whether to try that or to wipe bayes compeltely and start from scratch.. *sigh* Or, I may dump the data and then re-import it into inno.. not sure what will be faster.. > Andrew Donkin Waikato University, Hamilton, New Zealand -- Jason 'XenoPhage' Frisvold [EMAIL PROTECTED]
