From owner-freebsd-stable@FreeBSD.ORG Sat Oct 2 22:30:08 2010 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 235B5106566B for ; Sat, 2 Oct 2010 22:30:08 +0000 (UTC) (envelope-from jdc@koitsu.dyndns.org) Received: from qmta06.westchester.pa.mail.comcast.net (qmta06.westchester.pa.mail.comcast.net [76.96.62.56]) by mx1.freebsd.org (Postfix) with ESMTP id C2EF18FC13 for ; Sat, 2 Oct 2010 22:30:07 +0000 (UTC) Received: from omta16.westchester.pa.mail.comcast.net ([76.96.62.88]) by qmta06.westchester.pa.mail.comcast.net with comcast id Dxtq1f0041uE5Es56yW81J; Sat, 02 Oct 2010 22:30:08 +0000 Received: from koitsu.dyndns.org ([98.248.41.155]) by omta16.westchester.pa.mail.comcast.net with comcast id DyW61f00B3LrwQ23cyW7li; Sat, 02 Oct 2010 22:30:08 +0000 Received: by icarus.home.lan (Postfix, from userid 1000) id 666A39B418; Sat, 2 Oct 2010 15:30:05 -0700 (PDT) Date: Sat, 2 Oct 2010 15:30:05 -0700 From: Jeremy Chadwick To: Rumen Telbizov Message-ID: <20101002223005.GA78136@icarus.home.lan> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) Cc: freebsd-stable@freebsd.org, Steven Hartland Subject: Re: MySQL performance concern 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: Sat, 02 Oct 2010 22:30:08 -0000 On Sat, Oct 02, 2010 at 01:18:20PM -0700, Rumen Telbizov wrote: > Hello everyone, > > Here's the requested information below: The tunings between your Linux and FreeBSD instances differ severely, and some of the variables don't even exist any longer (example: table_cache is now known as table_open_cache as of MySQL 5.1.3, and probably key_buffer vs. key_buffer_size too). Can you please rule out MySQL tunings being responsible for the problem? Here are your configuration bits, more sanely written: FreeBSD Linux -------------------------- -------------- ------------------ MySQL version 5.1.51 5.1.50 -------------------------- -------------- ------------------ my.cnf tuning FreeBSD Linux -------------------------- -------------- ------------------ key_buffer_size 8 GB ???? key_buffer ???? 4 GB max_allowed_packet 16 MB 1 MB table_open_cache 2048 ???? table_cache ???? 64 sort_buffer_size 64 MB 512 KB read_buffer_size 8 MB 256 KB read_rnd_buffer_size 16 MB 512 KB net_buffer_length ???? 8 KB myisam_sort_buffer_size 256 MB 8 MB thread_cache_size 64 ???? query_cache_size 32 MB ???? thread_concurrency 8 ???? max_heap_table_size 6 GB 6 GB -------------------------- -------------- ------------------ Can you also please provide "top" output for the mysqld process on FreeBSD? > * As for the ZFS. Here's the pool configuration: If you move things to UFS2, does the problem disappear? You might not be seeing any disk I/O on the filesystem with gstat because ZFS ARC could have all of the data in it. -- | Jeremy Chadwick jdc@parodius.com | | Parodius Networking http://www.parodius.com/ | | UNIX Systems Administrator Mountain View, CA, USA | | Making life hard for others since 1977. PGP: 4BD6C0CB |