RE: Server tuning

2004-06-30 Thread Chip Bell
To: 'João Paulo Vasconcellos '; 'Mysql-general Mailing List ' Subject: RE: Server tuning max_memory is roughly equivalent to ==> key_buffer_size + (read_buffer_size + sort_buffer_size) * max_connections -Original Message- From: João Paulo Vasconcellos To: Mysql-gen

Re: Server tuning

2004-06-29 Thread Eric Bergen
If it starts swapping you have key_buffer set to high. -Eric On Tue, 29 Jun 2004 15:41:20 -0500, Victor Pendleton <[EMAIL PROTECTED]> wrote: > > max_memory is roughly equivalent to ==> key_buffer_size + (read_buffer_size > + sort_buffer_size) * max_connections > > > -Original Message-

RE: Server tuning

2004-06-29 Thread Victor Pendleton
max_memory is roughly equivalent to ==> key_buffer_size + (read_buffer_size + sort_buffer_size) * max_connections -Original Message- From: João Paulo Vasconcellos To: Mysql-general Mailing List Sent: 6/29/04 1:09 PM Subject: Server tuning Hello everybody, I am setting up a server to d

Re: Server Tuning

2001-02-26 Thread Dave Hodgkinson
"Florian G. Pflug" <[EMAIL PROTECTED]> writes: > Hi > > I am running Mysql on a Machine with two PIII-600, and 1 GB of RAM. > The disks are connected via U2W-SCSI. > > I tried tuning mysql for maximal performance the last days, but I'm not > exactly sure which parameters I should increase, und