From owner-freebsd-current@FreeBSD.ORG Tue Oct 16 11:06:44 2007 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 842DC16A417 for ; Tue, 16 Oct 2007 11:06:44 +0000 (UTC) (envelope-from scode@hyperion.scode.org) Received: from hyperion.scode.org (cl-1361.ams-04.nl.sixxs.net [IPv6:2001:960:2:550::2]) by mx1.freebsd.org (Postfix) with ESMTP id 571A913C457 for ; Tue, 16 Oct 2007 11:06:43 +0000 (UTC) (envelope-from scode@hyperion.scode.org) Received: by hyperion.scode.org (Postfix, from userid 1001) id C6D7823C423; Tue, 16 Oct 2007 13:06:42 +0200 (CEST) Date: Tue, 16 Oct 2007 13:06:42 +0200 From: Peter Schuller To: freebsd-current@freebsd.org Message-ID: <20071016110642.GB54457@hyperion.scode.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="rS8CxjVDS/+yyDmU" Content-Disposition: inline User-Agent: Mutt/1.5.16 (2007-06-09) Subject: Status of MySQL on 7 w/o patches applied 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: Tue, 16 Oct 2007 11:06:44 -0000 --rS8CxjVDS/+yyDmU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello, a few months ago there were reports of huge MySQL performance increases in FreeBSD 7, particularly in terms of scalability. In benchmarks, FreeBSD 7 seemed to match or (for the scalability part) exceed the performance of Linux. The report on these indicates some uncommitted patches were used, one of which was supposedly very important for performance (file descriptor locking IIRC). My question is - what is the expected status of MySQL performance in FreeBSD 7 (without external patches) at this time? I ask because I recently (a couple of weeks ago) did comparisons using sysbench (comparable to what was used in the benchmark used previously in the report) between 6.2 and 7-CURRENT. Selects were actually half as fast or less than 6.2 in this particular case (identical hardware). Now I realize I am not providing details here; I can most definitely provide a lot more detail. But first, is this *expected*? Are there patches that still have not been committed, or should we be expecting that FreeBSD 7 as it appears in CVS is comparable to Linux or better with MySQL? I will endeavor to re-run these comparisons with RELENG_7 within the near future (regardless of the answer to the above question). --=20 / Peter Schuller PGP userID: 0xE9758B7D or 'Peter Schuller ' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org --rS8CxjVDS/+yyDmU Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFHFJtCDNor2+l1i30RAgTbAJsEqZkIl4x+cgglV4sC8Dq30eJ97wCeNQ8u CRxtl1vrLBwr0KqeriCcnII= =Dcvd -----END PGP SIGNATURE----- --rS8CxjVDS/+yyDmU--