Load values have increased a lot.

[agasar]

Hello

/usr/local/mysql/bin/mysqld --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock

The values increase the most in the upper place. There is excessive mysql usage in the upper place.


"Warning: The system load average is 12.14"

There are a lot of messages coming to DA like above. Why did my load values increase? What can be done for this?

After removing "Modscurity" from the server, the "mysql" values increased.

Should I reinstall it with SSH below? Do I need to reboot the server after installing it with the following operations?

"Modscurity" setup.

cd /usr/local/directadmin/custombuild
./build update
./build set modsecurity yes
./build set modsecurity_ruleset comodo
./build modsecurity
./build modsecurity_rules
./build rewrite_confs

 

[ccto]

You may monitor MySQL / MariaDB activities by the following -

esp for any long running SQL(s)

watch -n 1 "uptime; echo 'show full processlist;' | mysql --defaults-extra-file=/usr/local/directadmin/conf/my.cnf"

--

Also, that means a number of HTTP requests (maybe attacks) are rejected by ModSecurity.
So, with ModSecurity, those HTTP requests are not entertained.

You may check the ModSecurity audit log for details ( /var/log/httpd/modsec_audit.log ).

Or, use the size of Apache error logs, and get the related domain(s), and review those error log(s).

cd /var/log/httpd/domains/
ls -l --sort=size *.error.log | head

 

[agasar]

Hello
I completely removed "ModSecurity" from the server a few days ago. It is not currently installed on the server. It seems like it would be beneficial to reinstall it.

Is it installed with the following commands?


cd /usr/local/directadmin/custombuild
./build update
./build set modsecurity yes
./build set modsecurity_ruleset comodo
./build modsecurity
./build modsecurity_rules
./build rewrite_confs