安装InnoDB Plugin

对于mysql5.1.38之后的版本，要使用新的InnoDB Plugin存储引擎，只需在my.cnf中做如下配置：

    [mysqld]
    ignore-builtin-innodb
    plugin-load=innodb=ha_innodb_plugin.so
    plugin-load=innodb_trx=ha_innodb_plugin.so
    plugin-load=innodb_locks=ha_innodb_plugin.so
    plugin-load=innodb_cmp=ha_innodb_plugin.so
    plugin-load=innodb_cmp_reset=ha_innodb_plugin.so
    plugin-load=innodb_cmpmem=ha_innodb_plugin.so
    plugin-load=innodb_cmpmem_reset=ha_innodb_plugin.so


或是在命令行下加载

    mysql>install plugin innodb soname ‘ha_innodb_plugin.so’; 
    mysql>install plugin innodb_trx soname ‘ha_innodb_plugin.so’; 
    mysql>install plugin innodb_locks soname ‘ha_innodb_plugin.so’; 
    mysql>install plugin innodb_cmp soname ‘ha_innodb_plugin.so’; 
    mysql>install plugin innodb_cmp_reset soname ‘ha_innodb_plugin.so’; 
    mysql>install plugin innodb_cmpmem soname ‘ha_innodb_plugin.so’; 
    mysql>install plugin innodb_cmpmem_reset soname ‘ha_innodb_plugin.so’; 



要想完成动态加载innodb plugin是有条件的：

1. 使用源码编译的，默认innobase没有被编译进来；使用二进制包安装的，在启动前，在my.cnf里面加入skip-innodb或是ignore_builtin_innodb。

2. 使用源码编译时，不能使用–with-mysqld-ldflags=-all-static选项，以静态方式编译库，当show global variables like ‘have_%’;的时候，输出有一项是have_dynamic_loading将是NO，这就决定mysql是否支持动态加载plugin；而二进制包安装的mysql，就是动态编译的，支持动态加载plugin，这项为Yes。

SHOW ENGINES;
SHOW PLUGINS;

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.00 sec)

mysql> show plugins;
+---------------------+--------+--------------------+---------------------+---------+
| Name                | Status | Type               | Library             | License |
+---------------------+--------+--------------------+---------------------+---------+
| binlog              | ACTIVE | STORAGE ENGINE     | NULL                | GPL     |
| partition           | ACTIVE | STORAGE ENGINE     | NULL                | GPL     |
| BLACKHOLE           | ACTIVE | STORAGE ENGINE     | NULL                | GPL     |
| CSV                 | ACTIVE | STORAGE ENGINE     | NULL                | GPL     |
| MEMORY              | ACTIVE | STORAGE ENGINE     | NULL                | GPL     |
| MyISAM              | ACTIVE | STORAGE ENGINE     | NULL                | GPL     |
| MRG_MYISAM          | ACTIVE | STORAGE ENGINE     | NULL                | GPL     |
| InnoDB              | ACTIVE | STORAGE ENGINE     | ha_innodb_plugin.so | GPL     |
| INNODB_TRX          | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL     |
| INNODB_LOCKS        | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL     |
| INNODB_LOCK_WAITS   | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL     |
| INNODB_CMP          | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL     |
| INNODB_CMP_RESET    | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL     |
| INNODB_CMPMEM       | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL     |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL     |
+---------------------+--------+--------------------+---------------------+---------+
15 rows in set (0.00 sec)