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 …

In anticipation of getting my sunfire , and doing some real benchamrks with it, I thought I’d do a quick, test to see if I can still do them..kind of like a warm up excerise before you do a 1500m swim.

So I grabbed 2 idle machines I have access too, and see how mysql 5.1 performed on both.

I took Brian’s mysqlslap tool and gave it a little whirl.

the 3 boxes I had in my aresenal are

• dual x86-64 @2.4G with 8G of ram

a

• 280R with 2 Ultrasparc III+ processors and 4G of ram.

and my new macbook

• a Intel Dual processor shiny thing

now in their time, both of these boxes were considered pretty sweet. (the 280R was purchased in 2002 I think, and for financial people just nearing the end of it’s lifecycle so you will still …

I got a "Sun T2000":http://www.sun.com/servers/coolthreads/t2000/ server from their "test drive":http://www.sun.com/emrkt/trycoolthreads/index.html program a few days ago. I didn't have the right serial adapter to get to the console port at home and my 30 minutes of trying to stitch together the right cable didn't work out, so I am taking it down to the perl.org rack instead of playing with it at home.

I took a few pictures and uploaded them to flickr.

I don't know if we get to keep it, but if we do then it's probably going to be in that rack anyway, so... (crossed fingers - if you work for Sun please put in a good word for me with your marketing department :-) )

When we get it up we'll try setting it up as a perl5 and parrot smoke test server. With the Solaris zones we might be able to have it safely run tests of everything …

I got a "Sun T2000":http://www.sun.com/servers/coolthreads/t2000/ server from their "test drive":http://www.sun.com/emrkt/trycoolthreads/index.html program a few days ago. I didn't have the right serial adapter to get to the console port at home and my 30 minutes of trying to stitch together the right cable didn't work out, so I am taking it down to the perl.org rack instead of playing with it at home.

I took a few pictures and uploaded them to flickr.

I don't know if we get to keep it, but if we do then it's probably going to be in that rack anyway, so... (crossed fingers - if you work for Sun please put in a good word for me with your marketing department :-) )

When we get it up we'll try setting it up as a perl5 and parrot smoke test server. With the Solaris zones we might be able to have it safely run tests of everything …