6 messages in com.mysql.lists.win32Re: Problem with count(*)
FromSent OnAttachments
Simson L. Garfinkel24 Jun 1999 18:29 
Michael Widenius28 Jun 1999 20:00 
Simson Garfinkel29 Jun 1999 09:36 
Michael Widenius29 Jun 1999 14:40 
Simson Garfinkel29 Jun 1999 17:38 
Michael Widenius30 Jun 1999 03:56 
Subject:Re: Problem with count(*)
From:Michael Widenius (mon@monty.pp.sci.fi)
Date:06/30/1999 03:56:48 AM
List:com.mysql.lists.win32

"Simson" == Simson Garfinkel <sims@vineyard.net> 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