Thread: MySQL on ZFS

i have zfs formated disks, size bigger system partition. use have partition mounted mount -t zfs tank/mysql /var/lib/mysql after dist-upgrade mysql service failing start. had move files system partition , leave /var/lib/mysql per normal. ideas?
mysql server log:

121114 22:42:13 [note] plugin 'federated' disabled.
121114 22:42:13 innodb: innodb memory heap disabled
121114 22:42:13 innodb: mutexes , rw_locks use gcc atomic builtins
121114 22:42:13 innodb: compressed tables use zlib 1.2.7
121114 22:42:13 innodb: using linux native aio
121114 22:42:13 innodb: initializing buffer pool, size = 128.0m
121114 22:42:13 innodb: completed initialization of buffer pool
121114 22:42:13 innodb: highest supported file format barracuda.
121114 22:42:13 innodb: operating system error number 22 in file operation.
innodb: error number 22 means 'invalid argument'.
innodb: operating system error numbers described at
innodb: http://dev.mysql.com/doc/refman/5.5/...ror-codes.html
innodb: file name ./ib_logfile0
innodb: file operation call: 'aio write'.
innodb: cannot continue operation.

setting `innodb_use_native_aio` option should resolve error. see ticket:

https://github.com/zfsonlinux/zfs/issues/224

Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [ubuntu] MySQL on ZFS

Ubuntu