From owner-freebsd-database@FreeBSD.ORG Sun Jan 15 00:08:31 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 91D7216A41F for ; Sun, 15 Jan 2006 00:08:31 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id E3A6743D45 for ; Sun, 15 Jan 2006 00:08:30 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: by xproxy.gmail.com with SMTP id t12so691283wxc for ; Sat, 14 Jan 2006 16:08:30 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=fV5ldYXCuVqoJOLbgDYU2woPKgY8qRbgb7AXBG8nTFcrRyEFjQ9pjY17Ovx7m2Y8PqNsB1SDm5dvugccE9ePqZOSKlNzHrGxz6jCBP9/JIFwYdbbYUAydi8zLODGUUzKJ2W6np9R0usBzcALKC1mvPY3lMP2tLGsctrHSmtg8XU= Received: by 10.70.86.8 with SMTP id j8mr5881281wxb; Sat, 14 Jan 2006 16:08:29 -0800 (PST) Received: by 10.70.9.11 with HTTP; Sat, 14 Jan 2006 16:08:29 -0800 (PST) Message-ID: <8a5255240601141608t78ed7ffdheacad67307abe8d@mail.gmail.com> Date: Sat, 14 Jan 2006 16:08:29 -0800 From: Justin Bastedo To: Michael Bowerman In-Reply-To: <8038a35b0601140918t459b534cnea1c2a22ea578cc@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <8038a35b0601140918t459b534cnea1c2a22ea578cc@mail.gmail.com> 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 00:08:31 -0000 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 On 1/14/06, Michael Bowerman wrote: > A while ago, I was planning to move my MySQL server over from Linux to > FreeBSD. But, I was scared off by some blogs and the MySQL website > that said that FreeBSD threading had some problems dealing with high > loads, since some calls were not threadsafe. > > So, my question is this: has FreeBSD threading improved since the 4.x > line? It seems to me like a lot of work has gone into this area since > then. But, I haven't been able to find any updated information on 5.x > and 6.x. > > I'm trying to move completely to FreeBSD on my home network. So, I'd > prefer to make the switch. > > My server has a very small load and the data isn't exactly mission > critical (simple web stuff). So, even with the threading problem, it > would probably still meet my needs. But, it's mostly a matter of > worry free life cycle. I don't like to spend a lot of time on > maintenance (or wondering if it's my code, or the server), except for > upgrades. > > Thanks for your thoughts, > Mike > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.or= g" > -- Justin Bastedo At Gmail Dot Com -------------------------------------------------- http://www.thebastedo.com