Skip to content

Lede-Inc/tpcc-mysql

This branch is up to date with hewei-chn/tpcc-mysql:shard_by_wid.

Folders and files

NameName
Last commit message
Last commit date
Oct 3, 2010
Sep 21, 2012
Apr 4, 2018
Nov 28, 2016
Aug 26, 2011
Nov 28, 2016
Apr 4, 2018
Dec 4, 2008
Apr 4, 2018
Feb 12, 2016
Feb 14, 2017
Nov 28, 2016

Repository files navigation

  1. Build binaries

    • cd src ; make ( you should have mysql_config available in $PATH)
  2. Load data

    • create database bash ./create_db.sh
    • create tables mysql tpcc1000 < create_table.sql
    • create indexes and FK ( this step can be done after loading data) mysql tpcc1000 < add_fkey_idx.sql
    • populate data
      • simple step tpcc_load -h127.0.0.1 -d tpcc1000 -u root -p "" -w 1000 |hostname:port| |dbname| |user| |password| |WAREHOUSES| ref. tpcc_load --help for all options
      • load data in parallel check load.sh script
  3. Start benchmark

    • ./tpcc_start -h127.0.0.1 -P3306 -dtpcc1000 -uroot -w1000 -c32 -r10 -l10800
    • |hostname| |port| |dbname| |user| |WAREHOUSES| |CONNECTIONS| |WARMUP TIME| |BENCHMARK TIME|
    • ref. tpcc_start --help for all options

About

tpcc-mysql modify for cetus, shard by wid

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C 85.3%
  • Shell 12.6%
  • Python 1.6%
  • Other 0.5%