From owner-freebsd-questions@FreeBSD.ORG Sun Oct 31 16:01:24 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 731DD16A4CE for ; Sun, 31 Oct 2004 16:01:24 +0000 (GMT) Received: from istanbul.enderunix.org (freefall.marmara.edu.tr [193.140.143.23]) by mx1.FreeBSD.org (Postfix) with SMTP id 47F8243D3F for ; Sun, 31 Oct 2004 16:01:23 +0000 (GMT) (envelope-from ofsen@enderunix.org) Received: (qmail 43817 invoked by uid 89); 31 Oct 2004 16:01:49 -0000 Message-ID: <20041031160149.43812.qmail@istanbul.enderunix.org> References: <20041031114514.19687.qmail@istanbul.enderunix.org> <4184D833.9020801@mac.com> In-Reply-To: <4184D833.9020801@mac.com> From: Omer Faruk Sen To: Chuck Swiger Date: Sun, 31 Oct 2004 18:01:48 +0200 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-9" Content-Transfer-Encoding: 7bit cc: freebsd-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 16:01:24 -0000 Everything that is stated in tuning man page was done. What is interesting that this site was running more than 8 months without problem. But a few weeks ago system was started to behave like that. By the way isn't it interesting that mysql creates load on system and nice? I think mysql should create load on "user". That is why I have send this problem to FreeBSD mailing list. I am using FreeBSD for more that 4 years 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. Chuck Swiger writes: > Omer Faruk Sen wrote: >> I have web server which uses php+mysql. As far as I have searched the >> best thing to use mysql on FreeBSD is to use linuxthreads. [ ... ] >> 240 processes: 7 running, 233 sleeping >> CPU states: 10.9% user, 73.9% nice, 12.5% system, 2.7% interrupt, 0.0% >> idle >> Mem: 244M Active, 1309M Inact, 309M Wired, 93M Cache, 199M Buf, 56M Free >> Swap: 3072M Total, 24K Used, 3072M Free > > Well, you've managed to saturate the available CPU power with the > workload. If you've already done some performance tuning at the FreeBSD > level by adjusting your kernel config and followed "man tuning", you > aren't likely to get much further by tweaking FreeBSD's config. > > Look into optimizing your database utilization by checking the SQL query > histogram, particularly if your site ends up doing transaction(s) for each > HTTP hit. People write books on database management and tuning, and you > should look there rather than to a FreeBSD list for advice. :-) > > You could also get another machine and run the database and webserver on > seperate systems to help site performance by dividing and concentrating > the workload. Consider switching from MySQL to postgres or a database you > actually pay for: Oracle, Sybase, Frontbase, etc. > > You could also consider another web middleware/scripting evironment than > PHP which handles database interactions more efficiently: Zope, JSP, > WebObjects. > > -- > -Chuck > ----------------------- 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