mysql5.1.x 安装_mysql5.1.X安装plugin-阿里云开发者社区

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.