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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26418713/viewspace-1443069/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26418713/viewspace-1443069/