Mysql on ZFS

  • On OMV VM, i have install zfs plugin and i would install mysql.
    Mysql don't want to start.
    I take this error :



    and in syslog


    I go on google and found this : http://www.percona.com/forums/…ory-to-zfs-on-percona-5-5


    It means that the ZFS implementation you are currently running on that host does not support AIO.


    I add into extra option of mysql config :
    innodb_use_native_aio=0


    I save and mysql start !!!!!


    This is for information.

    • Offizieller Beitrag

    I added a checkbox to disable AIO to the plugin in version 1.0.14 in the repo now.

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.9 | compose 7.0.9 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

  • I test openmediavault-mysql 1.0.14 and :



    There are a little mistake and this is a patch (if disable_aio != 1 then "innodb_use_native_aio=0" but the reverse )


    Diff
    --- mysql       2015-02-26 15:43:16.990875665 +0100
    +++ /usr/share/openmediavault/mkconf/mysql      2015-02-26 15:40:34.995917874 +0100
    @@ -91,7 +91,7 @@
         -i "port != ''" -v "concat('port = ', port)" -n -b \
         -i "bind_address != ''" -v "concat('bind-address = ', bind_address)" -n -b \
         -o "datadir = ${data_directory}" -n \
    -    -i "disable_aio != 1" -o "innodb_use_native_aio=0" -n -b \
    +    -i "disable_aio != 0" -o "innodb_use_native_aio=0" -n -b \
         -i "string-length(extra_options) > 0" -v "extra_options" -n -b \
         ${OMV_CONFIG_FILE} | xmlstarlet unesc > ${OMV_MYSQL_PLUGIN_CONFIG}
    • Offizieller Beitrag

    Oops. Forgot to fix that. Fixed in repo now.

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.9 | compose 7.0.9 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!