List:MySQL on Win32« Previous MessageNext Message »
From:Michael Widenius Date:June 30 1999 10:57am
Subject:Re: Problem with count(*)
View as plain text  
>>>>> "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.

Problem with count(*)Simson L. Garfinkel25 Jun
  • Problem with count(*)Michael Widenius29 Jun
  • Re: Problem with count(*)Simson Garfinkel29 Jun
    • Re: Problem with count(*)Michael Widenius30 Jun
  • Re: Problem with count(*)Simson Garfinkel30 Jun
    • Re: Problem with count(*)Michael Widenius30 Jun