Re: FreeBSD MySQL still WAY slower than Linux
From: Peter Kieser (pfak_at_telus.net)
Date: 06/26/05
- Previous message: Shawn Mitchell: "RE: Re[2]: FreeBSD MySQL still WAY slower than Linux"
- In reply to: Shawn Mitchell: "RE: Re[2]: FreeBSD MySQL still WAY slower than Linux"
- Next in thread: T.D.Wipnet (H.M.): "Re: FreeBSD MySQL still WAY slower than Linux"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 26 Jun 2005 00:38:54 -0700 To: Shawn Mitchell <shawnm@iodamedia.net>
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.
>>
>>
>
>
>
>
_______________________________________________
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: Shawn Mitchell: "RE: Re[2]: FreeBSD MySQL still WAY slower than Linux"
- In reply to: Shawn Mitchell: "RE: Re[2]: FreeBSD MySQL still WAY slower than Linux"
- Next in thread: T.D.Wipnet (H.M.): "Re: FreeBSD MySQL still WAY slower than Linux"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
