Creating TokuDB tables

Creating a TokuDB table is much like creating a MyISAM, Aria, or InnoDB/XtraDB table. There are some more options and abilities we should know about.

Getting ready

Import the ISFDB database as described in the Importing the data exported by mysqldump recipe from Chapter 2, Diving Deep into MariaDB.

How to do it...

Follow the ensuing steps:

1. Launch the mysql command-line client and connect to the isfdb database.

2. Use the following CREATE statement to create our TokuDB table:

   CREATE TABLE authors_tokudb (
     author_id int NOT NULL AUTO_INCREMENT,
     author_canonical mediumtext,
     author_lastname varchar(128),
     author_birthplace mediumtext,
     author_birthdate date DEFAULT NULL,
     author_deathdate date DEFAULT NULL,
     PRIMARY KEY (author_id),
     KEY (author_lastname),
     KEY (author_birthdate),
     KEY (author_deathdate)
   ) ENGINE=TokuDB;
   

3. Import some data from the authors table into our new table:

   INSERT authors_tokudb
     SELECT
       author_id, author_canonical,
       author_lastname, author_birthplace...