From owner-freebsd-database@FreeBSD.ORG Sun Jan 15 04:37:57 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8362216A420 for ; Sun, 15 Jan 2006 04:37:57 +0000 (GMT) (envelope-from bryanh@meridian-enviro.com) Received: from newman.meridian-enviro.com (newman.meridian-enviro.com [207.109.235.166]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0A07543D46 for ; Sun, 15 Jan 2006 04:37:56 +0000 (GMT) (envelope-from bryanh@meridian-enviro.com) Received: from [192.168.2.12] (tamarack.meridian-enviro.com [192.168.2.12]) by newman.meridian-enviro.com (8.13.1/8.13.1) with ESMTP id k0F4bXoa061907; Sat, 14 Jan 2006 22:37:33 -0600 (CST) (envelope-from bryanh@meridian-enviro.com) Date: Sat, 14 Jan 2006 22:37:33 -0600 (CST) From: "Bryan C. Hahn" To: Justin Bastedo In-Reply-To: <8a5255240601141608t78ed7ffdheacad67307abe8d@mail.gmail.com> Message-ID: <20060114222654.Y43774@tamarack.meridian-enviro.com> References: <8038a35b0601140918t459b534cnea1c2a22ea578cc@mail.gmail.com> <8a5255240601141608t78ed7ffdheacad67307abe8d@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: ClamAV 0.84/1242/Sat Jan 14 18:00:41 2006 on newman.meridian-enviro.com X-Virus-Status: Clean Cc: freebsd-database@freebsd.org Subject: Re: MySQL and FreeBSD native threads X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 15 Jan 2006 04:37:57 -0000 On Sat, 14 Jan 2006, Justin Bastedo wrote: > > I've been using MySQL 5 now for about 6 months in a productin > environment and haven't had any problems. Our co-located master server > replicates to an inhouse slave. and neither has given us any problems. > > Uptime: 6355651 Threads: 2 Questions: 143125480 Slow queries: 0 Opens: > 0 Flush tables: 2 Open tables: 55 Queries per second avg: 22.519 > > >uptime > 5:42PM up 129 days, 4:17, 1 user, load averages: 0.03, 0.03, 0.00 > > seeing a mild load, nothing too heavy, and mainly inserts and selects > and has been really stable. > > Justin > Justin, I'm glad to hear you're having success with this MySQL 5 and FreeBSD combination. We'd really love to hear what your configuration is: * Is mysql installed from ports? If so, what knobs did you twist? * What threading configuration are you using? (Linux, native, etc.) * Anything special in the my.cnf file? * Are you using Innodb? BDB? * Exactly what version of FreeBSD? * SMP or UP? AMD or Intel? Motherboard? Amount of memory? * RAID? If so, ATA or SATA or SCSI? What controller and RAID configuration? * Is the slave configuration roughly the same? We have almost no experience with MySQL 4 or 5 on any version of FreeBSD. We have been successfully using MySQL 3.23 on both FreeBSD 4 and 5 *without* threading. Obviously for us, upgrading MySQL would be a good thing, and finding a suitable, reliable configuration would be even better. - Bryan