Removing TokuDB storage engine¶
In case you want remove the TokuDB storage engine from Percona Server 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:
mysql> 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_tokudb_admin --disable -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; 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;
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-57.x86_64
root@wheezy:~# apt-get remove percona-server-tokudb-5.7
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.