I've been doing a lot of prep work for some MySQL benchmarks on an important system that's slated to have a fairly high transaction volume and a lot of records.
However, I loaded the test data and played a round a bit (raw disk
Running an ALTER TABLE command on a table of 60 million rows (60+GB of data) isn't exactly a trivial operation, even if you are doing it on a 12 disk RAID 0+1 array. Twice so far.
I'm used to making cheaper mistakes, at least in terms of time spent waiting for the fix to finish.
Next time around, it'll look more like this:
- create schema
- write data generator
- write benchmarking plan
- write benchmarking code
- load data
- run tests
For some dumb reason, I did #5 just after #2. Then when it came to #3 and #4 I realized "whoops... something is not quite right."
I'll blame too much multi-tasking.
Posted by jzawodn at March 22, 2004 10:15 PM