From: Eric Bergen
Date: June 29 2004 11:21pm
Subject: Re: Server tuning
List-Archive: http://lists.mysql.com/mysql/168123
Message-Id: <11b1bd9904062916216c6809d2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

If it starts swapping you have key_buffer set to high.

-Eric

On Tue, 29 Jun 2004 15:41:20 -0500, Victor Pendleton
<vpendleton@stripped> wrote:
>=20
> max_memory is roughly equivalent to  =3D=3D> key_buffer_size + (read_buff=
er_size
> + sort_buffer_size) * max_connections
>=20
>=20
> -----Original Message-----
> From: Jo=E3o Paulo Vasconcellos
> To: Mysql-general Mailing List
> Sent: 6/29/04 1:09 PM
> Subject: Server tuning
>=20
> Hello everybody,
>=20
>   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 subject, or I was not capable of finding the right
> place. What I want to know is how can I calculate how much memory I
> should give to key_buffer before I start to give away too much memory.
> That's because I got only 1GB of RAM and I have about 34k domains in
> my database, averaging from 8 to 15 accounts each. In a normal
> situation, there are ~400 simultaneous clients. I was wanting to know
> how can I estimate the memory usage for this scenario, if exists some
> kind of formula to answer this, like:
>=20
> clients * total size of key fields used in query
>=20
> or if this is some thing that is clear in the manual (if so, my
> apologies, but I could not find).
>=20
> TIA,
> --
> Jo=E3o Paulo Vasconcellos
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3DVPendleton@stripped
>=20
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Deric.bergen@gmail=
.com
>=20
>