Date: Sat, 02 Oct 2010 09:20:34 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: Rumen Telbizov <telbizov@gmail.com> Cc: freebsd-stable@freebsd.org Subject: Re: MySQL performance concern Message-ID: <4CA6EB52.1080504@infracaninophile.co.uk> In-Reply-To: <AANLkTikGHByF0dJ-hj6zPoRhV6YoHGSrW3g0audama3M@mail.gmail.com> References: <AANLkTikGHByF0dJ-hj6zPoRhV6YoHGSrW3g0audama3M@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigFA676F082840325875787B01
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
On 02/10/2010 08:06:52, Rumen Telbizov wrote:
> Hello everyone,
>=20
> I am experimenting with MySQL running on FreeBSD and comparing with ano=
ther
> (older) setup running on a Linux box.
> My results show that performance on Linux is significantly better than
> FreeBSD although the hardware is weaker.
> I'd appreciate your comments and ideas.
>=20
> Here's the setup:
>=20
> 1) FreeBSD 8.1-STABLE amd64 (Tue Sep 14 15:29:22 PDT 2010) running on a=
> SuperMicro machine with 2 x Dual Core
> Xeon E5502 1.87Ghz ; 4 x SAS 15K in RAID10 setup under ZFS (two mirrore=
d
> pairs) and 2 x SSD X25-E partitioned
> for: 8G for ZIL and the rest for L2ARC; 16G ram with 8 of them given to=
> mysql and tons of free.
>=20
> 2) Linux Gentoo with 3 SATA disks in hardware RAID5 with similar
> cpu/motherboard and same memory size.
>=20
> The sole application that runs is a python script which inserts a batch=
of
> lines at a time. Only myisam is used as a format.
> Here's the problem: On the Linux box it manages to push around
> *5800*inserts/second while on the FreeBSD box
> it's only *4000/*second.
>=20
> MySQL version is 5.1.51
>=20
> During this load the disk subsystem on FreeBSD is pretty much idle (bot=
h the
> SSDs and the SAS disks). CPU utilization
> contributed to mysqld is only around 30%. So I am clearly heavily
> under-utilizing the hardware.
> Linuxthreads support for 64bit architectures is not available so I coul=
dn't
> try that but aside from that I tried recompiling
> mysql with all the different Makefile options available without any eff=
ect.
> Changing the recordsize in zfs to 8K doesn't make any difference.
> Tried percona binary without any luck.
>=20
> Let me know what additional information would be useful and I'll provid=
e it
> here.
>=20
> Thank you in advance for your comments and suggestions.
Um... a fairly obvious point, but have you tuned the mysql configuration
appropriately on both machines? I'd guess you have, but you didn't
mention it. As I recall, the default configuration you get out of the
box with mysql is suitable for a machine with something like 64MB RAM.
Not at all appropriate nowadays where dedicated DB server hardware would
be more likely to have 64*G*B than 64*M*B...
Cheers,
Matthew
--=20
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
JID: matthew@infracaninophile.co.uk Kent, CT11 9PW
--------------enigFA676F082840325875787B01
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.14 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkym61oACgkQ8Mjk52CukIy28QCggeJLygQzvIyswTHstLCA6TDN
mcwAnRJFLKOSK/rBKOIn2BgAMYZm4PpU
=JNnG
-----END PGP SIGNATURE-----
--------------enigFA676F082840325875787B01--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4CA6EB52.1080504>