From owner-freebsd-questions@FreeBSD.ORG Thu Mar 16 12:55:40 2006 Return-Path: X-Original-To: questions@FreeBSD.org 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 AB72B16A41F for ; Thu, 16 Mar 2006 12:55:40 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from pi.codefab.com (pi.codefab.com [199.103.21.227]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4CAFB43D46 for ; Thu, 16 Mar 2006 12:55:40 +0000 (GMT) (envelope-from cswiger@mac.com) Received: from localhost (localhost [127.0.0.1]) by pi.codefab.com (Postfix) with ESMTP id 5F3E75F92; Thu, 16 Mar 2006 07:55:39 -0500 (EST) Received: from pi.codefab.com ([127.0.0.1]) by localhost (pi.codefab.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 87109-07; Thu, 16 Mar 2006 07:55:29 -0500 (EST) Received: from [192.168.1.3] (pool-68-160-194-11.ny325.east.verizon.net [68.160.194.11]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by pi.codefab.com (Postfix) with ESMTP id 42DDF5C6F; Thu, 16 Mar 2006 07:55:29 -0500 (EST) Message-ID: <44196046.4040000@mac.com> Date: Thu, 16 Mar 2006 07:55:34 -0500 From: Chuck Swiger Organization: The Courts of Chaos User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Greg 'groggy' Lehey References: <20060316101845.GA3776@eucla.lemis.com> In-Reply-To: <20060316101845.GA3776@eucla.lemis.com> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at codefab.com Cc: FreeBSD Questions Subject: Re: Do you use MySQL? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 16 Mar 2006 12:55:40 -0000 Greg 'groggy' Lehey wrote: [ ... ] > - Which version of FreeBSD are you running? 4.11, 5.4, 5-STABLE, 6-STABLE > - Which version of MySQL are you running? Generally: mysql-server-4.1.18_2 Multithreaded SQL database (server) [ using native pthreads ] > - If you're not running MySQL 5.0, why not? For the most part, I just use mysql for testing or for a backend to something like Wordpress; I've still got a production Oracle 8.1.7 database on a 6-disk Sun E250 for a mission-critical in-house system, and I'd generally go with that or with FrontBase or OpenBase on an Xserve for clients. I don't need anything from MySQL 5 that 4 doesn't provide. > - Where do you get your MySQL software from? > > * From the MySQL web site? > * From a FreeBSD CD/DVD distribution? > * Package (precompiled) from the FreeBSD web site (either directly > or via a mirror)? > * From the ports collection? Ports. > - Which threading library are you using? Why? Native pthreads. It's the default choice and works fine for what I do. > - Have you had to change the default installation (different compile > flags, different installation directories, etc.)? Nope. > - Do you have any problems that you think are related to the choice of > the version you're using? No. I doubt I'm running more than a query a second on average for what I'm using mysql for now. -- -Chuck