Enable InnoDB Plugin On MySQL 5.5

[NELIX]

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,

 

[acenetgeorge]

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.

 

[cPanelMichael]

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:

default-storage-engine=MyISAM

Thank you.