RE: Server tuning

2004-06-30 Thread Chip Bell
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-general Mailing List Sent: 6/29/04 1

Server tuning

2004-06-29 Thread João Paulo Vasconcellos
Hello everybody, I am setting up a server to do POP/SMTP authentication using vpopmail. I took a look at the variables at global my.cnf and wondered what would be the best values for things like key_buffer, read_buffer_size and table_cache. I searched the manual, but it does not go deep in this

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

Re: Server tuning

2004-06-29 Thread Eric Bergen
: 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 do POP/SMTP authentication using vpopmail. I took a look at the variables at global my.cnf and wondered what would be the best values

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 to what

Server Tuning

2001-02-25 Thread Florian G. Pflug
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 to what value. Our web application is quite slow at the

Re: Idea: Automated server tuning?

2001-02-02 Thread Basil Hussain
Hi, Monty mentioned that they're looking at making virtually all of the run-time variables changeable WITHOUT a server restart. Once that happens, it's just a matter of programming and benchmarking to have a self-tuning system (to some degree). I hadn't really thought about the concept in

Idea: Automated server tuning?

2001-02-01 Thread Basil Hussain
Hi all, In the light of my recent experiences with tuning my MySQL server, I had a few ideas about how getting optimum performance from your MySQL server could be made a little easier for everyone. My idea is to have some kind of facility to 'auto-tune' the server configuration variables for

Re: Idea: Automated server tuning?

2001-02-01 Thread Jeremy D. Zawodny
On Thu, Feb 01, 2001 at 01:34:03PM +, Basil Hussain wrote: In the light of my recent experiences with tuning my MySQL server, I had a few ideas about how getting optimum performance from your MySQL server could be made a little easier for everyone. Agreed. Better documentation and