From owner-freebsd-questions@FreeBSD.ORG Tue Apr 28 13:19:15 2009 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 E0D92106564A for ; Tue, 28 Apr 2009 13:19:15 +0000 (UTC) (envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net) Received: from mailhub.rachie.is-a-geek.net (rachie.is-a-geek.net [66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id AD97A8FC39 for ; Tue, 28 Apr 2009 13:19:15 +0000 (UTC) (envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net) Received: from sarevok.dnr.servegame.org (mailhub.rachie.is-a-geek.net [192.168.2.11]) by mailhub.rachie.is-a-geek.net (Postfix) with ESMTP id 4D5127E837; Tue, 28 Apr 2009 05:19:14 -0800 (AKDT) From: Mel Flynn To: freebsd-questions@freebsd.org Date: Tue, 28 Apr 2009 15:19:12 +0200 User-Agent: KMail/1.11.2 (FreeBSD/8.0-CURRENT; KDE/4.2.2; i386; ; ) References: <2cd0a0da0904280122x5416837re97255dc37283dc5@mail.gmail.com> <49F6E261.6040808@aboutsupport.com> <2cd0a0da0904280521u125b4180s4e626670b67b73d5@mail.gmail.com> In-Reply-To: <2cd0a0da0904280521u125b4180s4e626670b67b73d5@mail.gmail.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200904281519.12945.mel.flynn+fbsd.questions@mailing.thruhere.net> Cc: Peter , VeeJay Subject: Re: Where am I wasting resources? How to fix this problem? 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, 28 Apr 2009 13:19:16 -0000 On Tuesday 28 April 2009 14:21:45 VeeJay wrote: > Hello Peter > > Thanks... I have tried the values but even after rebooting, I am still > getting the same old values as: > > server1# sysctl -a | grep maxdsiz > compat.ia32.maxdsiz: 536870912 > > server1# sysctl -a | grep maxssiz > compat.ia32.maxssiz: 67108864 It's a kenv(1) variable. Either way I don't think it's the problem. mysqld uses 1500 threads and many apache processes waiting for mysql to reply. You should figure out why that is, cause that sounds like a query that's holding a table lock and needing to sort the intermediate result set, stalling all other queries. If you really have ~1500 connections and consider that normal operation, then you may need more kernel memory. amd64 doesn't have a process memory limit (feature or bug I'm undecided on), so you can delete those. Instead set: vm.kmem_size_max="1024M" vm.kmem_size="1024M" -- Mel