Every 2-3 hours vps hangs with cpu always > 150% --> sometimes over 600%
with the following top stats:
always the usr/sbin/mysqld command.
Pid Owner Priority CPU % Memory % Command
50418 (Trace) (Kill) mysql 0 100+% - 600% 8.90 /usr/sbin/mysqld
at the times cpu > 200%
in the Show MySQL Processes
We dont have more than 6-7 proccesses.
server info:
Total processors: 8
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #2
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #3
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #4
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #5
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #6
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #7
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #8
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Memory Information
[ 0.000000] Memory: 357924K/1048032K available (12293K kernel code, 2225K rwdata, 7712K rodata, 2476K init, 14048K bss, 160656K reserved, 0K cma-reserved)
Current Memory Usage
total used free shared buff/cache available
Mem: 16647148 2666468 8332024 38556 5648656 13745316
Swap: 0 0 0
Total: 16647148 2666468 8332024
with the following top stats:
always the usr/sbin/mysqld command.
Pid Owner Priority CPU % Memory % Command
50418 (Trace) (Kill) mysql 0 100+% - 600% 8.90 /usr/sbin/mysqld
at the times cpu > 200%
in the Show MySQL Processes
We dont have more than 6-7 proccesses.
server info:
Total processors: 8
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #2
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #3
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #4
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #5
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #6
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #7
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Processor #8
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) Silver 4114 CPU @ 2.20GHz
Speed
2200.000 MHz
Cache
16384 KB
Memory Information
[ 0.000000] Memory: 357924K/1048032K available (12293K kernel code, 2225K rwdata, 7712K rodata, 2476K init, 14048K bss, 160656K reserved, 0K cma-reserved)
Current Memory Usage
total used free shared buff/cache available
Mem: 16647148 2666468 8332024 38556 5648656 13745316
Swap: 0 0 0
Total: 16647148 2666468 8332024