Jackson Miller wrote:
> I am setting up a dedicated MySQL server with some pretty heavy usage. I am
> not much of a sys admin (mostly a programmer). I have some questions about
> the best drive configuration.
> I have 4 SCSI drives currently.
> I would like to have 1 drive run the OS,
> 1 drive to be the MySQL data directory
> and 1 drive to be InnoDB (possibly raw partition).
> What is the best way for me to configure RAID?
> Here is the kind of load I am talking about:
> Uptime: 1749850 Threads: 44 Questions: 1266402021 Slow queries: 16923
> Opens: 162177 Flush tables: 1 Open tables: 64 Queries per second avg:
if you're mostly running SELECTs then i would recommend a mirrored
my server is in your ballpark:
Uptime: 20689 Threads: 77 Questions: 11493312 Slow queries: 21
Opens: 1892 Flush tables: 1 Open tables: 512 Queries per second avg:
i expect it to average higher after it's been running for more than 24
hrs... unfortunately we had to renumber its IP today so it was rebooted.
it is cranking along great with mirrored 10K SCSI drives. we have tons
more room to grow. don't forget about lots of RAM and a big query
cache. they help a lot. this box actually only has 2G of RAM in it but
it's doing fine.