mysql之Tokudb引擎安装
一、安装包
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’;
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
三、配置文件
[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;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26418713/viewspace-1443069/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
【数据库基础】ACID特性
请登录后发表评论
登录
全部评论
