title: mysql process constantly overload
body: <p>i properly asking a question that do not have an answer, but i am out of resources and have to try any mean that possible to have a way to solve this problem. first off. i ain't programmer, i just an online store staff that assign to deal with the server and stuff like that. i have basic knowledge to cpanel, whm, but no experience in programming.</p>
  
  <p>we see our server is very very slow recently, i go in whm and see the cpu usage constantly stay like 200% up to 2000% (yes, 2000%) from time to time, then i looked into the process manager and see one particular line that border me:</p>
  
  <p>pid991 - this use like at least 100% of the cpu most of the time i look and the command is</p>
  
  <pre><code>/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/www.(domain).com.err --pid-file=/var/lib/mysql/www.(domain).com.pid
  </code></pre>
  
  <p>and if i go into trace, i see this code repeat again and again</p>
  
  <pre><code>&gt;fcntl(12, F_GETFL)                      = 0x2 (flags O_RDWR)
  &gt;fcntl(12, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
  &gt;accept(12, {sa_family=AF_FILE, NULL}, [2]) = 95
  &gt;fcntl(12, F_SETFL, O_RDWR)              = 0
  &gt;getsockname(95, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, [28]) = 0
  &gt;gettimeofday({1380692546, 638961}, NULL) = 0
  &gt;fcntl(95, F_SETFL, O_RDONLY)            = 0
  &gt;fcntl(95, F_GETFL)                      = 0x2 (flags O_RDWR)
  &gt;setsockopt(95, SOL_SOCKET, SO_RCVTIMEO, "\36\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
  &gt;setsockopt(95, SOL_SOCKET, SO_SNDTIMEO, "&lt;\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
  &gt;fcntl(95, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
  &gt;setsockopt(95, SOL_IP, IP_TOS, [8], 4)  = -1 EOPNOTSUPP (Operation not supported)
  &gt;gettimeofday({1380692546, 641571}, NULL) = 0
  &gt;clone(child_stack=0x7ff0ead58ff0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x7ff0ead599d0, tls=0x7ff0ead59700, child_tidptr=0x7ff0ead599d0) = 6590
  &gt;poll([{fd=10, events=POLLIN}, {fd=12, events=POLLIN}], 2, -1) = 1 ([{fd=12, revents=POLLIN}])
  </code></pre>
  
  <p>with only difference in the number string and may be some ids. i actually have a programmer here, but he is a freelancer and keep tell us he doesn't know what happen, so...</p>
  
  <ol>
  <li>can we know what this is doing with only these repeat lines of ode?</li>
  <li>there is a kill button in process manager, is it safe to simply kill the process?</li>
  </ol>
  
  <p>thank you for your help!</p>