MySQL DBA - Tips and Techniques Magazine

13 Nov 2014

Install InnoDB Plugin for mysql 5.1

You can read about it here.  "

 

  • The InnoDB Plugin offers new features, improved performance and scalability, enhanced reliability and new capabilities for flexibility and ease of use. Among the features of the InnoDB Plugin are "Fast index creation," table and index compression, file format management, new INFORMATION_SCHEMA tables, capacity tuning, multiple background I/O threads, and group commit.

For information about these features, see InnoDB Plugin 1.0 for MySQL 5.1 User's Guide.

 

 

 

To install innodb plugin on 5.1

 

 

1. Check what current state is

 

mysql> show plugins;

+------------+----------+----------------+---------+---------+

| 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     |

| InnoDB     | ACTIVE   | STORAGE ENGINE | NULL    | GPL     |

| MyISAM     | ACTIVE   | STORAGE ENGINE | NULL    | GPL     |

| MRG_MYISAM | ACTIVE   | STORAGE ENGINE | NULL    | GPL     |

+------------+----------+----------------+---------+---------+

 

You can see by default the builtin innoDB plugin is installed.  To use new features need to install the innoDB plugin as follows.

 

 

2. change mycnf to disable the default builtin innodb and to activate the plugin

 

 

cp $MYCNF/my.cnf $MYCNF/my.cnf.20100629

vi $MYCNF/my.cnf

 

...insert after innodb_open_files = 1000

 

 

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

 

 

3.restart the database

 

../mysql-scripts/

 

 

4. Check

 

 

mysql> show plugins;

+---------------------+----------+--------------------+---------------------+---------+

| 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_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     |

+---------------------+----------+--------------------+---------------------+---------+

 

No comments:

Post a comment