Enable InnoDB Plugin On MySQL 5.5

NELIX

• April 05, 2015 02:34

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

  • April 06, 2015 20:26

  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.

  0
• 

  cPanelMichael

  • April 09, 2015 15:17

  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.

  0

Please sign in to leave a comment.