Tuesday, October 4, 2016

MySQL 8.0 and TokuDB

A stripped down version of TokuDB is running on MySQL 8.0.


mysql> select @@version\G;
*************************** 1. row ***************************
@@version: 8.0.0-dmr-debug
1 row in set (0.00 sec)

mysql> show create table test.t\G;
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> show engines\G;
*************************** 6. row ***************************
      Engine: TokuDB
     Support: YES
     Comment: Percona TokuDB Storage Engine with Fractal Tree(tm) Technology
Transactions: YES
          XA: YES
  Savepoints: YES

mysql> create table test.t (id int primary key) engine=tokudb;
Query OK, 0 rows affected (0.08 sec)

mysql> show create table test.t\G;
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

Look at where the data files are:


$ ls -1 data/
auto.cnf        
ib_logfile1                
mysqld_safe.pid         
sebastian.pid  
test                
__tokudb_lock_dont_delete_me_data        
__tokudb_lock_dont_delete_me_temp
ib_buffer_pool  
ibtmp1                     
performance_sche_3.SDI  
sys            
test_5.SDI          
__tokudb_lock_dont_delete_me_environment  
tokudb.rollback
ibdata1         
log000000000001.tokulog29  
performance_schema      
sys_4.SDI      
tokudb.directory    
__tokudb_lock_dont_delete_me_logs
ib_logfile0     
mysql                      
sebastian.err           
tc.log         
tokudb.environment  
__tokudb_lock_dont_delete_me_recovery

$ ls -1 data/test
t_323.SDI  
t_main_10_2_1d.tokudb  
t_status_10_1_1d.tokudb