版本:mariadb-5.5.37-tokudb-7.1.6
下载地址:
http://www.tokutek.com/products/mysql-download-for-mysql-mariadb/;
官方提供的二进制版本,基于Mysql和MariaDB版本,默认包含TokuDB、MyISAM和InnoDB存储引擎。
1、解压
tar xvf mariadb-5.5.37-tokudb-7.1.6-linux-x86_64.tar.gz -C /usr/local/
cd /usr/local/
ln -sv mariadb-5.5.37-tokudb-7.1.6-linux-x86_64/ mysql
2、初始化配置
useradd -M -s /sbin/nologin mysql
cd mysql
chown -R mysql:mysql *
cp -v support-files/my-small.cnf /etc/my.cnf
scripts/mysql_install_db --user=mysql --defaults-file=/etc/my.cnf
#
看到两个"OK"代表成功
chown -R root .
chown -R mysql data
cp support-files/mysql.server /etc/init.d/mysql
chmod +x
/etc/init.d/mysql
chkconfig --add mysql
chkconfig --level 2345 mysql on
关闭:THP
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag
/etc/init.d/mysql start
3、验证
MariaDB [(none)]> show engines;
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| TokuDB | YES | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | YES | YES | YES |
4、如果是从旧版本mysql升级,需要重新安装tokudb插件(全新安装可忽略该步骤)
在开始启动mysql时,需要设置默认存储引擎为myisam或innodb,在安装好tokudb插件后,可以设置默认存储引擎为tokudb。
INSTALL PLUGIN TokuDB SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_file_map SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_fractal_tree_info SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_fractal_tree_block_map SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_trx SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_locks SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_lock_waits SONAME 'ha_tokudb.so';
5、配置
tokudb_cache_size:类似innodb_buffer_pool_size,默认为1/2物理内存大小;
tokudb_data_dir:设置tokudb表存储位置,默认为mysql数据目录(datadir);
tokudb_directio:是否使用Direct IO,默认使用Buffered IO;
tokudb_row_format:指定压缩算法;
tokudb_commit_sync:设置是否事务提交时同步刷新日志。