All geek questions in one place

Mysql service does not start, InnoDB initialization function error

So, it would seem, out of nowhere today, my Wordpress site went down, and I traced it to problems with mysql. Mysql does not start on the server because it continues to fail.

Here is what I get from the magazines:

140226 08:54:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140226 08:58:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140226 8:58:20 [Note] Plugin 'FEDERATED' is disabled. 140226 8:58:20 InnoDB: The InnoDB memory heap is disabled 140226 8:58:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140226 8:58:20 InnoDB: Compressed tables use zlib 1.2.3 140226 8:58:20 InnoDB: Using Linux native AIO /usr/libexec/mysqld: Can't create/write to file '/dev/shm/mysql/ibOqUOjF' (Errcode: 2) 140226 8:58:20 InnoDB: Error: unable to create temporary file; errno: 2 140226 8:58:20 [ERROR] Plugin 'InnoDB' init function returned error. 140226 8:58:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140226 8:58:20 [ERROR] Unknown/unsupported storage engine: InnoDB 140226 8:58:20 [ERROR] Aborting

I tried Google and looked at Stack Overflow here, but I can’t find many solutions, except to delete the ipdata1 and log files, which, as I read, should not be executed with the saved data, this will ruin my tables.

This is the NGINX CentOS 6 server.

Any ideas? I appreciate the help!

+1
source share
2 answers

AFAIK System error: 2 = There is no such file or directory.

Make sure the directory exists, that mysql has write permission to it, and that there is enough disk space left.

+2
source

Another consideration might be that your tmpdir used for mysql has enough disk space and requires permission.

Also for Windows users : use front slash (/) for back slash (\) for tmpdir path

+1
source

Source: https://habr.com/ru/post/1263029/

More articles:


All Articles