Linux mysql.plugin_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.