MYSQL used 100% CPU

Hello. help me please

  1. reboot server
  2. server on.

top
mysql 653% used…
2 active users…

during working hours is the same as, 40-60 users. CPU almost always becomes 100% (monitoring freebpx).

There’s a program called ‘mytop’ that will help you narrow down the problem.

Can You post /etc/my.cfg content?

new information

mysql to do with

JAVA
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1933 asterisk 20 0 5032m 1.3g 14m S 506.7 23.6 1420:04 java
4398 root 20 0 15028 1372 1004 R 100.0 0.0 0:00.09 top

If you are not using iSymphony then turn it off.

Version 2:

service iSymphonyServer stop
chkconfig iSymphonyServer off

Version 3:

service iSymphonyServerV3 stop
chkconfig iSymphonyServerV3 off

[root@sinodip01 asterisk]# iSymphonyServer: unrecognized service
bash: iSymphonyServer:: command not found

i dont have this service

okay, then try for version 3

Version 3:

service iSymphonyServerV3 stop
chkconfig iSymphonyServerV3 off

1 Like

ok. i`am fix it.
Tomorrow I’ll look

You help me/
now i dont have this problem/

Biga thx!

@generald great glad that worked for you, never fun to have 60 people sitting on their hands not taking phone calls.