percona 5.7怎么添加tokudb

确保 libjemalloc 高于 3.3.0
[root@fund-mgmt-db-mog-2 ~]# yum list |grep jemalloc
jemalloc.x86_643.6.0-1.el7 @percona-release-x86_64
jemalloc-debuginfo.x86_64 3.3.1-1.el7 percona-release-x86_64
jemalloc-devel.x86_64 3.6.0-1.el7 percona-release-x86_64

一定要大页支持，才能启动 tokudb
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag

安装tokudb包
yum -y UNINSTALL Percona-Server-tokudb-57.x86_64

让 tokudb 引擎生效
ps_tokudb_admin --enable -uroot -p###### -S /home/mysql/my3313/run/mysql.sock -P 3313

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment| Transactions | XA| Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES|
| CSV| YES | CSV storage engine | NO| NO| NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO| NO| NO |
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) | NULL | NULL | NULL|
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO| NO| NO |
| TokuDB | YES | Percona TokuDB Storage Engine with Fractal Tree(tm) Technology | YES | YES | YES|
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO| NO| NO |
| ARCHIVE| YES | Archive storage engine | NO| NO| NO |
| MyISAM | YES | MyISAM storage engine | NO| NO| NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL|
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
10 rows in set (0.00 sec)

-- 卸载 tokudb

UNINSTALL PLUGIN tokudb ;
UNINSTALL PLUGIN tokudb_file_map ;
UNINSTALL PLUGIN tokudb_fractal_tree_info ;
UNINSTALL PLUGIN tokudb_fractal_tree_block_map ;
UNINSTALL PLUGIN tokudb_trx ;
UNINSTALL PLUGIN tokudb_locks ;
UNINSTALL PLUGIN tokudb_lock_waits;
UNINSTALL PLUGIN tokudb_background_job_status;