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: 723.720
if you're mostly running SELECTs then i would recommend a mirrored configuration.
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: 555.528
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.
-jsd-
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
