InnoDB Plugin - のんびりSE備忘録 @ ウィキ

• RPMバンドル状況

RHEL4版のRPMにはバンドルされていない（RHEL5は有）
確認方法

$ rpm -qlp MySQL-server-advanced-gpl-5.1.47-1.rhel5.x86_64.rpm | grep -i innodb_plugin
warning: MySQL-server-advanced-gpl-5.1.47-1.rhel5.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
/usr/lib64/mysql/plugin/ha_innodb_plugin.so
/usr/lib64/mysql/plugin/ha_innodb_plugin.so.0
/usr/lib64/mysql/plugin/ha_innodb_plugin.so.0.0.0

• InnoDB Plugin 使用方法

# tar xvfz mysql-advanced-gpl-5.1.45-linux-x86_64-glibc23.tar.gz
# mkdir /usr/local/mysql
# chmod 755 /usr/local/mysql
# mv mysql-advanced-gpl-5.1.45-linux-x86_64-glibc23/* /usr/local/mysql/

• my.cnfの編集

# vi /usr/local/mysql/my.cnf
ignore-builtin-innodb
 plugin-load=innodb=ha_innodb_plugin.so;
 innodb_trx=ha_innodb_plugin.so;
 innodb_locks=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

# vi /etc/init.d/mysql
45行目を修正
basedir=/usr/local/mysql

# /etc/init.d/mysql start
# mysql
mysql> show plugin;
+---------------------+----------+--------------------+---------------------+---------+
| Name                | Status   | Type               | Library             | License |
+---------------------+----------+--------------------+---------------------+---------+
| binlog              | ACTIVE   | STORAGE ENGINE     | NULL                | GPL     |
| partition           | ACTIVE   | STORAGE ENGINE     | NULL                | GPL     |
| ARCHIVE             | ACTIVE   | STORAGE ENGINE     | NULL                | GPL     |
| BLACKHOLE           | ACTIVE   | STORAGE ENGINE     | NULL                | GPL     |
| CSV                 | ACTIVE   | STORAGE ENGINE     | NULL                | GPL     |
| FEDERATED           | DISABLED | 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_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     |
+---------------------+----------+--------------------+---------------------+---------+
16 rows in set, 1 warning (0.00 sec)