Date: Sun, 31 Oct 2004 19:35:05 +0200 From: Omer Faruk Sen <ofsen@enderunix.org> To: TM4525@aol.com Cc: questions@freebsd.org Subject: Re: mysql and system/nice cpu usage Message-ID: <20041031173506.53336.qmail@istanbul.enderunix.org> In-Reply-To: <d1.1a9ff717.2eb676dc@aol.com> References: <d1.1a9ff717.2eb676dc@aol.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20041031173506.53336.qmail>