Warning: The system load average is 10.19

[AhrimanSefid]

Hi
plz help me for fixed Error :

This is an automated message notifying you that the 5 minute load average on your system is 10.19.
This has exceeded the 10 threshold.

One Minute      - 11.6
Five Minutes    - 10.19
Fifteen Minutes - 9.34

top - 21:43:02 up 11:23,  0 users,  load average: 11.60, 10.19, 9.34
Tasks: 256 total,   1 running, 254 sleeping,   0 stopped,   1 zombie
%Cpu(s):  7.6 us,  2.8 sy,  0.0 ni, 88.7 id,  0.9 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem : 32506272 total, 12129436 free,  1928624 used, 18448212 buff/cache
KiB Swap: 16760828 total, 16760828 free,        0 used. 30095204 avail Mem

 PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
2720 mysql     20   0 12.057g 1.236g   7688 S  93.8  4.0 415:10.12 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/da.test.com.err --open-files-limit=65535 --pid-file=da.test.com.pid
   1 root      20   0  193628   6836   3948 S   0.0  0.0   0:07.65 /usr/lib/systemd/systemd --switched-root --system --deserialize 21

 

[wattie]

Login in MySQL using user da_admin. Enter the command:

SHOW PROCESSLIST;

It will give you a clue which user is making aggressive (potentially unindexed selects or lots of insert/update/delete) queries.