From owner-freebsd-stable@FreeBSD.ORG Mon Jun 27 16:14:42 2005 Return-Path: X-Original-To: stable@freebsd.org Delivered-To: freebsd-stable@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F0EC616A41C for ; Mon, 27 Jun 2005 16:14:42 +0000 (GMT) (envelope-from steve@pepcross.com) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by mx1.FreeBSD.org (Postfix) with ESMTP id B684C43D1D for ; Mon, 27 Jun 2005 16:14:42 +0000 (GMT) (envelope-from steve@pepcross.com) Received: from mail.lonres.com ([194.70.153.187]) by anchor-post-31.mail.demon.net with esmtp (Exim 4.42) id 1DmwBt-0006sK-3j; Mon, 27 Jun 2005 16:10:33 +0000 Received: from pepcross.com (bibipentium.lonres.com [10.10.10.225]) by mail.lonres.com (Postfix) with SMTP id 27EFB2E07C; Mon, 27 Jun 2005 17:14:41 +0100 (BST) Received: by pepcross.com (sSMTP sendmail emulation); Mon, 27 Jun 2005 17:15:12 +0100 Date: Mon, 27 Jun 2005 17:15:12 +0100 From: Steve Roome To: markir@paradise.net.nz Message-ID: <20050627161512.GE643@bibipentium.lonres.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i Cc: stable@freebsd.org Subject: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 27 Jun 2005 16:14:43 -0000 On Mon Jul 20, (I was reading the web archive) Mark Kirkwood wrote: > With respect to Mysql performance, I would suspect threading or > threading/kernel interaction as the culprit. (That reminds me, I > don't recall seeing the original poster re-doing the tests with > 6.0-CURRENT - that would be interesting). Sorry for not getting back sooner. I posted these results and anything else that went with this thread to the freebsd-performance mailing list. -current proved a slightly better performer for us, but not enough to bring it even close to the performance we get with gentoo. Off the top of my head the select key benchmarks were ROUGHLY: FreeBSD 5.various + MySQL 4.various : ROUGHLY 16k queries/second FreeBSD 6.0-current + MySQL 4.1.12 : ROUGHLY 18k queries/second Gentoo-something + MySQL 4.1.something : ROUGHLY 30k queries/second. The exact figures were posted to performance- (6.0 tests) and stable- (gentoo vs. freebsd 5.x). Good luck to anyone who can manage to get MySQL to perform as well on FreeBSD as Linux, we've been right out of luck so far and that's really not advocating FreeBSD very well, which is what I'd rather be doing. Steve