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<vegiv...@tuxera.be>wrote:
On Tue, Sep 21, 2010 at 4:03 PM,<a.sm...@ukgrid.net> wrote:
Quoting Johan De Meersman<vegiv...@tuxera.be>:
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
