Example
================================

TideSQL install.sh to a specific location(e.g /data being NVMe disk):
./install.sh --mariadb-prefix /data/mariadb --tidesdb-prefix /data/tidesdb --build-dir /data/tidesql-build

You need latest sysbench and libmysqlclient21:
sudo apt update && sudo apt install -y sysbench libmysqlclient21


nohup env \
  BUILD_DIR=/data/mariadb \
  MYSQL_BIN=/data/mariadb/bin/mariadb \
  MYSQLD=/data/mariadb/bin/mariadbd \
  PLUGIN_DIR=/data/mariadb/lib/plugin \
  DATA_DIR=/data/db-bench \
  TABLE_SIZES="10000000" \
  TABLES=8 \
  THREAD_COUNTS="1 8 16 32" \
  TIME=300 \
  WARMUP=120 \
  ENGINES="TidesDB InnoDB" \
  WORKLOADS="oltp_read_write oltp_point_select oltp_insert oltp_write_only" \
  TIDESDB_SYNC_MODE=0 \
  ITERATIONS=3 \
  TIDESDB_COMPRESSION=LZ4 \
  INNODB_COMPRESSION=LZ4 \
  TIDESDB_BLOCK_CACHE=2147483648 \
  INNODB_BUFFER_POOL=2G \
  INNODB_FLUSH=0 \
  ./sqlbench.sh > sqlbench.log 2>&1 &


Plotting
================================

python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
python plot_results.py \
  --summary results/summary_20260212_230923.csv \
  --detail results/detail_20260212_230923.csv \
  --outdir plots