From owner-freebsd-questions@FreeBSD.ORG Sun Oct 31 17:34:41 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0CB9E16A4CE for ; Sun, 31 Oct 2004 17:34:41 +0000 (GMT) Received: from istanbul.enderunix.org (freefall.marmara.edu.tr [193.140.143.23]) by mx1.FreeBSD.org (Postfix) with SMTP id D78FC43D2D for ; Sun, 31 Oct 2004 17:34:39 +0000 (GMT) (envelope-from ofsen@enderunix.org) Received: (qmail 53341 invoked by uid 89); 31 Oct 2004 17:35:06 -0000 Message-ID: <20041031173506.53336.qmail@istanbul.enderunix.org> References: In-Reply-To: From: Omer Faruk Sen To: TM4525@aol.com Date: Sun, 31 Oct 2004 19:35:05 +0200 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-9" Content-Transfer-Encoding: 7bit cc: questions@freebsd.org Subject: Re: mysql and system/nice cpu usage X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 31 Oct 2004 17:34:41 -0000 Hi The oid you are talking about is not valid in FreeBSD-4. Maybe you are talking about FreeBSD-5 sysctl oids? But it does worth to try but I am not sure which oid it is in FreeBSD 4.. REGARDS PS: I have found vm.kvm_size. I think it is the one that corresponds in your email? TM4525@aol.com writes: > In a message dated 10/31/04 11:03:12 AM Eastern Standard Time, > ofsen@enderunix.org writes: >>but never come across with a problem like that. I am thinking to use Zend >>Optimizer. Maybe that helps me .. >> >>If that doesn't help I was thinking to run sql on a seperate machine. > > You might try tuning kern.vm.kmem.size if thats not in the tuning suggestions. > The OS tends to allocate way more memory than needed for the kernel if > you have a lot of memory in the system; you probably don't need more than > 100M or so unless you're running bgp or something unusual. Once you start > swapping with mysql and php you're dead. > > Moving to another system can help, but be aware that if your network is > busy it can add some "different" inefficiencies. If you do go to a separate > system connect it with a dedicated NIC if possible, to alleviate network > backup. If you have a multiple bus machine, moving your NIC to a separate > bus from the HDD can significantly increase performance. When you have > the NIC and HDD on the same bus, heavy network traffic can cause disk > operations to back up and substantially slow database applications. Make > sure the busses are really separate (and not cascaded), otherwise it won't > help. > > Also if you're on a 32bit bus machine you'll have a lot more contention than > with a pci-x bus. Most people think that if you have enough bus then it > doesnt matter, but thats dead wrong. Bus contention between devices is > a major performance factor. ----------------------- Omer Faruk Sen http://www.EnderUNIX.ORG Software Development Team @ Turkey http://www.Faruk.NET For Public key: http://www.enderunix.org/ofsen/ofsen.asc ******************************************************** First Turkish FreeBSD book is out! Go check it. Duydunuz mu! Turkiye'nin ilk FreeBSD kitabi cikti. http://www.acikkod.com/freebsd.php