Getting error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed" when starting MySQL

Question

I found many similar question on Stackoverflow but didn't get the exact error solution. My issue is when starting MySQL service on one of the Dedicated Centos 6.5 machine, I am getting error :

141018 05:13:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 141018  5:13:47 [Warning] Can't create test file /var/lib/mysql/ip-184-168-73-83.lower-test 141018  5:13:47 [Warning] Can't create test file /var/lib/mysql/ip-184-168-73-83.lower-test /usr/libexec/mysqld: Can't create/write to file '/tmp/ibkTWnhE' (Errcode: 28) 141018  5:13:48  InnoDB: Error: unable to create temporary file; errno: 28 141018  5:13:48 [ERROR] Plugin 'InnoDB' init function returned error. 141018  5:13:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 141018  5:13:48 [ERROR] Can't start server : Bind on unix socket: No space left on device 141018  5:13:48 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 141018  5:13:48 [ERROR] Aborting  141018  5:13:48 [Note] /usr/libexec/mysqld: Shutdown complete  141018 05:13:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 

Here are free command status: free -m

             total       used       free     shared    buffers     cached Mem:          3743       3631        111          0       2705         21 -/+ buffers/cache:        905       2838 Swap:         2047          0       2047 

Answer 1

I have the same problems, this my solution:

1. Add more RAM to the server

2. Decrease the value of innodb-buffer-pool size in the config file:

   sudo nano /etc/mysql/my.cnf

   innodb_buffer_pool_size = 10M 

After save /etc/mysql/my.cnf.

Restart mysql service:

sudo service mysql restart  exit