From owner-freebsd-questions Tue Oct 8 1:17:24 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 45F1D37B404 for ; Tue, 8 Oct 2002 01:17:23 -0700 (PDT) Received: from smtp.infracaninophile.co.uk (happy-idiot-talk.infracaninophile.co.uk [81.2.69.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id 37C6C43E6A for ; Tue, 8 Oct 2002 01:17:22 -0700 (PDT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost.infracaninophile.co.uk [IPv6:::1]) by smtp.infracaninophile.co.uk (8.12.6/8.12.6) with ESMTP id g988HLVc013562; Tue, 8 Oct 2002 09:17:21 +0100 (BST) (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost) by happy-idiot-talk.infracaninophile.co.uk (8.12.6/8.12.6/Submit) id g988HGTf013561; Tue, 8 Oct 2002 09:17:16 +0100 (BST) Date: Tue, 8 Oct 2002 09:17:16 +0100 From: Matthew Seaman To: dodi agusri Cc: freebsd-questions@FreeBSD.ORG Subject: Re: is mysql working well with FreeBSD 4.5 ? Message-ID: <20021008081716.GB10638@happy-idiot-talk.infracaninophi> Mail-Followup-To: Matthew Seaman , dodi agusri , freebsd-questions@FreeBSD.ORG References: <20021008075557.4921.qmail@web14809.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20021008075557.4921.qmail@web14809.mail.yahoo.com> User-Agent: Mutt/1.5.1i X-Spam-Status: No, hits=-10.4 required=5.0 tests=IN_REP_TO,REFERENCES,SPAM_PHRASE_03_05,USER_AGENT, USER_AGENT_MUTT version=2.41 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 On Tue, Oct 08, 2002 at 12:55:57AM -0700, dodi agusri wrote: > I plan to use MYSQL database server on FreeBSD 4.5. On > This server I intend to Setup my web based helpdesk > application using PHP/MYSQL. Is there any known bug > with this OS ?.I heard that there is thread problem > with previos FreeBSD version . mysql can have issues with threads under load on FreeBSD 4.x, that is true. However, it generally works fine on single processor FreeBSD boxes, and usually works fine on multiprocessor machines. If you're not maxing out your database machine, mysql will serve you well. If you are running a very busy (hundreds of hits per minute) database based web site, then you should put some serious thought into exactly what combination of database and server OS you use --- mysql on FreeBSD would not be a brilliant choice in that case. Of course, all this is true for FreeBSD 4.x. Threads have been completely reworked in 5-CURRENT and indications are that it will be a rather stellar performer. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks Savill Way Marlow Tel: +44 1628 476614 Bucks., SL7 1TH UK To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message