i have hight cpu usage on my server. There is one process (see screen) which is permanently taking 100% cpu. I have 4 sites in bench, but only one of them is used daily by 10 - 15 users. Is this cpu usage normal behaviour?
Now i have 4 core, and 16gb. Swap is used on 100%, and memory at least 10gb. I tried increase innodb_buffer_pool_size to 12G.
it seems that i solved it, by adding:
innodb_buffer_pool_instances = 2
When i was not see this settings in conf. file i did not added it before. It seems that this was problem. My conf now is:
innodb_buffer_pool_size = 2G
innodb_buffer_pool_instances = 2