From owner-freebsd-performance@FreeBSD.ORG Thu Oct 28 07:49:15 2004 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 62AF416A4F8 for ; Thu, 28 Oct 2004 07:49:15 +0000 (GMT) Received: from istanbul.enderunix.org (freefall.marmara.edu.tr [193.140.143.23]) by mx1.FreeBSD.org (Postfix) with SMTP id D07C543D2F for ; Thu, 28 Oct 2004 07:49:11 +0000 (GMT) (envelope-from ofsen@enderunix.org) Received: (qmail 77920 invoked by uid 89); 28 Oct 2004 07:49:29 -0000 Message-ID: <20041028074929.77915.qmail@istanbul.enderunix.org> From: Omer Faruk Sen To: freebsd-performance@freebsd.org Date: Thu, 28 Oct 2004 10:49:29 +0300 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-9" Content-Transfer-Encoding: 7bit Subject: Mysql high cpu usage problem X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 28 Oct 2004 07:49:15 -0000 Hi, I have a system with apache+php+mysql. The system was fine for a long time but my problem started a few weeks ago. I have two 2.8 Ghz Xeon CPU's. Hyperthreading is enabled. 2 gigs of RAM. machdep.hlt_logical_cpus=0 and polling is enabled. Mysql (which was compiled with linux_threads and staticly linked libraries) has started to consume lots of cpu time (mainly system and nice times) Here's a moment from top output: last pid: 60888; load averages: 114.70, 114.42, 115.72 up 2+01:10:28 10:44:18 3 processes: 2 running, 1 sleeping CPU states: 1.7% user, 52.3% nice, 44.9% system, 1.1% interrupt, 0.0% idle Mem: 494M Active, 1034M Inact, 357M Wired, 97M Cache, 199M Buf, 21M Free Swap: 3072M Total, 104K Used, 3072M Free What's worth attention here is that, cpu spends nearly all of its time in kernel mode. Number of hits, the web server gets did not change much, maybe a little rise. Can you please provide some info tracking down the problem? ----------------------- 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