Edit the option file (my.cnf) to ignore the builtin
InnoDB, and load the InnoDB Plugin and all Information
Schema tables implemented in the InnoDB Plugin when the
server starts:
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
Note that all plugins for plugin-load
should be on the same line in the option file.
Alternatively, you can use the equivalent options on the
MySQL command line:
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
You can also install the InnoDB Plugin and the new
InnoDB Information Schema tables implemented in
ha_innodb_plugin.so with
INSTALL commands:
INSTALL PLUGIN INNODB SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_TRX SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_LOCKS SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_LOCK_WAITS SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_CMP SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_CMP_RESET SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_CMPMEM SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_CMPMEM_RESET SONAME 'ha_innodb_plugin.so';
If you use INSTALL PLUGIN statement to
install the InnoDB Plugin and the Information Schema
tables, ensure the following conditions are set up:
In the mysqld command line or
my.cnf option file, prepend each
InnoDB option with loose_, so that
MySQL will start even when InnoDB is unavailable.
For example, write
loose_innodb_file_per_table instead of
innodb_file_per_table.
Start the MySQL server while it is configured to skip
loading the built-in InnoDB and to make MyISAM the
default storage engine. This can be done by editing the
option file my.cnf to contain these
two lines:
ignore_builtin_innodb
default_storage_engine=MyISAM
Or, you can use the equivalent options on the MySQL
command line:
mysqld --ignore-builtin-innodb --default-storage-engine=MyISAM …
See the MySQL Manual section on
INSTALL
PLUGIN Syntax for information on how these
commands work.