From owner-freebsd-questions@FreeBSD.ORG Thu Mar 16 13:34:28 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 3F9A916A44A for ; Thu, 16 Mar 2006 13:34:28 +0000 (UTC) (envelope-from dave.list@pixelhammer.com) Received: from ecluster4.tls.net (ecluster4.tls.net [65.196.224.134]) by mx1.FreeBSD.org (Postfix) with SMTP id 1231243D48 for ; Thu, 16 Mar 2006 13:34:20 +0000 (GMT) (envelope-from dave.list@pixelhammer.com) Received: (qmail 58035 invoked by uid 89); 16 Mar 2006 13:34:19 -0000 Received: from unknown (HELO ?192.168.0.102?) (ldg%tls.net@204.8.13.41) by auth-ecluster4.tls.net with SMTP; 16 Mar 2006 13:34:19 -0000 Message-ID: <4419694E.3090805@pixelhammer.com> Date: Thu, 16 Mar 2006 08:34:06 -0500 From: DAve 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> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 13:34:28 -0000 Greg 'groggy' Lehey wrote: > > - Which version of FreeBSD are you running? 4.11 and 5.4 We will not be upgrading to 6 anytime soon if at all. > > - Which version of MySQL are you running? > 4.0.2 > - If you're not running MySQL 5.0, why not? > Why should we use 5.0? We use MySQL in a production environment. We cannot spend time troubleshooting issues. When a new version has a capability we cannot live without we test, test, test, test it first, then spend much time reading forums to see what problems others have been having. We have run crippled software before because WE found the bug and had to wait for a fix. No fun delaying a production application. When the opportunity presents itself we install and test new software or new versions to help the developers move forward (we tested and ran Ruby On Rails for three months, now working with it to see if it has a place in our development environment). But we cannot do that all the time. Also we have many older pieces of hardware that cannot run a newer version because the older hardware cannot support the newer OS, which in turn is required to run the newest MySQL. The new MySQL, if not compatible with the old MySQL, does me no good. Example, we have many old Sparc boxes, still going strong, running Solaris 2.5 and MySQL 3.23. If I use MySQL 5.0 I can no longer use replication. So an upgrade to MySQL 5.0 means new hardware. It's a hard sell upstairs unless the new combination offers substantial improvement. (Yes the Sparcs are old, but they run, and they run, and they run. Sometimes we forget to check on them they are so reliable, I wish my new hardware was as good). We are looking at a package to upgrade the older Sparcs to 4.0.2, but "If it ain't broke....." > - 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? Used to be all compiled source, now we use the ports collection. > > - Which threading library are you using? Why? Default, because that is what the ports maintainer supports. > > - Have you had to change the default installation (different compile > flags, different installation directories, etc.)? No, maybe optimized if needed. > > - Do you have any problems that you think are related to the choice of > the version you're using? > None, MySQL is a rock. DAve -- This message was checked by forty monkeys and found to not contain any SPAM whatsoever. Your monkeys may vary