Date: Wed, 16 Apr 2008 12:00:53 +0200 From: Mel <fbsd.questions@rachie.is-a-geek.net> To: freebsd-questions@freebsd.org Cc: Vikash Badal <Vikash.Badal@is.co.za> Subject: Re: How do I use more process memory with mysqld Message-ID: <200804161200.54385.fbsd.questions@rachie.is-a-geek.net> In-Reply-To: <740109F1ED7BA14EB02307DEF26487AB111C8E45@ZABRYSVISEX04.af.didata.local> References: <740109F1ED7BA14EB02307DEF26487AB111C888B@ZABRYSVISEX04.af.didata.local> <200804151952.13502.fbsd.questions@rachie.is-a-geek.net> <740109F1ED7BA14EB02307DEF26487AB111C8E45@ZABRYSVISEX04.af.didata.local>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wednesday 16 April 2008 10:08:44 Vikash Badal wrote:
> -----Original Message-----
>
> > From: Mel [mailto:fbsd.questions@rachie.is-a-geek.net]
> > Sent: 15 April 2008 07:52 PM
> > To: freebsd-questions@freebsd.org
> > Cc: Vikash Badal
> > Subject: Re: How do I use more process memory with mysqld
> >
> > On Tuesday 15 April 2008 17:07:14 Vikash Badal wrote:
> > > datasize 33554432 kB
> >
> > That says 3G.
> >
> > > 48647 mysql 35 20 0 963M 938M kserel 0 718.9H
> >
> > 22.17% mysqld
> >
> > Your my.cnf is missing. Are you sure you're allowing mysql to
> > go beyong 1G?
>
> Sorry about that ... Missed that one.
>
> My.cnf:
> ~~~~~~~~~~
> # The MySQL server
> [mysqld]
> key_buffer =3D 768M
> max_allowed_packet =3D 2M
> table_cache =3D 1024
> sort_buffer_size =3D 4M
> read_buffer_size =3D 4M
> read_rnd_buffer_size =3D 16M
> myisam_sort_buffer_size =3D 128M
> thread_cache_size =3D 8
> query_cache_size =3D 64M
> max_connections =3D 200
key_buffer_size + (read_buffer_size + sort_buffer_size) * max_connections =
=3D=20
max_mem_usage:
768 + (4 + 4) * 200 =3D 2368
=46rom the 963 shown in top, I'm guessing you're around 22 concurrent=20
connections. The key buffer is allocated on start up, read/sort buffer on p=
er=20
connection base. So if you want it to use more memory, put more in the key=
=20
buffer and make sure to leave 1.6G for your max connections.
=2D-=20
Mel
Problem with today's modular software: they start with the modules
and never get to the software part.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200804161200.54385.fbsd.questions>