Re: Bayes innodb problems

[Alex Woick]

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.