Hi,
Check your slow queries first. Large full scans can cause unwanted disk
io. Do you use MyISAM or InnoDB? From your status, you seem to have
intensive MyISAM locking.
Peter
On 09/21/2010 04:10 PM, Johan De Meersman wrote:
> Also, mailing list doesn't want to distribute attachments :-) Here's a link
> to the metrics view I was on about earlier:
> http://www.tuxera.be/mysqlstats.zip
>
> On Tue, Sep 21, 2010 at 4:08 PM, Johan De Meersman<vegivamp@stripped>wrote:
>
>>
>>
>> On Tue, Sep 21, 2010 at 4:03 PM,<a.smith@stripped> wrote:
>>
>>> Quoting Johan De Meersman<vegivamp@stripped>:
>>>
>>>> Your raid controller is "lying" to you - you can't have RAID10 with just
>>>> two
>>>> disks :-p Don't worry about that, though - it's a good enough config.
>>>>
>>>
>>> Good enough? If he is genuinely saturating the disk with IO (as he states
>>> the problem is IO) then it isnt good enough. But perhaps that needs a bit
>>> more analysis before we really know...
>>
>>
>> It takes quite some doing to fill a 15krpm RAID-1 with IO, all the way
>> through all the controller, OS and SQL caches. A lot more investigating is
>> needed before concluding that the symptom is indeed the cause.
>>
>>
>>
>> --
>> Bier met grenadyn
>> Is als mosterd by den wyn
>> Sy die't drinkt, is eene kwezel
>> Hy die't drinkt, is ras een ezel
>>
>
>
>
