current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
up vote 0 down vote favorite

It is a little hard to explain but I have a WordPress site which runs really fast but every so many hours it is causing a large spike in system cpy utilization. User cpu is way down.

Centos 6.5

When I run htop I get an out put of mysql user

13.8G virt (red)

Also

open file limit Error

I have already increased it from 10000 to 100000. The 16 cores are red which in htop should indicate kernel processes.

Where should I be looking to fix this issue. I know I have a little less to show you but tell me what you need and how to get it and I will show it.

It seems that mysql is cause here, but I have no idea what could be the problem. On the other hand if I restart mysql the load is gone and it run well for a while.

share

migration rejected from superuser.com Nov 15 '14 at 19:32

This question came from our site for computer enthusiasts and power users. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Stephen Ostermiller♦ Nov 15 '14 at 19:32

  • This question does not appear to be about webmastering within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
    
Did you check the output of the free command when the problem is there? Getting new processes fast like that means using memory rapidly to create new processes. You may want to institute ulimit on both open files and child processes during logon, then reboot so all processes(except root) have the limit. When user processes barf on limits you can find the culprit. – jim mcnamara Nov 13 '14 at 0:37
    
Yeah i have and it shows that it is mysql which is causing it, at least that is how it looks like. But the problem is that i can't see what mysql is doing at that point which makes the server consume so much cpu. – user1212270 Nov 13 '14 at 9:46
    
Questions about system administration are better suited for serverfault.com – Stephen Ostermiller♦ Nov 15 '14 at 19:32