A good thing right now is SDRAM prices became so affordable. Just be lavish in server RAM upgrade, will get good performance. SSD also became affordable over HDD, and can last better lifetime.
Any way when RAM is cheap can RAMDISK yr SQL data file. CRON image copy to SSD at fixed time intervals, just in case power lost or system hangs. This way prrforman of RAMDISK will be fast.
Yr forum banner msg seemed to say databse trouble last nite. Read-only mode.