Configuring TokuDB

Like other storage engines, TokuDB has many custom settings and options. Thankfully, there are only a few that we really need to know about up front, and the default settings are fairly optimized.

Getting ready

This recipe is going to assume a few things; firstly, that our server has 16 GB of RAM, and secondly that we have two SSD drives, /dev/sdb1 and /dev/sdc1, mounted under the /mnt/ directory.

How to do it...

Follow the ensuing steps:

1. Open the my.cnf file and add the following lines to an existing [mysqld] section:

   # TokuDB Cache should be set to at least half of available RAM
   tokudb-cache-size = 9GB
   
   # TokuDB File Locations
   tokudb-data-dir = /mnt/sdb1
   tokudb-log-dir  = /mnt/sdb1
   tokudb-tmp-dir  = /mnt/sdc1
   

2. Disable the write cache on our disks with the following:

   hdparm -W0 /dev/sdb1
   hdparm -W0 /dev/sdc2
   

3. Show the status of TokuDB with the following command:

   SHOW ENGINE TokuDB STATUS;
   

How it works...

There are many settings for TokuDB that we can tweak, enable, and disable...