mysql high memory usage and domains fails with: Service Temporarily Unavailable

Refers to:

  • Plesk 12.5 for Linux

Created:

2016-11-16 12:42:57 UTC

Modified:

2016-12-21 19:02:39 UTC

0

Was this article helpful?


Have more questions?

Submit a request

mysql high memory usage and domains fails with: Service Temporarily Unavailable

Symptoms

The website is not working correctly and giving the below error:

Service Temporarily Unavailable

The following errors appear in /var/log/mysqld.log :

[Warning] 'user' entry 'greenfor_3@example.com' ignored in --skip-name-resolve mode.
[Warning] 'user' entry 'greenfor_wc1@example.com' ignored in --skip-name-resolve mode.

top command shows mysqld service consuming all CPU time:

 8388604k total,   188204k used,  8200400k free, 10715096k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
12353 mysql 20 0 15.6g 3.4g 5564 S 106.1 10.8 5953:36 mysqld
12054 root 20 0 366m 91m 8352 S 10.3 0.3 11:07.82 php

Cause

MySQL server is configured to perform reverse DNS lookup of clients. In this case, the server uses only IP addresses and not host names to match connecting hosts to rows in the MySQL grant tables.

Resolution

  1. Comment out the following parameter to /etc/my.cnf :

    [mysqld]
    skip-name-resolve
  2. Restarted the service:

    # service mysqld restart
Have more questions? Submit a request
Please sign in to leave a comment.