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 )
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 )
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.