Skip to content

Instantly share code, notes, and snippets.

@amyangfei
Last active March 12, 2020 03:25
Show Gist options
  • Save amyangfei/52d62380bde77f51c075a0085ef4fa3c to your computer and use it in GitHub Desktop.
Save amyangfei/52d62380bde77f51c075a0085ef4fa3c to your computer and use it in GitHub Desktop.
cdc stability test cases

sysbench insert

  • run sysbench insert for at least 12 hours
  • status: ✅

sysbench insert with multiple regions Pass

  • pre split regions
#!/bin/bash

host="172.16.5.113"
user="root"
port="4000"
db="cdc_bench"
table="sbtest1"
N=20

start=0
for i in $(seq 1 $N); do
        end=$(( 1100000 + start))
        mysql -h$host -u$user -P$port -e "split table $db.$table between ($start) and ($end) regions 1000"
        start=$end
done
  • run sysbench insert
  • status: ✅

small region sysbench insert, at least 3 hours

  • tikv config
[coprocessor]
region-max-keys = 30000
region-split-keys = 25000
  • run sysbench insert
  • status: TODO

Create table continuously

  • create table every 10s and create 3k tables totally.
  • status: TODO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment