Skip to content

tidesdb/sqlbench

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

36 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

nohup env \
  BUILD_DIR=/usr/local/mariadb \
  MYSQL_BIN=/usr/local/mariadb/bin/mariadb \
  MYSQLD=/usr/local/mariadb/bin/mariadbd \
  PLUGIN_DIR=/usr/local/mariadb/lib/plugin \
  DATA_DIR=/data/db-bench \
  TABLE_SIZES="1000000" \
  TABLES=4 \
  THREAD_COUNTS="1 8 16" \
  TIME=300 \
  WARMUP=60 \
  ENGINES="TidesDB InnoDB" \
  WORKLOADS="oltp_read_write oltp_point_select oltp_insert oltp_write_only" \
  TIDESDB_SYNC_MODE=0 \
  ITERATIONS=2 \
  TIDESDB_COMPRESSION=LZ4 \
  INNODB_COMPRESSION=LZ4 \
  TIDESDB_BLOCK_CACHE=536870912 \
  INNODB_BUFFER_POOL=512M \
  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

About

Benchmark script for comparing engines within MariaDB

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published