RE: Re[2]: FreeBSD MySQL still WAY slower than Linux
From: Shawn Mitchell (shawnm_at_iodamedia.net)
Date: 06/26/05
- Previous message: T.D.Wipnet (H.M.): "Re: FreeBSD MySQL still WAY slower than Linux"
- In reply to: Daniel Gerzo: "Re[2]: FreeBSD MySQL still WAY slower than Linux"
- Next in thread: Peter Kieser: "Re: FreeBSD MySQL still WAY slower than Linux"
- Reply: Peter Kieser: "Re: FreeBSD MySQL still WAY slower than Linux"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: "'Daniel Gerzo'" <danger@rulez.sk> Date: Sat, 25 Jun 2005 22:21:28 -0500
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.
-- Nieze by som chcel este nieco napisat, ale uz som to napisal. DanGer, ICQ: 261701668 | e-mail protecting at: http://www.2pu.net/ http://danger.rulez.sk | proxy list at: http://www.proxy-web.com/ | FreeBSD - The Power to Serve! [ s pokrokom by nic nebolo, len nie a nie ho skoncit. ] _______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org"
- Previous message: T.D.Wipnet (H.M.): "Re: FreeBSD MySQL still WAY slower than Linux"
- In reply to: Daniel Gerzo: "Re[2]: FreeBSD MySQL still WAY slower than Linux"
- Next in thread: Peter Kieser: "Re: FreeBSD MySQL still WAY slower than Linux"
- Reply: Peter Kieser: "Re: FreeBSD MySQL still WAY slower than Linux"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
