From owner-freebsd-hackers@FreeBSD.ORG Mon Mar 21 15:34:52 2005 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 285C616A4CF for ; Mon, 21 Mar 2005 15:34:52 +0000 (GMT) Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by mx1.FreeBSD.org (Postfix) with ESMTP id 90E2E43D31 for ; Mon, 21 Mar 2005 15:34:51 +0000 (GMT) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.13.1/8.13.1) id j2LFYn4j095821; Mon, 21 Mar 2005 09:34:49 -0600 (CST) (envelope-from dan) Date: Mon, 21 Mar 2005 09:34:49 -0600 From: Dan Nelson To: iwan@staff.usd.ac.id Message-ID: <20050321153449.GD5243@dan.emsphone.com> References: <1111398027.423e968bcf453@webmail.usd.ac.id> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1111398027.423e968bcf453@webmail.usd.ac.id> X-OS: FreeBSD 5.4-PRERELEASE X-message-flag: Outlook Error User-Agent: Mutt/1.5.8i cc: freebsd-hackers@freebsd.org Subject: Re: mysql threads X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 21 Mar 2005 15:34:52 -0000 In the last episode (Mar 21), iwan@staff.usd.ac.id said: > I'm new in freebsd. I have a question about mysqld threads. I using > freebsd 5.1-RELEASE, default installation. Then I installing mysql > 4.xx.xx (i forgot). Not like httpd which automatic creating threads > when more connection exist. Mysql in my box is not creating threads, > it only exist with one thread. So if there is alot of connections > appear, mysql is down. It still alive in process, but hang. I try to > installing pthread library, but fail. There is dependencies, and I > dont know how to fix it. My question: How to make mysql creating > threads by automatic ? Mysql requires threads; it can't work without them. You're confused becuase the only threads package you have ever seen is apparantly LinuxThreads, which creates a separate process for each thread. You see separate processes in Apache (assuming 1.3 here) because it's a forking model, where each incoming request is handled by a separate process. Consider upgrading to FreeBSD 5.3 (or 5.4, to be released sometime next month), which has much better thread performance than 5.1 or 5.2.1. -- Dan Nelson dnelson@allantgroup.com