P.S.: you can test it easily, doing specific queries for each case.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: terça-feira, 4 de Novembro de 2003 23:51
To: Alexis Guia
Cc: 'Benjamin KRIEF'; [EMAIL PROTECTED]
Subject: Re: mysql memory usage
On Tue, Nov 04
Hi,
When creating indices, MyIsam needs a big sort buffer (See MySQL Manual:
myisam_sort_buffer_size: The buffer that is allocated when sorting the
index when doing a REPAIR or when creating indexes with CREATE INDEX or
ALTER TABLE. ).
I don't know how works ISAM tables, but you can try
Hi,
I think that MyISAM uses the key buffer only if needed. The same happens
with almost all the other buffers (read buffer, sort buffer, etc.).
;)
Alexis
-Original Message-
From: Benjamin KRIEF [mailto:[EMAIL PROTECTED]
Sent: segunda-feira, 3 de Novembro de 2003 21:00
To: [EMAIL