spamassassin-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Woick <>
Subject Re: Bayes innodb problems
Date Sat, 29 Sep 2007 01:24:17 GMT
>>> 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.

View raw message