Date: Mon, 21 Mar 2005 09:34:49 -0600 From: Dan Nelson <dnelson@allantgroup.com> To: iwan@staff.usd.ac.id Cc: freebsd-hackers@freebsd.org Subject: Re: mysql threads Message-ID: <20050321153449.GD5243@dan.emsphone.com> In-Reply-To: <1111398027.423e968bcf453@webmail.usd.ac.id> References: <1111398027.423e968bcf453@webmail.usd.ac.id>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050321153449.GD5243>