From owner-freebsd-smp Sat Dec 9 16:34:55 2000 From owner-freebsd-smp@FreeBSD.ORG Sat Dec 9 16:34:53 2000 Return-Path: Delivered-To: freebsd-smp@freebsd.org Received: from Athena.webmagix.net (athena.webmagix.net [212.189.235.2]) by hub.freebsd.org (Postfix) with ESMTP id B392237B400 for ; Sat, 9 Dec 2000 16:34:51 -0800 (PST) Received: from ns (c106231.upc-c.chello.nl [212.187.106.231]) by Athena.webmagix.net (8.10.1/8.10.1) with SMTP id eBA0Yoo32574 for ; Sun, 10 Dec 2000 01:34:50 +0100 From: "Rick Jansen" To: Subject: MySQLd using just one CPU Date: Sun, 10 Dec 2000 01:37:12 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Importance: Normal Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Hi, I have a problem with my dedicated MySQL server running on 4.2-STABLE. When i stress the daemon to the max, and i look at top, the WCPU and CPU fields are both around 99%. Which is what i want. BUT... Looking at the CPU States, it says the machine is around 49% idle! This leads me to conclude that MySQL is using just one processor. In Linux, there are a lot of mysqld processes because of the different threadpackage (LinuxThreads instead of MIT). Is there a threadpackage of this kind for FreeBSD aswell? I guess that would use both cpu's.. What can i do about this? It's an awful waste of such a nice P3 733.. TIA Rick Jansen ****************************************** Server Administrator [Linux - FreeBSD] Websites: www.shellz.nl www.tweakers.net ICQ#: 3716519 E-mail: Rick@Tweakers.net, Rick@ShellZ.nl Get your free ShellZ at www.shellz.nl now! ****************************************** To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message