FAQ

中文

TerarkSQL FAQ

What is the best workload for TerarkSQL?

The best workloads are random read heavy on text rich data, but still works pretty good on other workloads.

What is the compatibility of MySQL on TearkDB with the official MySQL ?

TerarkSQL uses MyRocks as the adapter layer.

TerarkSQL supports all the features that MyRocks has, and MyRocks also has some limits on MySQL(so does TerarkSQL).

MyRocks Limits

How do you load a huge data file into MySQL by load data infile?

Since TerarkSQL is using MyRocks, and MyRocks configurations are optimized for short transactions, and not for data loading.

MyRocks has a couple of special session variables to speed up data loading dramatically MyRocks Data Loading Details.

Here's the most important two variables:

SET session sql_log_bin=0;              -- disable log
SET rocksdb_commit_in_the_middle=1;     -- commit transaction every 1000(default value) inserts

How to execute compact?

set global rocksdb_compact_cf='default';