MYSQL making server unusable

Hello

MySQL is running and using all my the CPU, due to which my server is becoming slow or unusable. When I connect via Terminal (that takes ages) and enter “top” to see the processes that are using up the CPU. As far as I can see MySQL is using over 100% of the CPU, i.e. even after using all the power, there are processes that are still waiting in line.

Exmple:
1928 mysql 20 0 1282724 485656 12708 S 181,8 2,0 27:35.71 mysqld

This is not the first time happens and is driving me and my clients crazy. My server provider has requested me to contact here for help

Thanks

top - 13:22:44 up 19 min, 1 user, load average: 103,17, 93,27, 60,25
Tasks: 360 total, 81 running, 279 sleeping, 0 stopped, 0 zombie
%Cpu(s): 16,9 us, 15,0 sy, 66,9 ni, 0,0 id, 0,0 wa, 0,0 hi, 1,2 si, 0,0 st
KiB Mem : 24522444 total, 15544928 free, 6107552 used, 2869964 buff/cache
KiB Swap: 0 total, 0 free, 0 used. 17181948 avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1946 mysql 20 0 1163928 452992 12432 S 119,7 1,8 18:37.80 mysqld
4456 naturqu 21 1 598684 128876 25772 R 8,0 0,5 0:30.99 lsphp
5603 indiart 21 1 540928 65684 20132 R 7,4 0,3 0:13.44 lsphp
5884 escenar 21 1 431748 55372 23616 R 7,4 0,2 0:07.16 lsphp
6162 naturqu 21 1 447660 52972 17728 R 7,4 0,2 0:02.45 lsphp
4891 indiart 21 1 546108 71028 20220 R 7,2 0,3 0:28.28 lsphp
5598 publidi 21 1 473872 94572 22208 R 7,1 0,4 0:13.84 lsphp
5904 ovehumc 21 1 453200 72048 18456 R 7,1 0,3 0:07.56 lsphp
5935 equitem 21 1 463916 83084 20920 R 7,1 0,3 0:07.42 lsphp
5996 cyberpa+ 21 1 214264 54892 4240 R 7,1 0,2 0:07.00 lswsgi
5160 indiart 21 1 543748 69020 20288 R 6,9 0,3 0:22.55 lsphp
5308 ovehumc 21 1 566516 113708 22588 R 6,9 0,5 0:20.58 lsphp
2524 muchome 21 1 533388 54180 23648 R 6,7 0,2 0:38.45 lsphp
5159 indiart 21 1 545608 70532 20536 R 6,7 0,3 0:22.24 lsphp
6028 muchome 21 1 391032 17176 3696 R 6,7 0,1 0:03.81 lsphp
6225 cyberpa+ 21 1 162344 31380 1760 R 6,7 0,1 0:00.36 lswsgi
2859 root 20 0 85400 5556 4036 R 6,5 0,0 2:15.10 auth

usr/sbin/mysql

I deactivated a website that was using a lot also

plenty of space 120 gigas

and thank. you will go one by one, how can i disble per site mysql? or just suspend website in cyberpanle. Thanks again

You can change their user password or just suspend the website.

Also, to make it easy, login to mysql as root and run query SHOW PROCESSLIST;

You should be able to find user hogging the cpu.

Thansk to you guys, I manage to find them
I. have been doing many things as now is in between 2.6 - 5.9

still issue continues even spamchild gets overloaded, liteserver pone soemtngo overloads, etc ertc etc. Is driving me and my clientes crazy (already lost one) becose sometimes goes well soemtims goes crazy