The following applies if the InnoDB storage engine was installed as a
dynamic library with the INSTALL PLUGIN
command.
Issue the command UNINSTALL PLUGIN
for every
“plugin” supplied by the library
ha_innodb_plugin.so
(or
ha_innodb_plugin.dll
on Windows). Note that
the following commands initiate a shutdown of the
InnoDB storage engine:
SET GLOBAL innodb_fast_shutdown=0; UNINSTALL PLUGIN INNODB; UNINSTALL PLUGIN INNODB_CMP; UNINSTALL PLUGIN INNODB_CMP_RESET; UNINSTALL PLUGIN INNODB_CMPMEM; UNINSTALL PLUGIN INNODB_CMPMEM_RESET; UNINSTALL PLUGIN INNODB_TRX; UNINSTALL PLUGIN INNODB_LOCKS; UNINSTALL PLUGIN INNODB_LOCK_WAITS;
Due to MySQL Bug#33731, please ensure that the plugin definitions are actually deleted from the database, so that they are not loaded again:
SELECT * FROM mysql.plugin;
DELETE FROM mysql.plugin WHERE name='…'
;
Restart the server. For the details of the shutdown procedure, see the MySQL manual on The Shutdown Process.
This is the User’s Guide for InnoDB storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .