The TokuDB storage engine is for use in high-performance and write-intensive environments, offering increased compression and better performance.
It is available in an open-source version, included with 64-bit MariaDB (but not enabled by default), and an Enterprise edition available from Tokutek.
Official TokuDB Product Specs and Manuals are available on the Tokutek website. See:
TokuDB is available on the following distributions:
|CentOS 6 64-bit and newer||MariaDB 5.5.36 and MariaDB 10.0.9|
|Debian 7 "wheezy"64-bit and newer||MariaDB 5.5.33 and MariaDB 10.0.5|
|Fedora 19 64-bit and newer||MariaDB 5.5.33 and MariaDB 10.0.5|
|openSUSE 13.1 64-bit and newer||MariaDB 5.5.41 and MariaDB 10.0.15|
|Red Hat 6 64-bit and newer||MariaDB 5.5.36 and MariaDB 10.0.9|
|Ubuntu 12.10 "quantal" 64-bit and newer||MariaDB 5.5.33 and MariaDB 10.0.5|
Note that the default value of tokudb_pk_insert_mode will prevent row-based replication from working. To use RBR, change the value of this variable.
Until MariaDB versions 5.5.39 and 10.0.13, before upgrading TokuDB, the server needed to be cleanly shut down. If the server was not cleanly shut down, TokuDB would fail to start. Since 5.5.40 and 10.0.14, this has no longer been necessary. See MDEV-6173.
Versions of the TokuDB plugin included in MariaDB
The version of TokuDB in your local MariaDB is available by querying the tokudb_version status variable. For example:
SHOW VARIABLES LIKE 'tokudb_version';
FYI: In the MariaDB binary tarballs, only the ones labeled "glibc_214" have TokuDB.
- ↑ with this version, TokuDB now follows the version numbering of Percona XtraDB
More information about TokuDB in MariaDB can be found on the following pages:
Enabling TokuDBHow to Enable TokuDB in MariaDB
TokuDB DifferencesThings to know before using TokuDB in MariaDB
TokuDB ResourcesOnline TokuDB resources
TokuDB Status VariablesTokuDB status variables
TokuDB System VariablesTokuDB System Variables