2006-03-16
my first benchmark for a while
In anticipation of getting my "sunfire":http://sunfirefan.com , 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":http://krow.livejournal.com/ 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 see these for a couple more years as dev boxes and file servers).
the test:
$ mysqlslap -a -c 20 -i 200
Maximum number of seconds to run all queries: 0.003 seconds
vs
Maximum number of seconds to run all queries: 1.621 seconds
and the laptop came in at about 0.012 seconds... not too bad
This is the main reason I got out of doing benchmark's and performance tuning in my previous job.
In 4 years (2-3 lifetimes) the speed increase is about 500 times.
The answer for a lot of questions which used to be "design it better" is now "buy another box"...
I plan on running the same test on my sunfire when it arrives (bit with a lot more attention to detail).
If you are benchmarking a sunfire (in the hopes of getting it for free) feel free to stop by on "sunfirefan.com":http://sunfirefan.com and tell us about your experiences.