From owner-freebsd-stable@FreeBSD.ORG Wed Jun 29 02:56:02 2005 Return-Path: X-Original-To: freebsd-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 CA02016A41C for ; Wed, 29 Jun 2005 02:56:02 +0000 (GMT) (envelope-from stephane@enertiasoft.com) Received: from mx1.enertiatech.com (h204-9-110-143.enertiatech.com [204.9.110.143]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8CDAC43D1F for ; Wed, 29 Jun 2005 02:56:02 +0000 (GMT) (envelope-from stephane@enertiasoft.com) Received: from localhost (localhost [127.0.0.1]) by mx1.enertiatech.com (Postfix) with ESMTP id 0890B60FD for ; Tue, 28 Jun 2005 20:56:05 -0600 (MDT) Received: from mx1.enertiatech.com ([127.0.0.1]) by localhost (mx1.enertiatech.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 40903-04 for ; Tue, 28 Jun 2005 20:56:03 -0600 (MDT) Received: from [192.168.1.249] (sputnik1.integer8.net [205.206.122.73]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by mx1.enertiatech.com (Postfix) with ESMTP id 2616460FA for ; Tue, 28 Jun 2005 20:56:03 -0600 (MDT) Mime-Version: 1.0 (Apple Message framework v730) In-Reply-To: <94EAD23E-BD3F-41E3-9590-E4BAD0CB6AC0@enertiasoft.com> References: <1dbad315050621051525f4c6fc@mail.gmail.com> <200506211451.j5LEpA2W024350@lurza.secnetix.de> <20050628092126.GB48140@isis.sigpipe.cz> <1119973124.7900.20.camel@zappa.Chelsea-Ct.Org> <20050628163928.GA51923@isis.sigpipe.cz> <1119978184.7900.36.camel@zappa.Chelsea-Ct.Org> <20050628171739.GC51923@isis.sigpipe.cz> <20050628190151.GA22060@frontfree.net> <94EAD23E-BD3F-41E3-9590-E4BAD0CB6AC0@enertiasoft.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Stephane Raimbault Date: Tue, 28 Jun 2005 20:55:55 -0600 To: freebsd-stable@freebsd.org X-Mailer: Apple Mail (2.730) X-Virus-Scanned: amavisd-new at enertiasoft.com Subject: Re: 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: Wed, 29 Jun 2005 02:56:02 -0000 I also quickly put a wiki together to help me document any kind of testing or patching we can try. Feel free to contribute. My hope is we can refer others to this document, and not create too much noise on this list as others have suggested is being created (the noise that is). I hope this can help us out to get MySQL humming on -STABLE, if it isn't already. Thanks, Stephane On 28-Jun-05, at 5:08 PM, Stephane Raimbault wrote: > > On 28-Jun-05, at 1:01 PM, Xin LI wrote: > >>> >>> > > >> >> We care about why MySQL appears to be slower, how to improve the >> situation, >> and not numbers from poorly done benchmarks which ignored the >> effect of >> debugging options, version, disk mount options, etc., which is IMHO >> meaningless. >> >> Maybe a key feature of the new FreeBSD installer would be to >> automatically >> tune the user's system (including kernel and other loader/sysctl >> tunings) >> according to installed ports :-) >> >> To make benchmarks a help provided to improve FreeBSD, a better >> start would >> be to run MySQL with profiling options compiled in, to find out the >> bottleneck and report them (maybe with patches if you have some >> idea). >> >> Cheers, >> -- >> Xin LI http://www.delphij.net/ >> See complete headers for GPG key and other information. >> >> >> > > > > I'm by far not a developer or a programmer, but I am a sysadmin > running MySQL on FreeBSD 4.x and 5.x And I am having performance > problems running FreeBSD 5.4 + SMP with MySQL. I don't seem to > have these problems on my other 4.x servers. > > The Hardware: > > Dell PowerEdge 2850 > Dual 2.8 XEON > 4Gig of RAM > Raid controller PERC 4/DC > 2x 36Gig 10K drives running Raid 1 for the system > 4x72Gig 15K drives running raid 0+1 for where to put my mysql > innodb based database. > > The database is about 10Gigs in size all InnoDB tables. > > This box is currently setup to slave from the master. My goal is > to get the box to replace the master. Currently it is not used in > production, so I am free to do what I want to this box. > > I'm running MySQL 4.1.12 > > I noticed a couple things > > PAE kernel (no SMP) > > System crashed while simply slaving from the master. The system > seemed stable doing nothing for 36 hours prior to this. > > SMP Kernel > > System was stable, however slaving from the master seemed to me > VERY slow. > > GENERIC Kernel > > System was stable, and slaving was quite a bit faster. > > > My Goal, is to provide some information that the real miracle > workers, the programmers and developers that can contribute to > FreeBSD help me identify the problems and where they lie and how to > best go about finding solutions for these problems. > > So my question is. What kind of information can I provide you all > to help identify the problems that I'm seeing, and quite possibly > others are seeing. > > Xin, you are talking about something regarding profiling of mysql. > If you can point me in the right direction to setup my box to > provide the necessary information, I have the time and the will to > provide the right information so we can move forward in making > FreeBSD the Operating System we all want it to be. > > I also promise to post some usable information for other people > wanting to setup MySQL on FreeBSD once we have identified where are > problems lie. This is probably the best way I, myself can > contribute back to the FreeBSD Community. > > Thank you, > Stephane. > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable- > unsubscribe@freebsd.org" >