This is normal for php-fpm to consume more process, as you application is using them. But by reading your latest top state, it looks more likely the issue is with mysql. Can you post your my.cnf config here, as it is consuming too much resources and there might be something going on in the background.
If you are logging slow queries then increasing the value or disabling it might help you a lot. As the main bottleneck in high traffic server is database and file I/O, so, if you are using HDD and logging every possible things then you are killing your application. Be reasonable while logging things, or use SSD.
While posting the process usage, the
Well I can just give you suggestions, but it is up to you to follow the best practices that you feel, I feel logging is always a big bottleneck. I have even disabled the nginx access log and just use error log in my production server. I use Piwik to do access analysis, which saves me from file I/O alot, as storing values in database is much more faster than files.
If you are logging slow queries then increasing the value or disabling it might help you a lot. As the main bottleneck in high traffic server is database and file I/O, so, if you are using HDD and logging every possible things then you are killing your application. Be reasonable while logging things, or use SSD.
While posting the process usage, the
top -H
or htop
gives more detailed info.Well I can just give you suggestions, but it is up to you to follow the best practices that you feel, I feel logging is always a big bottleneck. I have even disabled the nginx access log and just use error log in my production server. I use Piwik to do access analysis, which saves me from file I/O alot, as storing values in database is much more faster than files.