D.O. 1xCPU - 2 GB Memory / 25 GB Disk
|OS type and version:| Ubuntu Linux 18.04.6|
|Webmin version:| 1.984 |
MySQL Version: '5.7.36
All working autonomously for months.
Tonight I upgraded to the above webmin version. I restarted the server and noticed that 100%CPU was going on for a long time. I decided to disable Clamd and do another reboot. I worked on an opencart store for about an hour, but it was obvious that something was still wrong. So I did another reboot and this time, MySQL did not start at all.
The full MySQL error message was : DBI connect failed : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
I tried a restart a dozen times in the last 3 hours. Meantime was checking your site and Google for answers. I found out that the folder and socket were missing. After another reboot just now (06:30am), and having not started automatically, I tried starting it again manually and mySQL started (for no apparent reason)!
This never happened to me ever before tonight. I do not know if it is connected to the webmin update -
I have not made any other changes today apart from that.
As I am writing this, CPU is 100% for the past 35 minutes. I will leave it as is for now.
What action should I take?
UPDATE 24/01/22 16:35:
The server is still @ 100% CPU. So I decided to see what is hogging the system.
I stopped mySQL and CPU dropped to 20%~30% range (mostly apache processes in htop).
I stopped apache and CPU dropped to 0%~2% range.
I started mySQL and CPU STAYED at 0%~2% range.
I started apache and CPU went to 100% immediately.
Even so, MySQL responds to my Workbench remote queries just fine.
Apache access log is empty.
[Mon Jan 24 16:51:11.338237 2022] [suexec:notice] [pid 23715] AH01232: suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec)
[Mon Jan 24 16:51:11.370416 2022] [so:warn] [pid 23715] AH01574: module headers_module is already loaded, skipping
[Mon Jan 24 16:51:11.702626 2022] [mpm_prefork:notice] [pid 23729] AH00163: Apache/2.4.29 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.1.1j configured – resuming normal operations
[Mon Jan 24 16:51:11.702675 2022] [core:notice] [pid 23729] AH00094: Command line: ‘/usr/sbin/apache2’
[Mon Jan 24 16:51:30.904094 2022] [mpm_prefork:error] [pid 23729] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
The socket would be missing if it’s not running. Starting MySQL should create the socket, it shouldn’t be there when MySQL is not running.
I assume the mysql service is enabled? That determines whether systemd will start it on boot. Check it with systemctl status mysql (I think mysql is the service name on Ubuntu, but you should confirm that.)
Open new topics for new problems. If it’s an Apache problem, your title makes no sense and most of your post is irrelevant, so I have no idea what’s going on. If MySQL is fine, mark this topic solved and start a new one with details of the Apache problem.