• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

No memory available / Mysql crash

J

j Zim

Guest
Yesterday I got a problem (dozen of entries like wwwrun 30399 0.0 0.3 89720 8252 ? Sl Nov09 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL) on my server (Dell, Suse OES 10.2).

At the same time and suddenly the memory usage + swap was very high and no memory was available anymore.

I restarted the apache server (rcapache restart) to get everything working ok. Unfortunately for me I did not find the source of the problem.

On Suse with Plesk (8.6), Mysql seems to be a very important component and as soon as mysql is not available everything is going down (monitoring http accesses, antispam, email, etc.). When memory level becomes very low, mysql was stopped and cannot be restarted.

What is the most possible situation: the problem (httpd entries and memory) is be caused by the crash of mysql or mysql is crashing because of the memory problem? I tried with no success to isolate the problem.

By the way, does someone know a method to log mysql activities in order to get info about its crash?

Regards,
JZ
 
Hello,

The mysqld.log file is located at the following directory:

# less /var/log/mysqld.log

It can be commented at the mysql configuration file, thus please, check, and enable it if necessary. Find the following string at the /etc/my.cnf:

log=/var/log/mysql/mysql.log

Also check the apache log file for error messages:

# less /var/log/httpd/error_log

Thank you
 
Back
Top