All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
[OVH VPS] MySQL installation gets killed constantly
Logs are here: https://gist.github.com/lifehome/007de36255703db6eff1ad6a3879149e
This is what happened on my Singapore OVH VPS:
1) Reinstalled VPS using ArchLinux template
2) Install Percona-Server (MySQL server, percona branded, tried others but same result)
3) sudo systemctl start mysqld
4) MySQL server will never get alive.
(PS Tried to add a 4G swap but still no luck)
Could anyone give a little hint on what exactly happened here? Except hosting a DokuWiki which doesn't require MySQL, I can't really get use of the VPS as a web server..
Note: I have filed a ticket to them, and OVH said they can migrate me to another hypervisor. I wonder if this relates to the hypervisor?
EDIT: Got to say that before reinstalling my VPS, all services(nginx + php-fpm + Percona-Server) runes fine, I can restart as needed without crashing or get killed.
Comments
How much RAM do you have there? From the error log it seems like just 1 GB. And your MySQL tries to consume 870MB of it. Since you probably have other stuff running, this fails. Not sure why swap doesn't help, but in any case operating like this while using swap heavily is not a good long-term setup. Reconfigure your MySQL for to lower its RAM requirements.
kernel: Out of memory: Kill process 493 (mysqld) score 975 or sacrifice childThis is pretty self explanatory.
I believe the real question the OP is asking here is why adding a swap doesn't help this situation?
@lifehome - The answer is simple: you need more RAM. This is one of those situations where bigger (more) is better.
tuning-primer.sh
Or, for the lazy, add more RAM.
(I've ran mySQL/Apache on 1GB RAM for years, until cPanel bloatware pushed up the bar)
I would say it needs more RAM, but I could be wrong!
OVH's smallest vps is 2gb. How is a 1gb one happening here?
It's the APAC special: https://www.lowendtalk.com/discussion/147089/price-drop-vps-ssd-from-2-50-recurring-sydney-or-singapore-hosted-ddos-protected-ovh-com
Just wondering:
Shouldn't the value for "Free swap" be higher?
4194300kB = a little over ~4.1gb swap. thats a relatively large amount
Indeed. But why is the free swap at 0kB?