Configuring the InnoDB Plugin (1.0.4) in MySQL 5.1.38

The InnoDB Plugin (1.0.4) is  pretty straight forward configuration. These instructions are for MySQL 5.1.38.  There is a new release of InnoDB Plugin with the 5.1.41 release. With MySQL you can use the default version of InnoDB or the new Plugin but not both.  If using a non-default configuration make sure and set the plugin_dir variable to point to the ha_innodb_plugin library for your system. 

To use the new plugin set the following parameters in your my.ini or my.cnf file.

Make sure you set the paths right for your setup and the right MySQL release like 5.1.40, etc.  

Setting the InnoDB Plugin on Unix/Linux:

[mysqld]
ignore-builtin-innodb
plugin_dir=/opt/mysql/5.1.38/lib/mysql/plugin
plugin-load=ha_innodb_plugin.so


Setting the InnoDB Plugin on Windows:
[mysqld]
ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.dll
plugin_dir="C:/mysql/5.1.38/lib/plugin"

mysql> SHOW VARIABLES WHERE variable_name like '%plugin%' OR  variable_name like '%builtin%';

Variable_name	Value
ignore_builtin_innodb	ON
plugin_dir	C:/mysql/5.1.38/lib/plugin

My initial settings using the InnoDB Plugin on Windows

[mysqld]
basedir="C:/mysql/5.1.38/"
datadir="C:/mysql/Data/"

#*** INNODB Specific options ***
ignore-builtin-innodb
plugin_dir="C:/opt/mysql/5.1.38/lib/plugin"
plugin-load=innodb=ha_innodb_plugin.dll


default-storage-engine=INNODB
innodb_data_home_dir="C:/mysql/innodb"
innodb_data_file_path=ibdata1:1G;ibdata2:1G:autoextend
innodb_autoextend_increment=100
innodb_log_group_home_dir="C:/mysql/innologs"

innodb_buffer_pool_size=120M
innodb_log_file_size=100M