From owner-freebsd-database@FreeBSD.ORG Wed Dec 22 19:19:09 2004 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DF19416A4CE for ; Wed, 22 Dec 2004 19:19:09 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.199]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6694F43D45 for ; Wed, 22 Dec 2004 19:19:05 +0000 (GMT) (envelope-from tethys.ocean@gmail.com) Received: by rproxy.gmail.com with SMTP id y7so296rne for ; Wed, 22 Dec 2004 11:19:02 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=mbzNtuf3+mMP0DcUUVKkoNqTjFbGhjYQkxFMBQY1G1ALtthjA+A56NTvGyDGl0m+LFZpxnGL7oCO0pqr4omaA39IOn/P7UX4IyhGXlr2c0oJZLacV/XF1Ph+yVMib7loYcizw5k03VeZ4qoEDknqT8sxN9L4obg2ZnpggTvx5UE= Received: by 10.38.11.2 with SMTP id 2mr195809rnk; Wed, 22 Dec 2004 11:12:21 -0800 (PST) Received: by 10.38.66.67 with HTTP; Wed, 22 Dec 2004 11:12:21 -0800 (PST) Message-ID: <235b800004122211121f3e0b3e@mail.gmail.com> Date: Wed, 22 Dec 2004 21:12:21 +0200 From: tethys ocean To: freebsd-database@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Subject: top list X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: tethys ocean List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Dec 2004 19:19:10 -0000 Mysql running on an IBM dopuble cpu server freebsd 5.2.1 RELEASE whenever I said that TOP PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 1313 mysql 132 0 79712K 45832K RUN 0 49.0H 93.31% 93.31% mysqld 333 bind 96 0 11696K 11008K select 1 19:59 0.00% 0.00% named 524 root 123 0 3852K 2612K select 0 8:24 0.00% 0.00% sendmail 58617 www 4 0 13792K 10844K accept 1 5:08 0.00% 0.00% httpd 322 root 96 0 1320K 788K select 0 4:10 0.00% 0.00% syslogd 191 root 8 0 1836K 1328K nanslp 0 3:42 0.00% 0.00% ipmon 1314 root 127 0 1420K 968K select 1 2:19 0.00% 0.00% inetd 32189 root 96 0 11272K 7980K select 1 1:24 0.00% 0.00% httpd 519 mailnull 96 0 1752K 1028K select 0 0:13 0.00% 0.00% mimedefang 570 mailnull -8 0 23196K 22392K piperd 1 0:03 0.00% 0.00% perl 549 root 8 0 1344K 916K nanslp 0 0:03 0.00% 0.00% cron 508 mailnull -8 0 23196K 22392K piperd 1 0:03 0.00% 0.00% perl 466 root 96 0 3508K 1812K select 0 0:01 0.00% 0.00% sshd 57903 www 4 0 13412K 10480K accept 1 0:01 0.00% 0.00% httpd 67624 root 4 0 4232K 3044K connec 0 0:01 0.00% 0.00% sendmail 68261 root 96 0 2320K 1444K select 0 0:01 0.00% 0.00% top 57904 www 4 0 13184K 10200K accept 1 0:01 0.00% 0.00% httpd 57907 www 4 0 12328K 9332K accept 1 0:01 0.00% 0.00% httpd 57902 www 4 0 11452K 8388K accept 1 0:01 0.00% 0.00% httpd 58618 www 4 0 11408K 8400K accept 1 0:01 0.00% 0.00% httpd 57901 www 4 0 11456K 8424K accept 1 0:00 0.00% 0.00% httpd 57924 www 4 0 11480K 8424K accept 1 0:00 0.00% 0.00% httpd 68634 root 96 0 2320K 1436K CPU0 0 0:00 0.00% 0.00% top 527 smmsp 20 0 3604K 2316K pause 1 0:00 0.00% 0.00% sendmail 57905 www 4 0 11596K 8608K accept 1 0:00 0.00% 0.00% httpd 58404 www 4 0 11404K 8328K accept 1 0:00 0.00% 0.00% httpd 739 root 8 0 1348K 912K wait 0 0:00 0.00% 0.00% bash 68231 parker 96 0 6244K 2444K RUN 0 0:00 0.00% 0.00% sshd 506 mailnull 96 0 2300K 1012K select 0 0:00 0.00% 0.00% mimedefang-multiple Mysql consume all cpu its just strange any 12 virtual user that has database webpage What mysql can consume nearly all CPU?