Page 1 of 1
Re: mysql service stopping itself
Posted: Wed Dec 10, 2014 9:26 pm
by imperio
Hi,
show me please result of this commands
Re: mysql service stopping itself
Posted: Thu Dec 18, 2014 12:51 pm
by balboni
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:
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
Posted: Thu Dec 25, 2014 9:35 pm
by Deeryo
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
Re: mysql service stopping itself
Posted: Sat Dec 27, 2014 10:30 pm
by Deeryo
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.
Re: mysql service stopping itself
Posted: Sat Jan 03, 2015 5:33 am
by iamkingsleyf
Same problem here
Re: mysql service stopping itself
Posted: Sat Jan 03, 2015 1:49 pm
by iamkingsleyf
GreenUnicorn wrote:i added swap and hasn't happend since
I have swap but the memory rises to 900mb+ and boom it's down
Re: mysql service stopping itself
Posted: Tue Jan 06, 2015 5:31 pm
by fedekrum
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.