List:General Discussion« Previous MessageNext Message »
From:Atle Veka Date:May 7 2005 7:56pm
Subject:Re: MySQL not using optimum disk throughput.
View as plain text  
On Sat, 7 May 2005, Kevin Burton wrote:

> It looks like you're saying here that a single disk is FASTER than your
> RAID 10 setup.
>
> Correct?
>
> Which is interesting.  I'm wondering if this is a RAID config issue.  It
> just seems to make a LOT more sense that RAID 1 or 10 would be faster
> than a single disk.

I wouldn't say that, those were just examples of setups that we have. They
handle very different queries. :) While the RAID example has less queries
and at times higher disk IO, it handles complex SELECT queries along with
INSERT/UPDATEs; 99% of the queries on the non-RAID setup are simple
UPDATEs.


Atle
-
Flying Crocodile Inc, Unix Systems Administrator

Thread
MySQL not using optimum disk throughput.Kevin Burton6 May
  • Re: MySQL not using optimum disk throughput.Dan Nelson7 May
RE: MySQL not using optimum disk throughput.Dathan Pattishall7 May
  • Re: MySQL not using optimum disk throughput.Greg Whalin7 May
    • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
      • Re: MySQL not using optimum disk throughput.Greg Whalin7 May
        • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
          • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
            • Re: MySQL not using optimum disk throughput.Greg Whalin7 May
              • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
                • Re: MySQL not using optimum disk throughput.Atle Veka7 May
                  • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
                    • Re: MySQL not using optimum disk throughput.Atle Veka7 May
                  • Re: MySQL not using optimum disk throughput.Dan Nelson8 May
              • Re: MySQL not using optimum disk throughput.Peter Zaitsev7 May
                • Re: MySQL not using optimum disk throughput.Greg Whalin7 May
                  • Re: MySQL not using optimum disk throughput.Peter Zaitsev1 Jun
                    • RE: MySQL not using optimum disk throughput.Richard Dale1 Jun
        • Re: MySQL not using optimum disk throughput.Kevin Burton9 May
          • Re: MySQL not using optimum disk throughput.Greg Whalin9 May
            • Re: MySQL not using optimum disk throughput.Kevin Burton9 May
              • Re: MySQL not using optimum disk throughput.Greg Whalin9 May
                • Re: MySQL not using optimum disk throughput.Kevin Burton9 May
Re: MySQL not using optimum disk throughput.John David Duncan7 May
  • Re: MySQL not using optimum disk throughput.Peter Zaitsev7 May