mysql tokudb编译安装_mysql之Tokudb引擎安装
一、安装包
Percona-Server-5.6.22-rel71.0-726.Linux.x86_64.tar.gz:http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.22-72.0/binary/tarball/Percona-Server-5.6.22-rel71.0-726.Linux.x86_64.tar.gz
Percona-Server-5.6.22-rel72.0-738.TokuDB.Linux.x86_64.tar.gz:http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.22-72.0/binary/tarball/Percona-Server-5.6.22-rel72.0-738.TokuDB.Linux.x86_64.tar.gz
二、相关目录
BASEDIR=/usr/local/mysql
三、配置文件
[mysqld_safe]
malloc-lib= /usr/local/mysql/lib/mysql/libjemalloc.so
plugin-dir = /usr/local/mysql/lib/mysql/plugin/
plugin-load=ha_tokudb.so
四、安装步骤
1. 解压tokudb的包
tar -zxf Percona-Server-5.6.22-rel72.0-738.TokuDB.Linux.x86_64.tar.gz
2. 解压后,目录如下:
[root@localhost Percona-Server-5.6.22-rel72.0-738.Linux.x86_64]# ls
bin lib mysql-test README-TOKUDB
3. 把相关目录放到BASEDIR下
cp -r Percona-Server-5.6.22-rel72.0-738.Linux.x86_64/* /usr/local/mysql/
4. 启动之前,停用transparent huge pages
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag
echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled
echo never > /sys/kernel/mm/redhat_transparent_hugepage/defrag
5. 启动数据库
6. 手动添加plugin
INSTALL PLUGIN tokudb SONAME ’ha_tokudb.so’;
INSTALL PLUGIN tokudb_file_map SONAME ’ha_tokudb.so’;
INSTALL PLUGIN tokudb_fractal_tree_info SONAME ’ha_tokudb.so’;
INSTALL PLUGIN tokudb_fractal_tree_block_map SONAME ’ha_tokudb.so’;
INSTALL PLUGIN tokudb_trx SONAME ’ha_tokudb.so’;
INSTALL PLUGIN tokudb_locks SONAME ’ha_tokudb.so’;
INSTALL PLUGIN tokudb_lock_waits SONAME ’ha_tokudb.so’;
7. 检查添加结果
show engines;
show plugins;