Re: Mysql 5.5 High I/O Wait
This will take some digging. Please provide
SHOW VARIABLES;
SHOW GLOBAL STATUS;
How much RAM is available to MySQL? (I assume there is no swapping happening.)
Let's see some of the queries in the slowlog. (Yeah, they may look harmless, but it may still be useful to see what tables they are hitting, etc.)
SHOW CREATE TABLE for the tables involved in the "slow" queries.
I have seen things like this before. But I will need the details to point you in the right direction for _your_ situation.
> innodb-flush-log-at-trx-commit = 1
This adds significantly to the I/O, but it is safer than =2.
What are the clients? Web servers? What is MaxClients (if it is Apache)?
Subject
Written By
Posted
Re: Mysql 5.5 High I/O Wait
May 20, 2014 06:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.