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
-----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 = 768M max_allowed_packet = 2M table_cache = 1024 sort_buffer_size = 4M read_buffer_size = 4M read_rnd_buffer_size = 16M myisam_sort_buffer_size = 128M thread_cache_size = 8 query_cache_size = 64M max_connections = 200 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 server-id = 31 aths to different dedicated disks #tmpdir = /tmp/ tmpdir = /mnt/ramfs/tmp/ [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 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+Confidentiality+Notice+and+Disclaimer.htm. Should you not have Web access, send a mail 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>