List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 7 2005 4:08am
Subject:Re: MySQL not using optimum disk throughput.
View as plain text  
In the last episode (May 06), Kevin Burton said:
> We have a few of DBs which aren't using disk IO to optimum capacity.
> 
> They're running at a load of 1.5 or so with a high workload of
> pending queries.
> 
> When I do iostat I'm not noticing much IO :
> 
> Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s  avgrq-sz
> avgqu-sz   await  svctm  %util
> sda        0.00  13.73 128.43 252.94 1027.45 1695.10   513.73    847.55     7.14   
> 90.13  285.00   2.53  96.57
> 
> This is only seeing about 500k -> 1M per second throughput.
>
> When I run bonnie++ on these drives they're showing 20M->40M throughput.
> 
> They're running on a RAID5 disk on XFS.

An OLTP database is not a system that requires throughput.  It requires
lots of random access.  MB/sec doesn't matter a bit. Instead, take a
look at the r/s and w/r columns.  You're doing ~380 IOs/sec, which
sounds like maybe a 3-disk set?  Each disk you add to the set should
give you another 120 or IOs per second.  When you max out the number of
drives in your case, you will realize why drive manufacturers sell 15K
rpm disks: an array of 15k drives will give you double the transaction
rate (250 IO/s instead of 120) of the same number of 7200 rpm drives :)

-- 
	Dan Nelson
	dnelson@stripped
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