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:
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¶
If you’re using Percona Server for MySQL
5.6.22-72.0 or later you can use the
ps_tokudb_admin script to remove the plugins:
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.
Prior to Percona Server for MySQL
5.6.22-72.0 TokuDB storage engine requires manual removal:
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;
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-56.x86_64
root@wheezy:~# apt-get remove percona-server-tokudb-5.6
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.