Suppose you have a TokuDB table
mytable in the
You should do a NULL storage engine conversion. In other words, simply convert it to TokuDB again.
ALTER TABLE mydb.mytable ENGINE=TokuDB;
ANALYZE TABLE mydb.mytable;
You can watch the creation of the temp table in
/var/lib/mysql/db. Look for any table named
If you want to monitor the stages, then convert the table in stages
CREATE TABLE mytable_new LIKE mytable;
INSERT INTO mytable_new SELECT * FROM mytable;
ANALYZE TABLE mydb.mytable_new;
ALTER TABLE mytable RENAME mytable_old;
ALTER TABLE mytable_new RENAME mytable;
DROP TABLE mytable_old;
To monitor it, goto
/var/lib/mysql/db and run
ls -l mytable*
Give it a Try !!!
UPDATE 2014-07-03 13:53 EDT
MariaDB has progress metering for DDL. I wrote about this in my old post Is there a progress indicator for OPTIMIZE TABLE progress?. You may need to switch to MariaDB and enable TokuDB.