11.3.3. Uninstalling a Dynamic Library

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.


User Comments
Sign Up Login You must be logged in to post a comment.