up vote 0 down vote favorite
share [g+] share [fb]

MySQL daemon is always taking 200% - 300% CPU during day time. Normal or bad? ( Website has a concurrent connections 200 about but it's running Drupal without reverse proxy with many many writes operation with MySQL )

link|improve this question
45% accept rate
I don't believe your server can deliver more than 100% cpu-time to any given process. – iHaveacomputer Nov 22 '11 at 23:44
feedback

migrated from webmasters.stackexchange.com Nov 26 '11 at 14:33

This question came from our site for pro webmasters.

1 Answer

up vote 1 down vote accepted

Well this depends on mainly your available CPU and I/O power. If you have a lot of it, then this is no problem.

Instead of just looking at the used CPU, I would suggest to have a look at iowait. This is when processes are waiting for I/O to finish their tasks - e.g. the database waiting for the hard drives to write files on disk.

link|improve this answer
How to check iowait? I used vmstat, it's 7. I don't know if it's high or low – Jusfeel Nov 23 '11 at 7:22
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.