iowait 50%+

[AlternativeWeb]

I had someone work on my server to help lower constant swap space being used, but now there a new problem that occurs. The iowait goes as high as 50% even on a minimal amount of queries being executed.

I don't have a clue what he changed on the server, but I was hoping someone here may have an idea how I can lower the iowait time.

 

[Cheetah]

Check the mysql config, He might have reduced the number of concurrent mysql connections.

 

[AlternativeWeb]

I don't even think he changed anything from the my.cnf
Currently the max connection is 200, which should be more then enough.

 

[MobiCow]

Try a tool like iotop to monitor what is using all the io

 

[DLow]

run mysqltunner

 

[Cheetah]

run mysqltunner and check if there is large number of temp tables generated on disk. Also check the number of active concurrent connections.

also run ioping and check if the disk latency is good or not

 

[AlternativeWeb]

i used mysqltunner but didn't help with anything.
i cannot remember were he edited, but it wasn't anything I ever seen before.
not that i'm advanced with linux or anything, but it wasn't anything basic like php.ini nor my.cnf.