Page 1 of 1
MySQL stops working
Posted: Wed Jan 18, 2017 9:42 pm
by KyleSforza
Hey guys,
I have a 128 MB VPS with ramnode running on Ubuntu 16.04. Even after multiple installations of VestaCP , MySQL database keeps stopping, a server reboot / service reboot fixes it but then it starts again. And I get "Cannot connect to Localhost" error when trying to make any changes / create new database.
PS It worked fine in an earlier install.
Re: MySQL stops working
Posted: Thu Jan 19, 2017 12:31 pm
by demian
innodb_buffer_pool_size default 128M size
add to my.cnf
innodb_buffer_pool_size = 6M
innodb_buffer_pool_chunk_size = 6M
Re: MySQL stops working
Posted: Thu Jan 19, 2017 10:24 pm
by skamasle
128M of ram is nothing to mysql and is nothing if you whant run apache, nginx, php, exim, dovecot etc
Try add swap to your vps, 512M or more, and confiure mysql whit very low limits.
But I think is not posible run all in vps whit 128MB if you whant run PHP/MYSQL scripts like wordpress, drupal, joomla etc
Re: MySQL stops working
Posted: Fri Jan 20, 2017 4:43 am
by demian
skamasle wrote:128M of ram is nothing to mysql and is nothing if you whant run apache, nginx, php, exim, dovecot etc
Try add swap to your vps, 512M or more, and confiure mysql whit very low limits.
But I think is not posible run all in vps whit 128MB if you whant run PHP/MYSQL scripts like wordpress, drupal, joomla etc
use swap is always bad from perfomans
run apache, nginx, php,mysql in 128M is possible, but better 265m. however if sites more the one, your right minimal 512m
Re: MySQL stops working
Posted: Fri Jan 20, 2017 10:22 pm
by skamasle
demian wrote:skamasle wrote:128M of ram is nothing to mysql and is nothing if you whant run apache, nginx, php, exim, dovecot etc
Try add swap to your vps, 512M or more, and confiure mysql whit very low limits.
But I think is not posible run all in vps whit 128MB if you whant run PHP/MYSQL scripts like wordpress, drupal, joomla etc
use swap is always bad from perfomans
run apache, nginx, php,mysql in 128M is possible, but better 265m. however if sites more the one, your right minimal 512m
Of curse swap is bad but depends of mysql, you maybe need it if you whant to do all online.
Its complicated say, but depends of configuration, website hosted, trafic for that website etc 128MB will works fine ( windows XP run fine whit 128MB of ram some times a go xD but some wordpress whit a lot of plugins need more than 512 :D )