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 service stopping itself
Re: mysql service stopping itself
Hi,
show me please result of this commands
show me please result of this commands
Code: Select all
top
free -m
Re: mysql service stopping itself
I have the same issue, my MySQLd stopped several times. I am on a 768 MB Vultr VPS (KVM, Centos) running a small WooCommerce site.
When I try to restart MySQL I receive an error. I have to restart my whole server to get it working again.
Free -m results:
EDIT: I opened my own thread viewtopic.php?f=10&t=6597
When I try to restart MySQL I receive an error. I have to restart my whole server to get it working again.
Free -m results:
Code: Select all
total used free shared buffers cached
Mem: 742 666 76 0 23 76
-/+ buffers/cache: 566 175
Swap: 0 0 0
Re: mysql service stopping itself
If server has no swap space it can be created like this http://www.cyberciti.biz/faq/linux-add- ... ile-howto/
You can adjust innodb pool memory in /etc/my.cnf with innodb_buffer_pool_size=64M, default value is 128M.
Mysql tables can be repaired using mysqlcheck --auto-repair -A
You can adjust innodb pool memory in /etc/my.cnf with innodb_buffer_pool_size=64M, default value is 128M.
Mysql tables can be repaired using mysqlcheck --auto-repair -A
Re: mysql service stopping itself
You can search dmesg or /var/log/messages for 'killed process' (grep -i 'killed process' /var/log/messages).
Please run command free -m and find numbers next to "Mem:" (total memory) and numbers next to "cache:" (used memory). Used memory shuld be 50% or less. Also check memory graph in vestacp.
Mysql tables can be MyIsam or Innodb. InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory.
mysqlcheck is needed afrer every mysql service crash, unclean poweroff or server reset. You can configure my.cnf option "myisam-recover=FORCE,BACKUP", this allows automatic MyIsam recover. Automatic myisam-recover can almost replace mysqlcheck.
Please run command free -m and find numbers next to "Mem:" (total memory) and numbers next to "cache:" (used memory). Used memory shuld be 50% or less. Also check memory graph in vestacp.
Mysql tables can be MyIsam or Innodb. InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory.
mysqlcheck is needed afrer every mysql service crash, unclean poweroff or server reset. You can configure my.cnf option "myisam-recover=FORCE,BACKUP", this allows automatic MyIsam recover. Automatic myisam-recover can almost replace mysqlcheck.
-
- Posts: 30
- Joined: Sun Nov 23, 2014 4:41 am
Re: mysql service stopping itself
Same problem here
-
- Posts: 30
- Joined: Sun Nov 23, 2014 4:41 am
Re: mysql service stopping itself
I have swap but the memory rises to 900mb+ and boom it's downGreenUnicorn wrote:i added swap and hasn't happend since
Re: mysql service stopping itself
Had the same issue before and here is an old post that with the solution I have found to solve the problem.
viewtopic.php?f=10&t=5222
Pleace comment on that post if you find it works for you.
viewtopic.php?f=10&t=5222
Pleace comment on that post if you find it works for you.