List:General Discussion« Previous MessageNext Message »
From:Jon Drukman Date:August 21 2003 7:23am
Subject:Re: RAID or not?
View as plain text  
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: 
> 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-


Thread
RAID or not?Jackson Miller21 Aug
  • Re: RAID or not?Jon Drukman21 Aug
    • Re: RAID or not?Jackson Miller21 Aug
      • RE: RAID or not?Steven) (Lefevre21 Aug
        • Re: RAID or not?David Griffiths21 Aug
        • Re: RAID or not?Per Andreas Buer21 Aug
        • Re: RAID or not?Jon Drukman22 Aug
          • Re: RAID or not?Dan Nelson22 Aug
          • RE: RAID or not?Steven) (Lefevre22 Aug
            • RE: RAID or not?Michael Loftis2 Sep
  • Re: RAID or not?Colbey21 Aug
  • Re: RAID or not?Per Andreas Buer21 Aug
RE: RAID or not?Alec.Cawley22 Aug
  • Re: RAID or not?Jim McAtee23 Aug
    • Re: RAID or not?Michael Loftis2 Sep
RE: RAID or not?Alec.Cawley22 Aug
Re: RAID or not?Alec.Cawley26 Aug