Enable InnoDB Plugin On MySQL 5.5

NELIX

Registered
Apr 5, 2015
3
0
1
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,
 

acenetgeorge

Well-Known Member
PartnerNOC
Mar 6, 2008
68
4
58
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
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.