Over the last several weeks I have been testing out the 2 mtron
drives that easy computing company provided me. In fact I have
been testing like a madman. Nightly I would kick off a batch of
DBT2 tests, sysbench tests, bonnie++, and more. Each test changed
something about the environment I was testing. RAID 1, RAID 0,
with easy’s MFT, without the MFT, with the logs on SSD, With the
logs on a raptor drive, etc. Each test run when it completed
successfully would take roughly 12 hours. a typical example of a
portion of one of these test runs is:
shutdown mysql
remove the data and log files
wait 5 minutes
startup mysql
wait 5 minutes
load a 200 warehouse DBT2 test
wait 5 minutes after the load is complete
run DBT2 test
rinse and repeat.
Minimally I have been doing a 40 active warehouse dbt2 test and a
60 active …
[Read more]