From owner-freebsd-questions@FreeBSD.ORG Wed Apr 16 08:08:49 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 763441065675 for ; Wed, 16 Apr 2008 08:08:49 +0000 (UTC) (envelope-from Vikash.Badal@is.co.za) Received: from phobytor.is.co.za (phobytor.is.co.za [196.4.160.171]) by mx1.freebsd.org (Postfix) with ESMTP id E8A8E8FC21 for ; Wed, 16 Apr 2008 08:08:48 +0000 (UTC) (envelope-from Vikash.Badal@is.co.za) Received: from phobytor.is.co.za (localhost [127.0.0.1]) by phobytor.is.co.za (Postfix) with ESMTP id DCAF53BACAD; Wed, 16 Apr 2008 10:08:50 +0200 (SAST) Received: from ZABRYSVISMFW (zajnbisit.mfw.is.co.za [196.26.2.106]) by phobytor.is.co.za (Postfix) with ESMTP id AD2E73BACA8; Wed, 16 Apr 2008 10:08:50 +0200 (SAST) Received: from zabrysvisex03.af.didata.local (Not Verified[10.1.8.13]) by ZABRYSVISMFW with MailMarshal (v6, 1, 8, 2172) id ; Wed, 16 Apr 2008 10:08:29 +0200 Received: from ZABRYSVISEX04.af.didata.local ([10.1.8.148]) by zabrysvisex03.af.didata.local with Microsoft SMTPSVC(6.0.3790.211); Wed, 16 Apr 2008 10:08:46 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Date: Wed, 16 Apr 2008 10:08:44 +0200 Message-ID: <740109F1ED7BA14EB02307DEF26487AB111C8E45@ZABRYSVISEX04.af.didata.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How do I use more process memory with mysqld Thread-Index: AcifIXvgnjKqWi8YSkOhaHkcyb1pdwAd1uUg References: <740109F1ED7BA14EB02307DEF26487AB111C888B@ZABRYSVISEX04.af.didata.local> <200804151952.13502.fbsd.questions@rachie.is-a-geek.net> From: "Vikash Badal" To: "Mel" , X-OriginalArrivalTime: 16 Apr 2008 08:08:46.0741 (UTC) FILETIME=[1859CC50:01C89F99] X-Virus-Scanned: ClamAV using ClamSMTP Cc: 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 08:08:49 -0000 =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.