Percona XtraDB Storage Engine安装笔记

XtraDB 是Percona公司开发的一个MySQL 的存储引擎，其设计的主要目的是用以替代现在的InnoDB。XtraDB 100%的兼容 InnoDB。在性能上有很大提高， 评测可看这里http://www.mysqlperformanceblog.com/2009/07/14/performance-improvements-in-percona-5-0-83-and-xtradb/ 。
以下是我安装过程笔记：

1、下载XtraDB
wget -c http://www.percona.com/mysql/xtradb/5.1.37-7/source/MySQL-percona-5.1.37-7.rhel5.src.rpm

2、下载下来是rpm源码包，使用rpm解包
rpm -ivh MySQL-percona-5.1.37-7.rhel5.src.rpm

3、解压源码包
cd /usr/src/redhat/SOURCES
tar -zxvf mysql-5.1.37.tar.gz
tar -zxvf percona-xtradb-1.0.3-7.tar.gz

4、覆盖innobase源码
mv mysql-5.1.37/storage/innobase/ ~/
cp -R percona-xtradb-1.0.3-7 mysql-5.1.37/storage/innobase
cd mysql-5.1.37
patch -p1 < ../percona-support.patch

5、创建组和用户
groupadd mysql
useradd -g mysql mysql

6、编译安装
CC="ccache /usr/local/gcc-4.3.2/bin/gcc -static-libgcc"
CFLAGS="-O3 -march=i686 -mpentiumpro -mstack-align-double"
CXX="ccache /usr/local/gcc-4.3.2/bin/gcc -static-libgcc"
CXXFLAGS="-O3 -march=i686 -mpentiumpro -mstack-align-double -felide-constructors -fno-exceptions -fno-rtti"
./configure \
--prefix=/usr/local/mysql-xtradb --datadir=/usr/local/mysql-xtradb/data \
--with-mysqld-user=mysql --with-server-suffix=-xtradb \
--with-plugins=partition,archive,blackhole,csv,innobase,federated \
--with-extra-charsets=complex --with-charset=utf8 --with-collation=utf8_general_ci --with-big-tables --with-ssl \
--with-fast-mutexes --with-zlib-dir=bundled \
--with-client-ldflags=-static --with-mysqld-ldflags=-static \
--with-pic --enable-assembler --enable-local-infile \
--enable-thread-safe-client --with-comment="MySQL Community Server (GPL)"

make
make install

7、由于我的系统比较旧，configure过程中遇到了错误以下是解决过程。
/bin/rm: cannot remove `libtoolT': No such file or directory
google得到http://bbs2.chinaunix.net/viewthread.php?tid=1568360
需要在安装目录执行
autoconf
automake
libtoolize --force

7.1、autoconf
报以下错误
configure.in:13: error: Autoconf version 2.60 or higher is required
原来需要升级autoconf
wget -c http://ftp.gnu.org/gnu/autoconf/autoconf-2.64.tar.gz
tar -zxvf autoconf-2.64.tar.gz
cd autoconf-2.64
./configure --prefix=/usr
make
make install

升级完成后，再执行autoconf，还需要升级m4
checking for GNU M4 that supports accurate traces... configure: error: no acceptable m4 could be found in $PATH.
GNU M4 1.4.6 or later is required; 1.4.13 is recommended

wget -c http://ftp.gnu.org/gnu/m4/m4-1.4.9.tar.gz
tar -zxvf m4-1.4.9.tar.gz
cd m4-1.4.9
./configure --prefix=/usr
make
make install

7.2、automake
报错 You should recreate configure.in:13: aclocal.m4 with aclocal and run automake again.
执行aclocal再automake，还报错 client/Makefile.am: required file `./compile' not found
缺少compile文件，copy一个过来 cp BUILD/compile-pentium-icc ./compile
再执行automake成功

7.3、libtoolize --force
此后再进行mysql的编译安装顺利完成。

8、配置
由于我之前安装有mysql，直接cp了一个my.cnf改了一下端口目录等

9、初始化
cd /usr/local/mysql-xtradb/
bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql-xtradb/data

10、目录权限
chown -R mysql.mysql /usr/local/mysql-xtradb

11、启动
bin/mysqld_safe --defaults-file=/usr/local/mysql-xtradb/my.cnf --user=mysql &

12、测试
bin/mysql -S./mysql.sock
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6
Server version: 5.1.37-xtradb-log MySQL Community Server with XtraDB (GPL)
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql>
连接成功！

 

转载于:https://www.cnblogs.com/seawwh/archive/2011/10/28/2227788.html