Public bug reported: The default state for innodb_use_native_aio is enabled as per: http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_use_native_aio It was introduced in 5.5.4 I believe, and offers improved performance, and actual asynchronous writes.
However, is seems innodb_use_native_aio is disabled by default in Ubuntu 12.04, and I am unable to enable it. I have this issue on 2 12.04 servers, neither of which seem to meet the requirements for it to be disabled by mysql on startup. It would appear it is enabled by default on Ubuntu 12.10 I initially asked this as a support question, but after looking into it, I think it is a bug. All of the Debian 5.5 packages I looked at list libaio as a dependency. 'ldd mysqld' does not list libaio. http://packages.debian.org/sid/mysql-server-core-5.5 (Wheezy, Jessie and Sid) libaio is additionally not listed as a dependency in the source packages. https://launchpad.net/ubuntu/precise/+source/mysql-5.5 My current package version is for mysql-server is 5.5.31-0ubuntu0.12.04.1 Is it possibly just because the builds are being done on machines which lack libaio? Possibly similar issue with mariadb: https://bugs.launchpad.net/maria/+bug/988204 (Please bear with me if I am incorrectly reporting this as I am unsure as to why this would be, and how this would be handled.) ** Affects: mysql-5.5 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1186692 Title: Missing dependency on libaio, unable to enable innodb_use_native_aio on 12.04, To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1186692/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
