From owner-freebsd-questions Tue Jun 11 7:30:35 2002 Delivered-To: freebsd-questions@freebsd.org Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by hub.freebsd.org (Postfix) with ESMTP id 4E50737B412 for ; Tue, 11 Jun 2002 07:30:10 -0700 (PDT) Received: (from dan@localhost) by dan.emsphone.com (8.12.3/8.12.3) id g5BEU8rs081146; Tue, 11 Jun 2002 09:30:08 -0500 (CDT) (envelope-from dan) Date: Tue, 11 Jun 2002 09:30:08 -0500 From: Dan Nelson To: Leo De Geer Cc: mysql@lists.mysql.com, freebsd-questions@FreeBSD.ORG Subject: Re: problem with mysql threads on freebsd Message-ID: <20020611143008.GB14164@dan.emsphone.com> References: <200206110836.55860.leo@ktv.se> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200206110836.55860.leo@ktv.se> User-Agent: Mutt/1.3.99i X-OS: FreeBSD 5.0-CURRENT X-message-flag: Outlook Error Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG In the last episode (Jun 11), Leo De Geer said: > im not abel to get mysql to use more then one thread on my freebsd > 4.5-stable any one having a klue that wrong????? Do not assume that the way Linux manages threads is the only one. Mysql on FreeBSD does create threads; they are just not visible via top (in fact Linux is the only OS that shows threads in top). FreeBSD's threads system, however will not put those threads on multiple CPUs. You can work around this by building the mysql port with LinuxThreads: cd /usr/ports/databases/mysql323-server make WITH_LINUXTHREADS=yes This is only useful if your system is dedicated to mysql, though. If it is a combination webserver/database, the other CPU will be busy enough serving webpages, and FreeBSD's regular threads will do fine. -- Dan Nelson dnelson@allantgroup.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message