The following applies if the InnoDB Plugin was installed as a
dynamic library with the INSTALL PLUGIN
command, as described in Section 9.3, “Installing the Precompiled InnoDB Plugin as a Shared Library”.
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 Plugin:
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 Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).