在MYSQL上添加TokuDB引擎

绝地灬酷狼 2024-02-17 21:13 46阅读 0赞

## [ TokuDB引擎说明：TokuDB 的主要特点是高压缩比，高 INSERT 性能，支持大多数在线修改索引、添加字段,非常适合日志型应用场景（只有insert，select，少update）；][TokuDB_TokuDB _ INSERT _insert_select_update] ##

一、安装步骤

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  
注：添加配置文件如下：  
配置文件  
\[mysqld\_safe\]  
 malloc-lib= /usr/local/mysql/lib/mysql/libjemalloc.so  
plugin-dir = /usr/local/mysql/lib/mysql/plugin/  
 plugin-load=ha\_tokudb.so

3. 把相关目录放到BASEDIR下

cp -r Percona-Server-5.6.22-rel72.0-738.Linux.x86\_64/\* /usr/local/mysql/

4. 启动之前，停用transparent huge pages（启动之前，停用transparent huge pages 如果不关闭可能会导致TokuDB内存泄露（建议写到 /etc/rc.local 中，重启仍然生效））

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. 检查未添加结果

show engines;  
mysql> show engines;  
\+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+  
| Engine | Support | Comment | Transactions | XA | Savepoints |  
\+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+  
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |  
| MRG\_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |  
| CSV | YES | CSV storage engine | NO | NO | NO |  
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |  
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |  
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |  
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |  
|  InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |  
| PERFORMANCE\_SCHEMA | YES | Performance Schema | NO | NO | NO |  
\+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+  
9 rows in set (0.00 sec)

7. 手动添加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’;

或

root@hostname:/data/tokuDB/bin\#./ps\_tokudb\_admin --enable --user=root--password=123456 --socket=/data/data20170414/mysql33010.sock --host=192.168.1.111 --port=33010 --defaults-file=/data/data20170414/backup-my.cnf  
ps\_tokudb\_admin: unrecognized option '--defaults-file=/data/data20170414/backup-my.cnf'  
root@hostname:/data/tokuDB/bin\#./ps\_tokudb\_admin --enable --user=root--password=123456 --socket=/data/data20170414/mysql33010.sock --host=192.168.1.111 --port=33010  
Checking if Percona server is running with jemalloc enabled...  
>> Percona server is not running with jemalloc, please restart server to enable it and then run this script...  
需要安装：

缺包，先安装

\# yum install epel-release

然后就可以安装jemalloc了：

\# yum install jemalloc

1).jemalloc的下载：

[http://www.canonware.com/download/jemalloc/][http_www.canonware.com_download_jemalloc]

使用最近版本的jemalloc：

[http://www.canonware.com/download/jemalloc/jemalloc-3.5.0.tar.bz2][http_www.canonware.com_download_jemalloc_jemalloc-3.5.0.tar.bz2]

~$ wget [ http://www.canonware.com/download/jemalloc/jemalloc-3.5.0.tar.bz2][http_www.canonware.com_download_jemalloc_jemalloc-3.5.0.tar.bz2]

2).解压下载下来的tar包

~$ tar jxvf jemalloc-3.5.0.tar.bz2

3).安装jemalloc shell：

~$ ./configure --prefix=/usr/local

~$ make

~$ sudo make install

或

RPM安装jemalloc

8. 检查添加结果

show engines;

show plugins;

[TokuDB_TokuDB _ INSERT _insert_select_update]: http://www.cnblogs.com/LMySQL/p/4555378.html
[http_www.canonware.com_download_jemalloc]: http://www.canonware.com/download/jemalloc/
[http_www.canonware.com_download_jemalloc_jemalloc-3.5.0.tar.bz2]: http://www.canonware.com/download/jemalloc/jemalloc-3.5.0.tar.bz2