From owner-freebsd-stable@FreeBSD.ORG Wed Jun 29 02:57:55 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 A275216A41C for ; Wed, 29 Jun 2005 02:57:55 +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 5D8F643D48 for ; Wed, 29 Jun 2005 02:57:55 +0000 (GMT) (envelope-from stephane@enertiasoft.com) Received: from localhost (localhost [127.0.0.1]) by mx1.enertiatech.com (Postfix) with ESMTP id 8AFE9610B for ; Tue, 28 Jun 2005 20:57:58 -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 40863-05 for ; Tue, 28 Jun 2005 20:57:57 -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 A5D326105 for ; Tue, 28 Jun 2005 20:57:57 -0600 (MDT) Mime-Version: 1.0 (Apple Message framework v730) In-Reply-To: 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: <3632CDAC-C52A-4D40-85B9-A1D7270C17E1@enertiasoft.com> Content-Transfer-Encoding: 7bit From: Stephane Raimbault Date: Tue, 28 Jun 2005 20:57:52 -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:57:55 -0000 speaking of noise.... how about I include a URL http://www.segr.ca/index.php/FreeBSD/MySQL sheesh... sorry to all. Stephane On 28-Jun-05, at 8:55 PM, Stephane Raimbault wrote: > 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" >> >> > > _______________________________________________ > 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" >