Re: Problem with count(*)

[Michael Widenius]

>>>>> "Simson" == Simson Garfinkel <simsong@stripped> writes:

>> 
>> >>
>> >> If you use 'isamchk -Si table'
>> >> the indexed will be ordered and you will have much fewer disk seeks.
>> >>
Simson> Can we run "isamchk -Si table" on an active table while the SQL
Simson> database is
Simson> running
>> 
>> hi!
>> 
>> Sorry, no.
>> 
Simson> Oh, that's bad. Makes it hard to do 24x7 operation.

I know; We will shortly integrate isamchk into MySQL;  This will make
things much easier.

Regards,
Monty