First:
Formatting a drive using RAID 5 is a very big mistake when setting up a MySQL database server.
In case you missed that:
Unless you are running mission-critical banking transactions that can not for any circumstance be lost or else a whole bunch of people are going to die and RAID 5 is the only solution that works, then do not use RAID 5 for any database server where you wish to continue to get a modicum of performance in the long term.
Really. I work on a, shall we say, very high-transaction marketing tracking service which processes over 242 million transactions a month. And when I say “transactions”, I mean hits. And while the hits are not, say, as intense as downloading an image file, it adds up.
Some of it is discarded traffic from inactive sites, or refresh pages, but most of the data ends up being pumped into the database, constantly.
I have considered myself somewhat of a MySQL aficionado up until recently when » Continue reading “RAID 5 and MySQL is NOT recommended”