Removing TokuDB storage engine

In case you want remove the TokuDB storage engine from Percona Server for MySQL without causing any errors following is the recommended procedure:

Change the tables from TokuDB to InnoDB

If you still need the data in the TokuDB tables you’ll need to alter the tables to other supported storage engine i.e., InnoDB: ALTER TABLE City ENGINE=InnoDB;


In case you remove the TokuDB storage engine before you’ve changed your tables to other supported storage engine you won’t be able to access that data without re-installing the TokuDB storage engine.

Removing the plugins

To remove the TokuDB storage engine with all installed plugins you can use the ps-admin script:

$ ps-admin --disable-tokudb -uroot -pPassw0rd

Script output should look like this:


Checking if Percona server is running with jemalloc enabled...
>> Percona server is running with jemalloc enabled.

Checking transparent huge pages status on the system...
>> Transparent huge pages are currently disabled on the system.

Checking if thp-setting=never option is already set in config file...
>> Option thp-setting=never is set in the config file.

Checking TokuDB plugin status...
>> TokuDB plugin is installed.

Removing thp-setting=never option from /etc/mysql/my.cnf
>> Successfuly removed thp-setting=never option from /etc/mysql/my.cnf

Uninstalling TokuDB plugin...
>> Successfuly uninstalled TokuDB plugin.

Another option is to manually remove the TokuDB storage engine with all installed plugins:

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

After the engine and the plugins have been uninstalled you can remove the TokuDB package by using the apt/yum commands:

[root@centos ~]# yum remove Percona-Server-tokudb-80.x86_64

or apt remove percona-server-tokudb-8.0


Make sure you’ve removed all the TokuDB specific variables from your configuration file (my.cnf) before you restart the server, otherwise server could show errors or warnings and won’t be able to start.

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.