Diamond Notes

As I blogged about recently I was going to have a chance to do some testing.  Last week we started benchmarking our two new servers.  I am running a variety of tests on them and I will begin publishing the results shortly.  This has been the first time I have seriously used the query processing programs for testing.  So far, it has performed fairly well.  Initially, I had intended to use the EVMS (Enterprise Volume Management System) to perform rollbacks of the database files after each test.  However, due to complexity and the overhead that this adds (and we don’t use EVMS in production) I decided to go with a standard setup.  I just wrote a script to stop MySQL, delete the database files, and copy the baseline files from a storage directory.  Then just restarting MySQL and I have a fresh setup.  Yes, it takes longer, but I script the entire run anyways so a little extra time is no big deal.

I guess due to learning a few things during my SAN testing last year the progress has been much faster this time are.  I should have the first set of test results up in a few days..by the end of the week at the latest.