0

Please see image attached.

Our font-end websites are running super super slow almost to a point where nothing moves for 15-30 minutes.

  1. is that because of whatever this mysql thing is is causing the high CPU load?
  2. how do I stop it? I tried sending a SIGKILL to it but that doesent work either. I tried restarting apache/mysql too. The process pops up again.

enter image description here

Abdulla Nilam
  • 36,589
  • 17
  • 64
  • 85
IMG Imports Inc.
  • 49
  • 4
  • Check related thread. Maybe will help: http://stackoverflow.com/questions/1282232/mysql-high-cpu-usage?rq=1 – S.I. Oct 27 '16 at 16:34
  • This site is for programming questions. We are not general server tech support. – Marc B Oct 27 '16 at 16:40
  • I did look at that. I dont see any processes. I am looking at the processes in WHM and dont see any process there. If processes show up, they disappear after a second or two which means the process is running pretty fast. – IMG Imports Inc. Oct 27 '16 at 16:41
  • This sounds like a problem with the OS. If so, and if it's on Unix, try http://unix.stackexchange.com/ . – Topological Sort Oct 27 '16 at 20:25
  • I suggest moving this question to serverfault.com, a sister site to stackoverflow. It appears the OP is running the webserver and mysql database on the same server. Typically, you want them to run on different servers. Then there's the question of WHY is `mysqld` eating nearly half the CPU time. The server admins on serverfault should be able to assist better than a bunch of programmers. – Jason D Oct 31 '16 at 05:40
  • improve the performance creating primary keys in your tables, or using views, i've had the same problem and i've solved it doing that. – MindLerp Oct 31 '16 at 14:08

1 Answers1

-1
  1. Thats probably the reason yes. I dont know what your usual usage is but 40% only for the mysql server is alot. Maybe take a look at your logfiles and see if u can find anything there
  2. Do you have shell access to the Server this is running on?

If so try to kill it manually over the console. What system is this service running on? The last resort would be to restart the server...

Nightforce
  • 28
  • 5