得到错误“将'InnoDB'插件注册为存储引擎失败"；启动MySQL时 [英] Getting error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed" when starting MySQL

问题描述

我在Stackoverflow上发现了许多类似的问题，但没有得到确切的错误解决方案. 我的问题是在一台专用Centos 6.5机器上启动MySQL服务时，出现错误:

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

以下是自由命令状态: 免费-m

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

推荐答案

我有相同的问题，这是我的解决方案:

I have the same problems, this my solution:

1. 向服务器添加更多RAM

1. Add more RAM to the server

减小配置文件中的innodb-buffer-pool size的值 /etc/mysql/my.cnf:

Decrease the value of innodb-buffer-pool size in the config file /etc/mysql/my.cnf:

innodb_buffer_pool_size = 10M

保存my.cnf后，重新启动mysql服务.

After save my.cnf, restart mysql service.

这篇关于得到错误“将'InnoDB'插件注册为存储引擎失败"；启动MySQL时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！