Hi!
>On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote:
>> The way to defragment InnoDB tables, or tables in any database, is from time
>> to time to dump and reimport them. That can give a significant performance
>> boost.
>>
>
>That is actually not entirely true. For MyISAM tables, one simply n
On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote:
> The way to defragment InnoDB tables, or tables in any database, is from time
> to time to dump and reimport them. That can give a significant performance
> boost.
>
That is actually not entirely true. For MyISAM tables, one simply needs
to run
Hi!
I forwarded the email to Monty if he has time to look at index usage.
The speedup .43 -> .44 may be due to better optimization of SQL queries, or
due to the table dumps and imports you made.
The way to defragment InnoDB tables, or tables in any database, is from time
to time to dump and rei
