Centos 6.5 Percona 5.6.27 tokudb configuration

Reference https://www.percona.com/doc/percona-server/5.6/tokudb/tokudb_installation.html

# wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.27-75.0/binary/tarball/ Percona-server-5.6.27-rel75.0-linux.x86_64.ssl101.tar.gz

Unzip to/usr/local and create a symbolic link/usr/local/percona

Startup error/usr/local/percona/bin/mysqld:error while loading shared libraries:libnuma.so.1:cannot open Shared object File:no Such file or directory

FIX: Find # Yum Search Libnuma

Numactl.x86_64:Library for tuning for Non Uniform Memory Access Machines

Numactl-devel.x86_64:development Package for building Applications this use NUMA

Installing the Yum install Numactl

Start a new error [ERROR] Tokudb is not initialized because jemalloc are not loaded

Workaround: Install the Yum extension source Epel extra Packages for Enterprise Linux

# RPM-IVH http://mirrors.sohu.com/fedora-epel/6/x86_64/epel-release-6-8.noarch.rpm

# Yum Install Jemalloc installs the jemalloc-3.6.0-1.el6.x86_64

# RPM-QL jemalloc-3.6.0-1.el6.x86_64 View the specific path of the library

/usr/lib64/libjemalloc.so.1

# VI/ETC/MY.CNF

[Mysqld_safe]

Malloc-lib=/usr/lib64/libjemalloc.so.1

[Mysqld]

...

Plugin-dir =/usr/local/percona/lib/mysql/plugin

Plugin-load=ha_tokudb.so

Tokudb_row_format = Tokudb_fast

Tokudb_cache_size = 1G

Tokudb_commit_sync = 0

Tokudb_directio = 1

Tokudb_read_block_size = 128K

Tokudb_read_buf_size = 128K

#把TokuDB DataDir and LogDir and MySQL datadir separate, beauty view

Tokudb-data-dir =/data/mysql/tokudb/data

Tokudb-log-dir =/data/mysql/tokudb/log

Disable Transparent_hugepage

# vi/etc/rc.local in order to take effect immediately, but also to execute these two sentences by hand

echo Never >/sys/kernel/mm/transparent_hugepage/enabled

echo Never >/sys/kernel/mm/transparent_hugepage/defrag

Install TOKUDB after successful startup

# Cd/usr/local/percona/bin

#./ps_tokudb_admin--enable-uroot-ppassw0rd

Mysql:error while loading shared libraries:libreadline.so.5:cannot open Shared object file:no such file or directory

Ldd/usr/local/percona/bin/mysql

Linux-vdso.so.1 = (0x00007fff197a5000)

libpthread.so.0 =/lib64/libpthread.so.0 (0x00007f422479d000)

Libreadline.so.5 = not Found

Workaround Yum Install Compat-readline5-devel

After successful installation view mysql> show ENGINES;

| Tokudb | YES | Tokutek tokudb Storage Engine with Fractal Tree (tm) technology | YES | YES | YES |

...

Centos 6.5 Percona 5.6.27 tokudb configuration