Phishman – Tech

I was installing TokuDB Storage Engine on Percona 5.7 Server based on this Percona guide, when I realized that there’s no my.cnf file.

You are still able to configure the server and install plugins from within the MySQL CLI.

Tech Specs:
OS: Debian Jessie
RAM: 32 GB
CPU 2 Cores, 4 Threads
Storage: SSD NVMe Samsung 960 Evo

More about the server:
This little MONSTER is amazing!

I have it paired with Intel G4560, 32 GB DDR4 G.Skill Ripjaws (2 x 16 GB) and M.2 Samsung Evo 960 250GB. Installed Debian Jessie server edition (with latest kernel) and did SSD read/write benchmark. It does 1.7 GB/s write and 3.8 GB/s read of 1 GB file. Insane!!!
Stock CPU fan – CPU 32C, motherboard 34C degrees. Under load 38-40C max!

I had to buy Skylake CPU (Intel G4400) to update the BIOS for the Kaby Lake (Intel G4560) support. It’s LAME! Those manufacturers must integrate USB flashing by default as a basic functionality! If I had time I would send the motherboard back or just return it. Unfortunately I had no time to ship my motherboard for BIOS update. It was in the product description that it supports 6th Gen Skylake CPU, even on ASUS’ website it was clearly stated that it needs BIOS update, so it’s not something that I didn’t know. It still is the best, smallest STX motherboard!

I would highly recommend and I would buy AGAIN this little monster board! I hope it stays sharp and fast!
I’ve been waiting for an STX form factor for years. It’s dream come true! 🙂

Thanks crazy awesome ASUS! 🙂

Here’s how to do it:

1. Installing Percona Server on Debian and Ubuntu (Official)
2. To avoid “ERROR 1123 (HY000): Can’t initialize function ‘TokuDB’; Plugin initialization function failed”, you need to disable Kernel Transparent Hugepages for TokuDB, if not disabled.
   Here’s how to check:
   
   Check Transparent Hugepages Status

   cat /sys/kernel/mm/transparent_hugepage/enabled

   1	cat /sys/kernel/mm/transparent_hugepage/enabled

   
   It should return something like:
   
   [always] madvise never

   1	[always] madvise never

   
   If it’s not set to never, you can do:
   
   Change Transparent Hugepages in The Kernel Config

   if test -f /sys/kernel/mm/transparent_hugepage/enabled; then echo never > /sys/kernel/mm/transparent_hugepage/enabled fi

   1 2 3

   if test -f /sys/kernel/mm/transparent_hugepage/enabled; then    echo never > /sys/kernel/mm/transparent_hugepage/enabled fi

   
   Reboot.
   Test again after boot:
   
   Check Transparent Hugepages in Linux Kernel

   cat /sys/kernel/mm/transparent_hugepage/enabled

   1	cat /sys/kernel/mm/transparent_hugepage/enabled

   
   Now it should be:
   
   always madvise [never]

   1	always madvise [never]

   
    
3. Dependencies
   You need libjemalloc library installed. Quick and simple installation:
   
   Install libjemalloc And Unmet Dependencies

   apt-get install libjemalloc-dev apt-get build-dep libjemalloc-dev

   1 2	apt-get install libjemalloc-dev apt-get build-dep libjemalloc-dev

   
    
4. Install The TokuDB Engine
   
   Install The TokuDB Engine and Plugins

   mysql -uroot -p # Install the TokuDB Engine mysql> install plugin tokudb soname 'ha_tokudb.so'; # Install the Other TokuDB Plugins mysql> install plugin tokudb_trx soname 'ha_tokudb.so'; mysql> install plugin tokudb_locks soname 'ha_tokudb.so'; mysql> install plugin tokudb_lock_waits soname 'ha_tokudb.so'; mysql> install plugin tokudb_file_map soname 'ha_tokudb.so'; mysql> install plugin tokudb_fractal_tree_info soname 'ha_tokudb.so'; mysql> install plugin tokudb_fractal_tree_block_map soname 'ha_tokudb.so';

   1 2 3 4 5 6 7 8 9 10 11 12

   mysql -uroot -p   # Install the TokuDB Engine mysql> install plugin tokudb soname 'ha_tokudb.so';   # Install the Other TokuDB Plugins mysql> install plugin tokudb_trx soname 'ha_tokudb.so'; mysql> install plugin tokudb_locks soname 'ha_tokudb.so'; mysql> install plugin tokudb_lock_waits soname 'ha_tokudb.so'; mysql> install plugin tokudb_file_map soname 'ha_tokudb.so'; mysql> install plugin tokudb_fractal_tree_info soname 'ha_tokudb.so'; mysql> install plugin tokudb_fractal_tree_block_map soname 'ha_tokudb.so';

   
   Test to check, if the TokuDB storage engine was successfully installed do:
   
   View Installed MySQL Engines

   mysql>SHOW ENGINES;

   1	mysql>SHOW ENGINES;

   
    

That’s it. Enjoy! 🙂

Feel free to shoot me a message in the comments.