Date: Wed, 21 May 2008 15:01:32 +0200 From: <t.pajor@kei.pl> To: <freebsd-performance@freebsd.org> Subject: mysql performance on freebsd 7 Message-ID: <be8c1fa47808266f0e520175c6bbbf1e.t.pajor@kei.pl>
next in thread | raw e-mail | index | archive | help
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 d= aemon. One client is performing an update on param_stat_short_level_1_0, se= cond on param_stat_short_level_1_1. Each client needs to push 150000 que= ries (client is spawning 15 forks to push the 150000, so each fork is pushi= ng 10000, each fork is opening it's own mysql connection). query to push= : 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', ob= ject =3D '10311', value =3D '4283', min =3D IF(4283<min,4283,min), max =3D = IF(4283>max,4283,max), counter =3D 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 1= 50000, 100 times. My point here is that MySQL on Linux (p5) performs 150= 000 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 res= ult and FreeBSD just could not give more? My configs below, thanks for Y= our 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 h= ttp://p1.kei.pl/stats
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?be8c1fa47808266f0e520175c6bbbf1e.t.pajor>