We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
MySQL stops working
-
- Posts: 4
- Joined: Mon Nov 07, 2016 4:23 pm
MySQL stops working
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.
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
innodb_buffer_pool_size default 128M size
add to my.cnf
innodb_buffer_pool_size = 6M
innodb_buffer_pool_chunk_size = 6M
add to my.cnf
innodb_buffer_pool_size = 6M
innodb_buffer_pool_chunk_size = 6M
Re: MySQL stops working
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
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
use swap is always bad from perfomansskamasle 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
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
Of curse swap is bad but depends of mysql, you maybe need it if you whant to do all online.demian wrote:use swap is always bad from perfomansskamasle 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
run apache, nginx, php,mysql in 128M is possible, but better 265m. however if sites more the one, your right minimal 512m
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 )