• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

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