Date: Tue, 28 Jun 2005 20:57:52 -0600 From: Stephane Raimbault <stephane@enertiasoft.com> To: freebsd-stable@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux Message-ID: <3632CDAC-C52A-4D40-85B9-A1D7270C17E1@enertiasoft.com> In-Reply-To: <CDA5855A-1934-4BF7-944D-901A1B9CF8A9@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> <CDA5855A-1934-4BF7-944D-901A1B9CF8A9@enertiasoft.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <delphij frontfree net> 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" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3632CDAC-C52A-4D40-85B9-A1D7270C17E1>