No memory available / Mysql crash

[j Zim]

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

 

[Nataliya Zagr]

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