TokuDB是一個(gè)支持事務(wù)的“新”引擎，有出色的數(shù)據(jù)壓縮功能，如果數(shù)據(jù)寫多讀少，而且數(shù)據(jù)量比較大，建議使用TokuDB，節(jié)省空間成本，大幅降低存儲(chǔ)使用量和IOPS開銷，不過會(huì)相應(yīng)增加CPU壓力。
安裝percona mysql 5.7
#yum安裝
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm](http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
yum install Percona-Server-server-57
安裝percona之后，隨機(jī)密碼在/var/log/mysqld.log中
cat /var/log/mysqld.log | grep "A temporary password" | awk -F " " '{print$11}'
#登錄之后重新修改密碼
ALTER USER root@localhost IDENTIFIED BY 'YourPassword';
#設(shè)置密碼策略為0
set global validate_password_policy = 0;
#設(shè)置/etc/my.cnf，增加
[mysqld_safe]
malloc-lib= /path/to/jemalloc
安裝tokudb
#安裝之前要安裝jemalloc
yum install -y jemalloc
yum install Percona-Server-tokudb-57.x86_64
ps_tokudb_admin --enable -uroot -p
檢查
show engines;
| TokuDB | YES | Percona TokuDB Storage Engine with Fractal Tree(tm) Technology | YES | YES | YES |
show plugins;
| TokuDB | ACTIVE | STORAGE ENGINE | ha_tokudb.so | GPL |
| TokuDB_file_map | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_fractal_tree_info | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_fractal_tree_block_map | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_trx | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_locks | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_lock_waits | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_background_job_status | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
#查看版本
mysql> SELECT @@tokudb_version;
+------------------+
| @@tokudb_version |
+------------------+
| 5.7.18-15 |
+------------------+
1 row in set (0.00 sec)
