Enabling TokuDB

You are viewing an old version of this article. View the current version here.

Note that ha_tokudb is not included in binaries built with the "old" glibc. Binaries built with glibc 2.14+ do include it.

TokuDB is available on the following distributions:

DistributionIntroduced
CentOS 6 64-bit and newerMariaDB 5.5.36 and MariaDB 10.0.9
Debian 7 "wheezy"64-bit and newerMariaDB 5.5.33 and MariaDB 10.0.5
Fedora 19 64-bit and newerMariaDB 5.5.33 and MariaDB 10.0.5
openSUSE 13.1 64-bit and newerMariaDB 5.5.41 and MariaDB 10.0.15
Red Hat 6 64-bit and newerMariaDB 5.5.36 and MariaDB 10.0.9
Ubuntu 12.10 "quantal" 64-bit and newerMariaDB 5.5.33 and MariaDB 10.0.5

Note: The TokuDB version that comes from MariaDB.org differs slightly from the TokuDB version from Tokutek. Please read the TokuDB Differences article before using TokuDB!

The following sections detail how to install and enable TokuDB.

Installing TokuDB

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.

TokuDB has been included with MariaDB since MariaDB 5.5.34 and MariaDB 10.0.6 and does not require separate installation. Proceed straight to Check for Transparent HugePage Support on Linux. For older versions, see the distro-specific instructions below.

Installing TokuDB on Fedora, RedHat, & CentOS

MariaDB 5.5.33

In MariaDB 5.5.33 and MariaDB 10.0.5, TokuDB is in a separate RPM package called MariaDB-tokudb-engine and is installed as follows:

sudo yum install MariaDB-tokudb-engine

Installing TokuDB on Ubuntu & Debian

On Ubuntu, TokuDB is available on the 64-bit versions of Ubuntu 12.10 and newer. On Debian, TokuDB is available on the 64-bit versions of Debian 7 "Wheezy" and newer.

MariaDB 5.5.33

In MariaDB 5.5.33 and MariaDB 10.0.5, TokuDB is in a separate package called mariadb-tokudb-engine-x.x, where x.x is the MariaDB series (5.5 or 10.0). The package is installed, for example on 5.5, as follows:

sudo apt-get install mariadb-tokudb-engine-5.5

Check for Transparent HugePage Support on Linux

The TokuDB README says:

Transparent hugepages is a feature in newer linux kernel versions that causes problems for the memory usage tracking calculations in TokuKV and can lead to memory overcommit. If you have this feature enabled, TokuKV will not start, and you should turn it off.

You can check the status of Transparent Hugepages as follows:

cat /sys/kernel/mm/transparent_hugepage/enabled

If the path does not exist, Transparent Hugepages are not enabled and you may continue.

Alternatively, the following will be returned:

always madvise [never]

indicating Transparent Hugepages are not enabled and you may continue. If the following is returned:

[always] madvise never

Transparent Hugepages are enabled, and you will need to disable them.

To disable them, pass "transparent_hugepage=never" to the kernel in your bootloader (grub, lilo, etc.). For example, for SUSE, add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, such as after "showopts", and press OK. The setting will take effect on the next reboot.

You can also disable with:

echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag

On Centos or RedHat you can do:

Add line GRUB_CMDLINE_LINUX_DEFAULT="transparent_hugepage=never" to file /etc/default/grub

Update grub (boot loader):

grub2-mkconfig -o /boot/grub2/grub.cfg "$@"

For more information, see http://unix.stackexchange.com/questions/99154/disable-transparent-hugepages

Enabling TokuDB

Attempting to enable TokuDB while Linux Transparent HugePages are enabled will fail with an error such as:

ERROR 1123 (HY000): Can't initialize function 'TokuDB'; Plugin initialization function failed

See the section above; Check for Transparent HugePage Support on Linux.

The binary log also needs to be enabled before attempting to enable TokuDB. Strictly speaking, the XA code requires two XA-capable storage engines, and this is checked at startup. In practice, this requires InnoDB and the binary log to be active. If it isn't, the following warning will be returned and XA features will be disabled:

Cannot enable tc-log at run-time. XA features of TokuDB are disabled

MariaDB's default my.cnf files come with a section for TokuDB. To enable TokuDB just remove the '#' comment markers from the options in the TokuDB section.

A typical TokuDB section looks like the following:

# See https://mariadb.com/kb/en/how-to-enable-tokudb-in-mariadb/
# for instructions how to enable TokuDB
#
# See https://mariadb.com/kb/en/tokudb-differences/ for differences
# between TokuDB in MariaDB and TokuDB from http://www.tokutek.com/

plugin-load=ha_tokudb

By default, the plugin-load option is commented out. Simply un-comment it as in the example above and restart MariaDB to activate TokuDB.

Enabling TokuDB on Fedora

Instead of putting the TokuDB section in the main my.cnf file, it is placed in a separate file located at: /etc/my.cnf.d/tokudb.cnf

Enabling TokuDB on Ubuntu & Debian

Instead of putting the TokuDB section in the main my.cnf file, it is placed in a separate file located at: /etc/mysql/conf.d/tokudb.cnf

Enabling TokuDB manually from the mysql command line

Generally, it is recommended to use one of the above methods to enable the TokuDB storage engine, but it is also possible to enable it manually as with other plugins. To do so, launch the mysql command-line client and connect to MariaDB as a user with the SUPER privilege and execute the following command:

INSTALL SONAME 'ha_tokudb';

TokuDB will be installed until someone executes UNINSTALL SONAME.

Temporarily enabling TokuDB when starting MariaDB

If you just want to test TokuDB, you can start the mysqld server with TokuDB with the following command:

mysqld --plugin-load=ha_tokudb --plugin-dir=/usr/local/mysql/lib/mysql/plugin

See also

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.