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
> -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 do POP/SMTP authentication using
> vpopmail. I took a look at the varia
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
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
"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
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 momen
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 i
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 ex
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 you
