Level 65
Erm, sounds like it's run out of HDD space. Check it with this command
df -h
Also, restart MySQL via
sudo service mysql restart
Can see the status via the above command but use status
Oct 11, 2014
5
Level 6
MySQL server stopped working on Forge
Hello!
All of a sudden, my MySQL server has stopped working on my Forge-powered Digital Ocean server.
I get this error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
I've tried restarting it, but I get permission denied -- does anyone know where I can find the password for the forge user?
Also, when I tried restarting, I got this error (in addition to permission denied): ERROR: The partition with /var/lib/mysql is too full!
What can I do to fix this? It has of course brought my site down for now.
Level 6
Thanks for the help. Fixed it by logging in to the Digital Ocean panel and restarting the server.
Level 4
Resurrecting this but it's just happend to me mysql fell over and i wasn't able to connect, @bashy it's not HDD space on my server do you think it's possible that its the Ram size of the server? I'm running a 512mb atm?
I was able to restart mysql but not comfortable with it falling over like that. Thanks!
Level 4
From Taylor via Forge support: "Yes a 512mb will have numerous problems. Especially with MySQL 5.7. MariaDB might fare better on that small of a server."
Hope this helps anyone else in the furture...
Level 47
The minimum suggested requirement for MySQL 5.7 is 1gb of ram. So if it's running a web server to it is suggested higher. 512mb just won't cut it imo and $10 a month is still cheap considering most shared hosting is average of $9 a month.
Please or to participate in this conversation.