percona 5.7怎么增加tokudb

本篇内容介绍了“percona 5.7怎么添加tokudb”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

确保 libjemalloc 高于 3.3.0 

 [root@fund-mgmt-db-mog-2 ~]# yum list |grep jemalloc

jemalloc.x86_64              3.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;

“percona 5.7怎么添加tokudb”的内容就介绍到这里了，感谢大家的阅读。

（编辑：银川站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!