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>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] 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 anything 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 mysql with linking it against libthr? On Wed, 21 May 2008 15:01:32 +0200 <t.pajor@kei.pl> wrote: > Hello, > > I'm using mysql 5.1.24-rc in 5 separate jails. > > Question: > > 10 clients are pushing queries (10 separate machines). 2 clients to 1 mysql > daemon. One client is performing an update on param_stat_short_level_1_0, > second on param_stat_short_level_1_1. > > 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). > > query to push: > > INSERT INTO param_stat_short_level_1_0 SET param = '10311', object = '10311', > value = '4283' ON DUPLICATE KEY UPDATE param = '10311', object = '10311', > value = '4283', min = IF(4283<min,4283,min), max = IF(4283>max,4283,max), > counter = counter+1; > > Always a different param, and object values, value is rand(1,10000). > > Stats for the operations are in http://p1.kei.pl/stats. > Stats are collected after each clients pushes 150000, 100 times. > > 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. > > Did I misconfigured something or this are the proper result and FreeBSD just > could not give more? > > My configs below, thanks for Your time. > > 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 > > > > _______________________________________________ > 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" -- Üdvölettel, Czuczy Gergely Harmless Digital Bt mailto: gergely.czuczy@harmless.hu Tel: +36-30-9702963 [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFINCm+zrC0WyuMkpsRAsBgAJ4+LMK+SgnSftn4uIvfdQKcF+YrYwCfdOfW KdZsmdSgUCozao6LAgdWf1w= =KZ7r -----END PGP SIGNATURE-----home | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080521155508.6ccfcfb5>