CrownCloud Wiki

CrownCloud - Internet Services

User Tools

Site Tools


Fixing mySQL failing to start errors

From time to time we may encounter odd issues with mySQL failing to start, usually these errors are easy to fix, we have listed some of the errors and howto fix them below.

InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.

This is one of the errors that you may encounter on a Debian 7 / Ubuntu based machine, although it's pretty rare to run into one of these but you might just encounter it, fixing this error requires 2 steps, firstly disabling, Linux Native AIO and then disabling InnoDB as well,

from the error log you may notice the following line,

InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf

This is the first line of the fix, edit your my.cnf file if on Debian/Ubuntu,

nano /etc/mysql/my.cnf

if on CentOS,

nano /etc/my.cnf

and then add the following line to your my.cnf file,

innodb_use_native_aio = 0

now save the file and try re-staring mySQL,

/etc/init.d/mysql restart

if it works, then all good :) else you'll need the add the following lines as well, under the [mysqld] section in the same file (/etc/mysql/my.cnf)

key_buffer = 8M
query_cache_size = 0
character-set-server = utf8
default_storage_engine = MyISAM

now save the file and try re-staring mySQL,

/etc/init.d/mysql restart
fixing_mysql_failing_to_start_errors.txt · Last modified: 2014/02/07 12:17 by speedbus