sunfire gets a bit of a slap -- update

Posted by Ian Holsman Mon, 03 Apr 2006 00:56:00 GMT

ok.. now this is getting stranger.

I have 2 windows open, in one I get
$ mysqlslap --use-threads -psunfire -c 90 -i 500
Benchmark
        Average number of seconds to run all queries: 2.180 seconds
        Minimum number of seconds to run all queries: 0.779 seconds
        Maximum number of seconds to run all queries: 4.497 seconds
        Number of clients running queries: 90
        Average number of queries per client: 0

and in the other i get
$ mysqlslap --use-threads -psunfire -c 90 -i 500
Benchmark
        Average number of seconds to run all queries: 0.012 seconds
        Minimum number of seconds to run all queries: 0.002 seconds
        Maximum number of seconds to run all queries: 0.015 seconds
        Number of clients running queries: 90
        Average number of queries per client: 0

same machine, same user-id, same binary. the only difference is that mysql started in the ‘fast’ window.

Posted in  | Tags , , ,  | no comments | 1 trackback

Comments

Trackbacks

Use the following link to trackback from your own site:
http://feh.holsman.net/trackbacks?article_id=sunfire-gets-a-bit-of-a-slap-update&day=02&month=04&year=2006

  1. From engrowe.com
    High five to mysqlslap
    I installed MySQL 5.1.7 beta on my PowerBook G4 1.67GHz, and I ran mysqlslap to get an idea of the performance. Command: $ sudo /usr/local/mysql-5.1.7-beta-osx10.3-powerpc/bin/mysqlslap -i 20 -c 20 -u root -p Results: Benchmark Average number...

Comments are disabled