mysql service stopping itself

[imperio]

Hi,
show me please result of this commands

Code: Select all

top
free -m

[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

EDIT: I opened my own thread viewtopic.php?f=10&t=6597

[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

[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.

[iamkingsleyf]

Same problem here

[iamkingsleyf]

i added swap and hasn't happend since

I have swap but the memory rises to 900mb+ and boom it's down

[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.