Date: Wed, 21 May 2008 15:55:08 +0200 From: CZUCZY Gergely <phoemix@harmless.hu> To: <t.pajor@kei.pl> Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 Message-ID: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> In-Reply-To: <be8c1fa47808266f0e520175c6bbbf1e.t.pajor@kei.pl> References: <be8c1fa47808266f0e520175c6bbbf1e.t.pajor@kei.pl>
next in thread | previous in thread | raw e-mail | index | archive | help
--Sig_/=Rf2Coto30j9VmefrbqNFj6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable May I ask whether you are using innodb or myisam? both on freebsd and Linux. And what filesystem are you using for mysql's data files? UFS, ZFS or anyth= ing else? IIRC there's some hack to reduce gettimeofday()'s precision in advance to enhance it's performance, that could also help a bit. Have you built your m= ysql with linking it against libthr? On Wed, 21 May 2008 15:01:32 +0200 <t.pajor@kei.pl> wrote: > Hello, >=20 > I'm using mysql 5.1.24-rc in 5 separate jails. >=20 > Question: >=20 > 10 clients are pushing queries (10 separate machines). 2 clients to 1 mys= ql > daemon. One client is performing an update on param_stat_short_level_1_0, > second on param_stat_short_level_1_1. >=20 > Each client needs to push 150000 queries (client is spawning 15 forks to = push > the 150000, so each fork is pushing 10000, each fork is opening it's own > mysql connection). >=20 > query to push: >=20 > INSERT INTO param_stat_short_level_1_0 SET param =3D '10311', object =3D = '10311', > value =3D '4283' ON DUPLICATE KEY UPDATE param =3D '10311', object =3D '1= 0311', > value =3D '4283', min =3D IF(4283<min,4283,min), max =3D IF(4283>max,4283= ,max), > counter =3D counter+1; >=20 > Always a different param, and object values, value is rand(1,10000). >=20 > Stats for the operations are in http://p1.kei.pl/stats. > Stats are collected after each clients pushes 150000, 100 times. >=20 > My point here is that MySQL on Linux (p5) performs 150000 queries in an > average of 18.1099, when the same queries on FreeBSD (p1) takes 28.7643. >=20 > Did I misconfigured something or this are the proper result and FreeBSD j= ust > could not give more? >=20 > My configs below, thanks for Your time. >=20 > http://p1.kei.pl/TLD > http://p1.kei.pl/dmesg > http://p1.kei.pl/boot_loader_conf > http://p1.kei.pl/sysctl_conf > http://p1.kei.pl/my_cnf > http://p1.kei.pl/stats >=20 >=20 >=20 > _______________________________________________ > 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" --=20 =C3=9Cdv=C3=B6lettel, Czuczy Gergely Harmless Digital Bt mailto: gergely.czuczy@harmless.hu Tel: +36-30-9702963 --Sig_/=Rf2Coto30j9VmefrbqNFj6 Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFINCm+zrC0WyuMkpsRAsBgAJ4+LMK+SgnSftn4uIvfdQKcF+YrYwCfdOfW KdZsmdSgUCozao6LAgdWf1w= =KZ7r -----END PGP SIGNATURE----- --Sig_/=Rf2Coto30j9VmefrbqNFj6--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080521155508.6ccfcfb5>