From owner-freebsd-current@FreeBSD.ORG Fri Oct 28 06:54:02 2005 Return-Path: X-Original-To: current@FreeBSD.org Delivered-To: freebsd-current@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3365216A41F; Fri, 28 Oct 2005 06:54:02 +0000 (GMT) (envelope-from grog@lemis.com) Received: from ext-gw.lemis.com (ext-gw.lemis.com [150.101.14.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id D486D43D46; Fri, 28 Oct 2005 06:54:00 +0000 (GMT) (envelope-from grog@lemis.com) Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.135]) by ext-gw.lemis.com (Postfix) with ESMTP id E42091310AB; Fri, 28 Oct 2005 16:23:57 +0930 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id C202484BDF; Fri, 28 Oct 2005 16:23:57 +0930 (CST) Date: Fri, 28 Oct 2005 16:23:57 +0930 From: Greg 'groggy' Lehey To: Robert Watson Message-ID: <20051028065357.GE10365@wantadilla.lemis.com> References: <435F48DA.6060009@kernel32.de> <20051026105411.L32255@fledge.watson.org> <20051027074229.GA825@eucla.lemis.com> <20051027145435.H32255@fledge.watson.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="FN+gV9K+162wdwwF" Content-Disposition: inline In-Reply-To: <20051027145435.H32255@fledge.watson.org> User-Agent: Mutt/1.4.2.1i Organization: The FreeBSD Project Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.FreeBSD.org/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 Cc: current@FreeBSD.org, Marian Hettwer Subject: Re: MySQL Performance 6.0rc1 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 28 Oct 2005 06:54:02 -0000 --FN+gV9K+162wdwwF Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thursday, 27 October 2005 at 14:57:10 +0100, Robert Watson wrote: > On Thu, 27 Oct 2005, Greg 'groggy' Lehey wrote: > >> This would be interesting to know, doubtless, but please note that MySQL >> 4.0 is either no longer supported or will reach that status in the >> immediate future. It would be more interesting to see what the >> performance difference is between Linux and FreeBSD with MySQL 5.0, >> which has just been released. >> >> If you find reasons to believe that any problems you're seeing are a >> MySQL problem, please let me know. > > I'm not certain it's a "MySQL Problem" so much as a set of changes that > happen to be less optimal on FreeBSD than Linux. Understood. That's why I wrote it the way I did. Over the last few years, FreeBSD and MySQL have stopped working together as well as they used to. We recently saw a (single) customer with crashes that we haven't been able to analyse, because they only occur on their production system. It looks as if the "solution" chosen by customer management (against strong resistance from the techies) is to move to Linux. This kind of issue, but also performance differences, are a disadvantage for both groups. One of my tasks at MySQL is to do something about that, but I'm spread pretty thin. If anybody has input on this kind of topic, I'd be interested to hear from you. Greg -- See complete headers for address and phone numbers. --FN+gV9K+162wdwwF Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDYcsFIubykFB6QiMRAvmHAJ9Jo6pIK8qab5qzS4fdSDoLSPCzVACff8rj iIWIflwZQmBwGidEkpzuqDE= =qG61 -----END PGP SIGNATURE----- --FN+gV9K+162wdwwF--