szone Please help, I am unable to start mariaDB on aapanel 6.5.1. There was 100% CPU usage and sites were too slow. I had stopped MariaDB and wanted to restart it, but it is not starting. I am on CentOS 7.6.
szone szone Ran this command on SSH: sudo service mysql start It gave following message: Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
szone szone Upon running this command: systemctl status mysqld.service Following errors come up: Nov 22 12:03:28 mail.wwwww.com systemd[1]: Starting LSB: start and stop MariaDB... Nov 22 12:03:29 mail.wwwww.com mysqld[16442]: Starting MariaDB.191122 12:03:29 mysqld_safe Logging to '/www/server/data/mail.wwwww.com.err'. Nov 22 12:03:29 mail.wwwww.com mysqld[16442]: 191122 12:03:29 mysqld_safe Starting mysqld daemon with databases from /www/server/data Nov 22 12:03:29 mail.wwwww.com mysqld[16442]: /etc/rc.d/init.d/mysqld: line 264: kill: (16584) - No such process Nov 22 12:03:29 mail.wwwww.com mysqld[16442]: ERROR! Nov 22 12:03:29 mail.wwwww.com systemd[1]: mysqld.service: control process exited, code=exited status=1 Nov 22 12:03:29 mail.wwwww.com systemd[1]: Failed to start LSB: start and stop MariaDB. Nov 22 12:03:29 mail.wwwww.com systemd[1]: Unit mysqld.service entered failed state. Nov 22 12:03:29 mail.wwwww.com systemd[1]: mysqld.service failed.
szone innodb_log_buffer_size was set at 0.25MB, I have increased it to 2MB and restarted MariaDB. It worked, but CPU usage is at 100% again.
szone szone It seems someone was doing DDOS attack on few of my websites. Just installed the WAF Security Plugin for AAPanel for NGINX and it has started to block few malicious IP(s). Server load is now normal, after those IP(s) were blocked.
szone szone Some a**hole was doing DDOS from this IP [85.254.72.27]. Thanks to NGINX Firewall, it has blocked the attack.