Feh! v2

edit

sunfire gets a bit of a slap

Posted by Ian Holsman Fri, 31 Mar 2006 13:02:00 GMT

and doesn’t seem to take it too nicely :-(

I decided to install the mysql beta on my laptop (Mac Intel @2G ram and 2GHZdual core) and my sunfire (@8G ram and 16 1GHZ Ultrasparcs).

(I have it installed on a x86-64 box as well, but that machine is busy at the moment)..

so for a quick sanity check I ran mysqlslap to see how it performs.

I chose to simulate a 20 concurrent users

sunfire$ mysqlslap -psunfire -c 20 -i 20
Benchmark
        Average number of seconds to run all queries: 1.714 seconds
        Minimum number of seconds to run all queries: 0.941 seconds
        Maximum number of seconds to run all queries: 2.539 seconds
        Number of clients running queries: 20
        Average number of queries per client: 0

vs

laptop$ mysqlslap -i 20 -c 20
Benchmark
        Average number of seconds to run all queries: 1.201 seconds
        Minimum number of seconds to run all queries: 1.072 seconds
        Maximum number of seconds to run all queries: 1.569 seconds
        Number of clients running queries: 20
        Average number of queries per client: 0

now.. before you get all pissy at me, these installs are both from mysql.com, are BETA release using ‘default’ setups.. I know they need tuning.

so I decided to run the mysqlslap against blastwave’s mysql5 (5.0.19) which has a bit better default setup (IMHO)

sunfire $ mysqlslap -c 20 -i 20
Benchmark
        Average number of seconds to run all queries: 1.647 seconds
        Minimum number of seconds to run all queries: 0.882 seconds
        Maximum number of seconds to run all queries: 2.783 seconds
        Number of clients running queries: 20
        Average number of queries per client: 0

still the same kind of numbers. one thing I did find interesting was that I only saw one connection in the SHOW PROCESS LIST command.

any mysql guru’s want to tell me what I’m doing wrong on the test here?

update: this is what I get on a x86-64 machine.

$ bin/mysqlslap -c 20 -i 20 -a
Benchmark
        Average number of seconds to run all queries: 0.002 seconds
        Minimum number of seconds to run all queries: 0.002 seconds
        Maximum number of seconds to run all queries: 0.003 seconds
        Number of clients running queries: 20
        Average number of queries per client: 0

same deal.. no tweaking of configurations, just download the tarball from mysql.com and fire it up.

anyone have any ideas?