0
I have a news site made in wordpress, hosted in a VPS in godaddy, and due to the large amount of accesses, I’m having problems with hosting, the database falls when we have many accesses and materials are inaccessible, giving the following error:
"Error establishing a database Connection"
and when I access the /wp-admin I get the same error.
I tried to access phpmyadmin by Cpanel, but I get the following message:
Mysql server is currently offline.
Error while Connecting to Mysql: (XID qh3rc5) Can’t connect to local Mysql server through socket '/var/lib/mysql/mysql.Sock' (2) Error while Connecting to Mysql: (XID qh3rc5) Can’t connect to local Mysql server through socket '/var/lib/mysql/mysql.Sock' (2) at /usr/local/Cpanel/Cpanel/Mysql.pm line 181.
Yes, as I understood the database fell. My question is: There are settings I can make within WHM or Cpanel that can help me 'free' more memory for php?
I’m currently using the Sitelock together with a CDN of Sitelock itself.
Follow the server settings:
Linux, 3GB RAM, largura de banda de 3 TB/mês e 90gb de disco.
Total processors: 24
Intel Xeon CPU ES-2630L V2 2.40GHz
I’ve seen him peak in RAM when we have 280 simultaneous accesses, but it wasn’t this case.
The bandwidth we use is no more than 600GB per month.
And the disk we don’t even use 10GB
I would very much like to see possible alternatives before I have to hire a dedicated one. And if I only have this option, what accommodation would you recommend me for the dedicated?
This error does not seem to be due to "overuse" of the database. Usually when there is an 'overload' it is shown that it has reached the
max_connectionsor thatmax_user_connectionshas been reached... In these cases Mysql is there, active, but refuses connections. In your case the database is APPARENTLY closed for some reason. There may be another problem for me. Some corrupted, damaged or something table, for this see the Mysql LOG, it contains the reason that it was terminated.. Monitor onTOPoperating time and how often it restarts.– Inkeliz
I’m trying to find the LOG file, I just restarted the server and now is giving peak RAM, 99%
– Hugo Deveza