Re: Bayes innodb problems

On Fri, 28 Sep 2007 at 21:57 +0300, jarif@iki.fi confabulated:

>> Micah Anderson schrieb am 27.09.2007 02:20:
>>
>>> 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.

Are you sure? An excerpt from the MySQL 5.0 documentation found here:

   http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html

   "OPTIMIZE TABLE works only for MyISAM, InnoDB, and (as of MySQL 5.0.16)     ARCHIVE tables. It does not work for tables created using any other     storage engine."

I've never tried it myself as I've been using MyISAM without issues in a per account set up.

   _|_
  (_| | Received on Fri Sep 28 15:04:05 2007