[HELP] Benchmark / test new MySQL db server?

MrGuvernment

MrGuvernment

Fully [H]
Joined
Aug 3, 2004
Messages
21,812
can anyone point me in a good direction for some software (free prefered) to benchmark a new server i have to be used for a MySQL, mainly disk performance, i did HDTach already, but i want something that can basically simulate the MySQL DB side of things specifically?
 
i did some simple test select * from and timed it (query browser times it) out vs our other 3servers, what i found REALLY weird is an old dell poweredge dual PIII 1ghz (slot 1) pc133 and a single 74g SCSI 320 drive (80 pin 10k), did a select in 14 seconds, vs a dual xeon and a dual opteron with 10k 146g SCSI drives (68pin) in each took over 30 seconds!! all running server 2003.


now this new system did it in 14 seconds as well with 4 x 500g in Raid 6 dual xeon 2.4 with HT off and 2g of ram.

System.....................time for query.............................MySQL Version
master.....................14.01s.......................................v5.0.45
DB1.........................14.95.........................................v4.0.17
DB2.........................33.88.........................................v4.1.11
DB3.........................29.25.........................................v4.1.12

SPECS of each system:

master (new server)
Dual xeon 2.4 400FSb HT / 2g ram, adaptec 2420SA SATAII raid card / 4 x 500G 7200.10 drives raid 6

DB1
dual PIII 1ghz's / 1.5g pc133 / single 74G SCSI 320 drive 10k RPM

DB2
dual xeon 2.4ghz no HT / 1g ram / 146g 10k SCSI 68pin

DB3
dual opteron 2ghz / 1g ram / 146g 10k SCSI 68 pin


checking out the links, also, thanks.
 
You must log in or register to reply here.
Back
Top