Date: Sun, 26 Jun 2005 00:38:54 -0700 From: Peter Kieser <pfak@telus.net> To: Shawn Mitchell <shawnm@iodamedia.net> Cc: 'Michael Vince' <mv@roq.com>, 'Steve Roome' <steve@pepcross.com>, 'Daniel Gerzo' <danger@rulez.sk>, performance@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux Message-ID: <42BE5B8E.6070702@telus.net> In-Reply-To: <20050626032128.CB954204F16@kcmop04.iodamedia.net> References: <20050626032128.CB954204F16@kcmop04.iodamedia.net>
next in thread | previous in thread | raw e-mail | index | archive | help
They work fine on RELENG_5. --Peter Shawn Mitchell wrote: >Can't remember off the top of my head, I'll throw 5.x onto a lab box here in >a bit and see. > >-Shawn > > >-----Original Message----- >From: Daniel Gerzo [mailto:danger@rulez.sk] >Sent: Saturday, June 25, 2005 2:59 PM >To: Shawn Mitchell >Cc: 'Michael Vince'; 'Steve Roome'; performance@freebsd.org >Subject: Re[2]: FreeBSD MySQL still WAY slower than Linux > >Nemam dobru naladu Shawn, > >Saturday, June 25, 2005, 7:26:22 PM, si odoslal: > > > >>I tested a MySQL install on a Dell 6600. It's specs were 8 GB ram, 12 x >> >> >73 > > >>15k rpm drives (Ultra320) on a RAID5, 4 Xeon MP w/ 2 meg of cache, HT >>enabled so the OS saw 8 CPU's. >> >> > > > >>Every time, a stock linux install (SuSE, CentOS, and Fedora) were always >>faster than FreeBSD stock, or custom kernel utilizing different options. >> >> > > > >>I never could fully benchmark it running on Linux; as I never got the >> >> >server > > >>to max out before my benchmarking machine maxed out. >> >> > > > >>If your using 4.x, add these to your config file >> >> > > > >>options MAXDSIZ="(256*1024*1024)" >>options MAXSSIZ="(256*1024*1024)" >>options DFLDSIZ="(256*1024*1024)" >> >> > >these are not possible to use under 5.x? > > > >>I noticed a HUGE difference on FreeBSD with those added, but it still >>doesn't crank up there with Linux. >> >> > > > >>Also, default linux install's do not make it use more ram. You still have >>to copy one of the my-xxx.cnf files over to /etc/my.cnf or >>/usr/local/etc/my.cnf >> >> > > > >>MySQL is developed on Linux, and ported to FreeBSD. That's the best >>explanation you'll get probably. >> >> > > > >>Your posting a lot of configuration here except the most easily >>important one for performance in MySQL, thats your my.cnf configuration >> >> >file > > >>You will more then double your performance if you just start off by >> >> >copying > > >>/usr/local/share/mysql/my-large.cnf >>to >>/var/db/mysql >>MySQL out of the box setup to use a tiny amount of ram and it wouldn't >>surprise me if a lot of Linux distributions have a much more high >>performance my.cnf file since most distributions are aimed at people who >>don't know what they are doing. >> >> > > > >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42BE5B8E.6070702>