innodb Plugin 1.0.4 for mysql安装方法
The general steps for building MySQL from source, containing the InnoDB Plugin in place of the standard built-in InnoDB are as follows:
innodb Plugin 1.0.4 for mysql标准编译安装方法如下:
Download the MySQL source code.
下载MYSQL源码
Download the InnoDB Plugin source code.
下载innodb Plugin 1.0.4 for mysql的对应版本源码
Replace the source code for the built-in InnoDB with the InnoDB Plugin source tree.
将innodb Plugin 1.0.4 for mysql的源码,替换MYSQL中自带的innodb的源码
Compile MySQL as usual, generating a new mysqld executable file.
正常编译MYSQL
% wget ftp://ftp.easynet.be/mysql/Downloads/MySQL-5.1/mysql-5.1.37.tar.gz
% tar -zxf mysql-5.1.37.tar.gz
% cd mysql-5.1.37/storage
% wget http://www.innodb.com/download/innodb_plugin/innodb_plugin-1.0.4.tar.gz
% tar -zxf innodb-1.0.4.tar.gz
% rm -fr innobase
% mv innodb-1.0.4 innobase
% cd ..
% ./configure --with-plugins=innobase
% make
Configure the MySQL server by editing the configuration file to use InnoDB as the default engine (if desired) and set appropriate configuration parameters to enable use of new InnoDB Plugin features.
正常配置MYSQL,以及合适的innodb参数
default_storage_engine=InnoDB
innodb_file_per_table=1
innodb_file_format=barracuda
innodb_strict_mode=1
If you build a version of MySQL that contains the InnoDB Plugin (--with-plugins=innobase), you will not have to tell MySQL to specify ignore_builtin_innodb or specify plugin_load, or issue any INSTALL PLUGIN statements. The mysqld executable that you compiled will contain the new InnoDB Plugin features.
如果原来编译的MYSQL包含innodb插件,你不需要任何说明与配置,只需要按以上步骤重新编译,新版innodb插件就生效了。