From owner-freebsd-questions@FreeBSD.ORG Wed Apr 16 10:01:14 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 2D0CE1065671 for ; Wed, 16 Apr 2008 10:01:14 +0000 (UTC) (envelope-from fbsd.questions@rachie.is-a-geek.net) Received: from snoogles.rachie.is-a-geek.net (rachie.is-a-geek.net [66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id EF6168FC1B for ; Wed, 16 Apr 2008 10:01:13 +0000 (UTC) (envelope-from fbsd.questions@rachie.is-a-geek.net) Received: from localhost (localhost [127.0.0.1]) by snoogles.rachie.is-a-geek.net (Postfix) with ESMTP id D07AD1CC91; Wed, 16 Apr 2008 02:01:12 -0800 (AKDT) From: Mel To: freebsd-questions@freebsd.org Date: Wed, 16 Apr 2008 12:00:53 +0200 User-Agent: KMail/1.9.7 References: <740109F1ED7BA14EB02307DEF26487AB111C888B@ZABRYSVISEX04.af.didata.local> <200804151952.13502.fbsd.questions@rachie.is-a-geek.net> <740109F1ED7BA14EB02307DEF26487AB111C8E45@ZABRYSVISEX04.af.didata.local> In-Reply-To: <740109F1ED7BA14EB02307DEF26487AB111C8E45@ZABRYSVISEX04.af.didata.local> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200804161200.54385.fbsd.questions@rachie.is-a-geek.net> Cc: Vikash Badal Subject: Re: How do I use more process memory with mysqld X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 16 Apr 2008 10:01:14 -0000 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.