io-error in mysql.log

[SabineW]

Hi to all!
In my mysqld.log (on a open SUSE 12.2) I found this entries:

140420  9:47:11 InnoDB: Using Linux native AIO
140420  9:47:11  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
140420  9:47:13  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
140420  9:47:13 InnoDB: Warning: Linux Native AIO disabled.

I found a solution here: http://kb.parallels.com/en/116766 and here: http://remotemysqldba.blogspot.de/2012/05/innodb-warning-iosetup.html
But when I try to add this into my sysctl.conf I got this error-message:

sysctl: permission denied on key 'fs.aio-max-nr'

Has anybody maybe an other way to solve this error?

Thank you in advance for help and have a nice day
Sabine

 

[SabineW]

Hi to all,
my mysql-databaseserver is down now and failed to restart. This are the entries of my log:

140425 1:59:29 InnoDB: Using Linux native AIO
140425 1:59:29 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
140425 1:59:32 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
140425 1:59:32 InnoDB: Fatal error: cannot initialize AIO sub-system
140425 1:59:32 [ERROR] Plugin 'InnoDB' init function returned error.
140425 1:59:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140425 1:59:32 [ERROR] Unknown/unsupported storage engine: InnoDB
140425 1:59:32 [ERROR] Aborting

I found a hint to delete logs (http://omarusman.com/blog/tutorials/xampp-innodb-storage-engine-failed-windows8)
but it doesn't solve my problem.
Is nobody here with an idea?