Ubuntu
mysql-5.5 package

Unable to enable innodb_use_native_aio on 12.04

Asked by Ryan Solomon

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

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

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? Is there any particular reason for this being disabled which I have missed?

Possibly similar issue with mariadb:
https://bugs.launchpad.net/maria/+bug/988204

I have not reported it as a bug, as I am unsure whether it is actually a bug.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu mysql-5.5 Edit question
Assignee:
No assignee Edit question
Solved by:
Ryan Solomon
Solved:
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#1

http://forums.mysql.com/read.php?22,400221,400221

Revision history for this message
Ryan Solomon (phizes) said : 		#2

I have seen that forum thread, and I am well aware I can compile from source myself, but this is not my question.

My questions are:
Is it possibly just because the builds are being done on machines which lack libaio? Is there any particular reason for this being disabled which I have missed?

I am asking whether it is by design, or an oversight in the build process or such, in which case I would consider it a bug. (Though it may not be able to be addressed in a stable release.)

Revision history for this message
Ryan Solomon (phizes) said : 		#3

I have been using the following PPA:
https://launchpad.net/~ondrej/+archive/mysql-5.5

Which is (mostly) the same version as in the Ubuntu repositories, except it can run with innodb_use_native_aio.

I also use the following pin:
# cat /etc/apt/preferences.d/ondrej-mysql-5_5-pin-700
Package: *
Pin: release o=LP-PPA-ondrej-mysql-5.5
Pin-Priority: 700