Date: Wed, 16 Apr 2008 10:08:44 +0200 From: "Vikash Badal" <Vikash.Badal@is.co.za> To: "Mel" <fbsd.questions@rachie.is-a-geek.net>, <freebsd-questions@freebsd.org> Subject: RE: How do I use more process memory with mysqld Message-ID: <740109F1ED7BA14EB02307DEF26487AB111C8E45@ZABRYSVISEX04.af.didata.local> References: <740109F1ED7BA14EB02307DEF26487AB111C888B@ZABRYSVISEX04.af.didata.local> <200804151952.13502.fbsd.questions@rachie.is-a-geek.net>
next in thread | previous in thread | raw e-mail | index | archive | help
=20-----Original Message----- > From: Mel [mailto:fbsd.questions@rachie.is-a-geek.net]=20 > 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 >=20 > On Tuesday 15 April 2008 17:07:14 Vikash Badal wrote: >=20 > > datasize 33554432 kB >=20 > That says 3G. >=20 >=20 > > 48647 mysql 35 20 0 963M 938M kserel 0 718.9H=20 > 22.17% mysqld >=20 > Your my.cnf is missing. Are you sure you're allowing mysql to=20 > 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 # Try number of CPU's*2 for thread_concurrency thread_concurrency =3D 8 server-id =3D 31 aths to different dedicated disks #tmpdir =3D /tmp/ tmpdir =3D /mnt/ramfs/tmp/ [mysqldump] quick max_allowed_packet =3D 16M [mysql] no-auto-rehash [isamchk] key_buffer =3D 256M sort_buffer_size =3D 256M read_buffer =3D 2M write_buffer =3D 2M [myisamchk] key_buffer =3D 256M sort_buffer_size =3D 256M read_buffer =3D 2M write_buffer =3D 2M ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Please note: This email and its content are subject to the disclaimer as = displayed at the following link http://www.is.co.za/legal/E-mail+Confiden= tiality+Notice+and+Disclaimer.htm. Should you not have Web access, send a= =20mail to disclaimers@is.co.za and a copy will be emailed to you.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?740109F1ED7BA14EB02307DEF26487AB111C8E45>