By Alevsk
Hi, currently I have a simple droplet (5 USD) with debian, a basic webserver with a wordpress with 100 visits per day, for some reason Mysql crash randomly, at the beginning I started the service manually, this was very annoying because my site was offline for several days until I realized wordpress was down, right now I have monit who monitors mysql and restart the service if it crash, I solved partially the problem but I still dont know why mysql keep crashing.
Note: there is no mysql.log in /var/log/mysql/
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
I had the same issue, with a 2GB droplet size. Tried everything and eventually discovered it was an XML-RPC attack (Wordpress related).
Check this article for help: How To Protect WordPress from XML-RPC Attacks on Ubuntu 14.04
I had mysql crashing every 30 minutes exactly. Turns out mysql installs on Windows still default the flush_time to 1800 seconds (on nix boxes this value defaults to 0). Normally this is not a problem, but because I was using federated tables it was a problem. I guess mysql doesn’t know how to flush federated tables, therefore crash. So I set flush_time = 0 in my.ini and the problem went away.
This bug has been reported here: https://bugs.mysql.com/bug.php?id=47525&thanks=3¬ify=87
Hi,
We are having the same issue here. I find lots of forum posts about the same issue, but no ‘official’ recommendation… just ‘try this’, ‘could be that’, ‘perhaps its…’.
PLEASE is there any procedure to follow in order to know 1) what´s causing the issue and 2) take proper action?
thks for your time.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.