Re: Bayes innodb problems

From: Alex Woick <alex(at)wombaz.de>
Date: Fri Sep 28 2007 - 21:24:17 EDT

>>> processing has ground down to really slow. I'm seeing
>>> some incredibly long queries now in my slow-query log,
>>> such as: 

>> Try an "optimize table <tabname>" for each of the sa
>> tables. You just filled the database from scratch, so
>> perhaps the counters/statistics do not reflect the actual
>> value distribution yet.

>
> Optimize table does not work with InnoDB.

Surely it does. According to the Mysql documentation, it defragments the indexes (it probably rebuilds them) and it updates the index statistics. Received on Fri Sep 28 21:27:43 2007