Book Image

MariaDB Cookbook

By : Daniel Bartholomew
Book Image

MariaDB Cookbook

By: Daniel Bartholomew

Overview of this book

Table of Contents (20 chapters)
MariaDB Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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...