From owner-freebsd-questions@FreeBSD.ORG Tue Apr 15 15:35:22 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 264D9106564A for ; Tue, 15 Apr 2008 15:35:22 +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 99AFB8FC14 for ; Tue, 15 Apr 2008 15:35:21 +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 C35623BAB6C for ; Tue, 15 Apr 2008 17:07:21 +0200 (SAST) Received: from ZABRYSVISMFW (zajnbisit.mfw.is.co.za [196.26.2.106]) by phobytor.is.co.za (Postfix) with ESMTP id 930EB3BAA13 for ; Tue, 15 Apr 2008 17:07:21 +0200 (SAST) Received: from ZABRYSVISEX05.af.didata.local (Not Verified[10.1.8.14]) by ZABRYSVISMFW with MailMarshal (v6, 1, 8, 2172) id ; Tue, 15 Apr 2008 17:07:01 +0200 Received: from ZABRYSVISEX04.af.didata.local ([10.1.8.148]) by ZABRYSVISEX05.af.didata.local with Microsoft SMTPSVC(6.0.3790.1830); Tue, 15 Apr 2008 17:07:17 +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: Tue, 15 Apr 2008 17:07:14 +0200 Message-ID: <740109F1ED7BA14EB02307DEF26487AB111C888B@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: AcifCmMMd2FQLufAT2KfyebbX37bmQ== From: "Vikash Badal" To: X-OriginalArrivalTime: 15 Apr 2008 15:07:17.0707 (UTC) FILETIME=[653D61B0:01C89F0A] X-Virus-Scanned: ClamAV using ClamSMTP Subject: 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: Tue, 15 Apr 2008 15:35:22 -0000 Greetings, I am trying to get mysql to use more memory, at present it seems stuck at around 1G >From the mysql lists the it was suggested that I increase kern.maxdsiz, kern.dfdl, kern.maxssiz In /boot/loader.conf. Having set the values of kern.maxdsiz and kern.dfdl mto 6G, I still cant use more than 1G on mysql: sysctl -a | grep kern.max kern.maxvnodes: 100000 kern.maxproc: 6164 kern.maxfiles: 12328 kern.maxfilesperproc: 11095 kern.maxprocperuid: 5547 kern.maxusers: 384 >From dmesg: CPU: Intel(R) Xeon(TM) CPU 2.80GHz (2793.20-MHz K8-class CPU) =20 Origin =3D "GenuineIntel" Id =3D 0xf48 Stepping =3D 8 =20 Features=3D0xbfebfbff =20 Features2=3D0x649d> =20 AMD Features=3D0x20100800 =20 AMD Features2=3D0x1 =20 Cores per package: 2 =20 Logical CPUs per core: 2 real memory =3D 17716740096 (16896 MB) avail memory =3D 16638013440 (15867 MB) uname -a FreeBSD greateastern.dial-up.net 6.1-RELEASE-p5 FreeBSD 6.1-RELEASE-p5 #0: limits -H Resource limits (current): =20 cputime infinity secs =20 filesize infinity kB =20 datasize 33554432 kB =20 stacksize 524288 kB =20 coredumpsize infinity kB =20 memoryuse infinity kB =20 memorylocked infinity kB =20 maxprocesses 5547 =20 openfiles 11095 =20 sbsize infinity bytes =20 vmemoryuse infinity kB >From top 93 processes: 1 running, 92 sleeping CPU states: 1.1% user, 0.0% nice, 0.6% system, 0.1% interrupt, 98.2% idle Mem: 980M Active, 8893M Inact, 344M Wired, 616M Cache, 214M Buf, 2477M Free Swap: 31G Total, 116K Used, 31G Free =20 PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND 48647 mysql 35 20 0 963M 938M kserel 0 718.9H 22.17% mysqld Please advise Vikash 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.