Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of how to add tokudb in percona 5.7. in the operation of practical cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Make sure the libjemalloc is higher than 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

Large page support is required to start tokudb

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

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

Install the tokudb package

Yum-y UNINSTALL Percona-Server-tokudb-57.x86_64

Make the tokudb engine work

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)

-- Uninstall 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

This is the end of how to add tokudb to percona 5.7.Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.