Re: Bayes innodb problems

On Sat, 29 Sep 2007 03:24:17 +0200, Alex Woick <alex@wombaz.de> wrote:

>>>> 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.

I use the MySQL Tools to handle compacting and repair etc. For other jobs I use DBTools. Neither is perfect, but between them they get the job done.

I do most of my admin from windows but afaik the MySQL tools are cross platform.

Despite the above, I was (perhaps mistakenly) under the impression that the daily admin for bayes handled compaction etc.

Perhaps your problem lies elsewhere in your system? I know form ages back that lack of a PTR for the SQL server can slow things significantly if your DB is on a different box to your SA.

HTH Nigel Received on Sat Sep 29 10:29:10 2007