0
votes
2answers
610 views

Why load increase ,ssd iops increase but cpu iowait decrease?

There is a strange thing on my server which has a mysql running on it. The QPS is more than 4000 but TPS is less than 20. The server load is more than 80 and cpu usr is more than 86% but iowait is ...
5
votes
4answers
4k views

High iowait on Amazon EC2 MySQL instance with EBS volume

We have a MySQL server running on an Amazon EC2 c1.medium instance relying on a single EBS volume using the ext3 filesystem for storage. This MySQL server is queried ~500/ps by several applications ...
2
votes
3answers
764 views

MySQL on ubuntu very high IOWAIT

Can anyone advice what is going on with my setup. I have mysql server on ubuntu which periodically produce very high iowait. for long time up to 10-20 minutes. During this time system and database ...
2
votes
0answers
410 views

MySQL INSERT … SELECT renders server unresponsive

Solution: Although I haven't found a proper solution yet I'm at least sure that this is purely a disk I/O problem and has nothing to do with MySQL... I have a MySQL server (5.1.54-1ubuntu4-log) ...
1
vote
2answers
3k views

What iowait values are ok?

I am trying to find the bottleneck of a server running a fairly busy php/mysql site. My first culprit was io but iostat shows that on average iowait consumes only %3.60 of cpu time. here is the ...
0
votes
2answers
776 views

mysqld causing machine to lockup with high iowait

I've inherited a LAMP server running centos, which randomly hangs from time to time despite low web traffic. I've installed Server Density to monitor what's going on, and have found during a hang the ...