Results 1 to 3 of 3

Thread: MySQL on ZFS

  1. #1
    Join Date
    Jul 2009
    Beans
    4
    Distro
    Ubuntu 10.10 Maverick Meerkat

    MySQL on ZFS

    I have a ZFS formated disks, the size is much bigger than system partition. I use to have partition mounted with mount -t zfs tank/mysql /var/lib/mysql After dist-upgrade mysql service is failing to start. I had to move files back to the system partition and leave /var/lib/mysql as per normal. Any ideas?
    mysql server log:
    121114 22:42:13 [Note] Plugin 'FEDERATED' is disabled.
    121114 22:42:13 InnoDB: The InnoDB memory heap is disabled
    121114 22:42:13 InnoDB: Mutexes and 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 is Barracuda.
    121114 22:42:13 InnoDB: Operating system error number 22 in a file operation.
    InnoDB: Error number 22 means 'Invalid argument'.
    InnoDB: Some operating system error numbers are 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.

  2. #2
    Join Date
    Sep 2006
    Location
    Dallas, TX, USA
    Beans
    24
    Distro
    Ubuntu 11.04 Natty Narwhal

    Re: MySQL on ZFS

    Setting the `innodb_use_native_aio` option should resolve this error. See this ticket:

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

  3. #3
    Join Date
    Jul 2009
    Beans
    4
    Distro
    Ubuntu 10.10 Maverick Meerkat

    Re: MySQL on ZFS

    Thanks for quick and accurate response. Worked very well. Cheers.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •