Centos6.5Percona5.6.27Tokudb configuration _ MySQL

Unzip to usrlocal, create symbolic link # 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

Decompress the package to/usr/local and create the 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

Solution: search for # yum search libnuma

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

Numactl-devel.x86_64: Development package for building Applications that use numa

Install yum install numactl

Start the new ERROR [ERROR] TokuDB is not initialized because jemalloc is not loaded

Solution: install the yum extension source EPEL, that is, 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 has jemalloc-3.6.0-1.el6.x86_64 installed

# Rpm-ql jemalloc-3.6.0-1.el6.x86_64 to view the 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 = 128 K

Tokudb_read_buf_size = 128 K

# Separating TokuDB datadir and logdir from MySQL datadir.

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

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

Disable transparent_hugepage

# In order to take effect immediately, manually execute the following two statements: vi/etc/rc. local.

Echo never>/sys/kernel/mm/transparent_hugepage/enabled

Echo never>/sys/kernel/mm/transparent_hugepage/defrag

Install tokudb

# 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 = & gt; (0x00007fff197a5000)

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

Libreadline. so.5 => not found

Solution yum install compat-readline5-devel

After the installation is successful, check mysql> show engines;

| TokuDB | YES | Tokutek TokuDB Storage Engine with Fractal Tree (tm) Technology | YES |

...