The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Enable InnoDB Plugin On MySQL 5.5

Discussion in 'Database Discussions' started by NELIX, Apr 5, 2015.

  1. NELIX

    NELIX Registered

    Joined:
    Apr 5, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    Hi Guys,

    Somebody knows how to Enable InnoDB Plugin On MySQL 5.5?

    I've tried this:

    vim /etc/my.cnf

    [mysqld]
    ignore_builtin_innodb
    plugin-load=innodb=ha_innodb_plugin.so
    ;innodb_trx=ha_innodb_plugin.so
    ;innodb_locks=ha_innodb_plugin.so
    ;innodb_lock_waits=ha_innodb_plugin.so
    ;innodb_cmp=ha_innodb_plugin.so
    ;innodb_cmp_reset=ha_innodb_plugin.so
    ;innodb_cmpmem=ha_innodb_plugin.so
    ;innodb_cmpmem_reset=ha_innodb_plugin.so

    after:
    /etc/init.d/mysql restart

    but says that:
    ERROR! MySQL server PID file could not be found!
    Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/hostname.pid)


    And the logs:

    150331 02:41:18 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended
    150331 02:41:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150331 2:41:31 [Note] Plugin 'FEDERATED' is disabled.
    150331 2:41:31 InnoDB: The InnoDB memory heap is disabled

    Somebody help me , please.

    Kind Regards,
     
  2. acenetgeorge

    acenetgeorge Well-Known Member
    PartnerNOC

    Joined:
    Mar 6, 2008
    Messages:
    64
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Southfield, MI
    cPanel Access Level:
    DataCenter Provider
    Which version of MySQL 5.5 are you running? InnoDB is the default engine in MySQL 5.5, and ignore_builtin_innodb was deprecated in 5.5.22.

    Try removing the ignore_builtin_innodb line, as well as the reference to the plugin, and restarting MySQL. Then check the VARIABLES to see if have_innodb is set to YES.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    Yes, as mentioned in the previous post, InnoDB should be enabled by default. However, while enabled, it's not the default storage engine with cPanel due to this entry in the /etc/my.cnf file:

    Code:
    default-storage-engine=MyISAM
    Thank you.
     
Loading...

Share This Page