#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type corebanking -bench-sub-types "hzbank_simulation" -versions nightly -threads 1 -duration=1000m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-configs "{prepared-plan-cache: {enabled: true}}" --tidb-replicas 1 -destroy-on-failure=false -warmup=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type hzbank -bench-sub-types "hzbank_simulation" -versions v5.4.0 -threads 1 -duration=1000m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-configs "{prepared-plan-cache: {enabled: true}}" -tidb-replicas 1 -tikv-replicas 3 -destroy-on-failure=false -warmup=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type benchmarksql -versions nightly -threads 1 -duration=1000m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-configs "{prepared-plan-cache: {enabled: true}}" --tidb-replicas 1 -destroy-on-failure=false -warmup=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type ycsb -bench-sub-types "workloada,workloadb,workloadc,workloadd,workloade" -versions v5.3.0 -threads 50 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 10m -tidb-configs "{prepared-plan-cache.enabled: true}" -tidb-replicas 1 -mysql-ignore-errors 2013
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -skip injection -- perftest -bench-type sysbench -bench-sub-types "oltp_read_write" -versions nightly -threads 10 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 5m -tidb-configs "{prepared-plan-cache.enabled: true}" -tidb-globals "alter table test.sbtest1 cache; alter table test.sbtest2 cache; alter table test.sbtest3 cache; alter table test.sbtest4 cache; alter table test.sbtest5 cache; alter table test.sbtest6 cache; alter table test.sbtest7 cache; alter table test.sbtest8 cache; alter table test.sbtest9 cache; alter table test.sbtest10 cache; alter table test.sbtest11 cache; alter table test.sbtest12 cache; alter table test.sbtest13 cache; alter table test.sbtest14 cache; alter table test.sbtest15 cache; alter table test.sbtest16 cache; alter table test.sbtest17 cache; alter table test.sbtest18 cache; alter table test.sbtest19 cache; alter table test.sbtest20 cache; alter table test.sbtest21 cache; alter table test.sbtest22 cache; alter table test.sbtest23 cache; alter table test.sbtest24 cache; alter table test.sbtest25 cache; alter table test.sbtest26 cache; alter table test.sbtest27 cache; alter table test.sbtest28 cache; alter table test.sbtest29 cache; alter table test.sbtest30 cache; alter table test.sbtest31 cache; alter table test.sbtest32 cache;" -tidb-replicas 1 -tikv-replicas 2 -sysbench-options "--tables=32 --table-size=100000 --mysql-ignore-errors=2013 --auto-inc=false" -storage-url 's3://benchmark/sysbench-32-100000' -warmup=false -staging=false  -destroy-on-failure=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type tpcc -versions nightly -threads 80 -duration=30m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-configs "{prepared-plan-cache: {enabled: true}}" --tidb-replicas 1  -staging=false -pd_ctls '['scheduler config balance-hot-region-scheduler set strict-picking-store false', 'scheduler config balance-hot-region-scheduler set write-leader-priorities query,byte']'
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type ch -versions nightly -threads 1 -duration=30m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-configs "{prepared-plan-cache: {enabled: true}, mem-quota-query: 1073741825}" -tikv-configs "{storage: {block-cache: {capacity: 31GB}}}" -tidb-replicas 1 -tiflash-replicas 0 -queries ""q1,q2,q3,q4,q5,q6,q7,q8,q10,q11,q12,q13,q14,q15,q16,q17,q18,q19,q20,q21,q22""
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type tpcc -versions v5.3.0 -threads 80 -duration=30m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-configs "{prepared-plan-cache: {enabled: true}}" --tidb-replicas 1  -tikv-configs "{raftstore: {store-io-pool-size: 1}, raft-engine: {enable: true}}" -tikv-urls "http://fileserver.pingcap.net/download/builds/pingcap/tikv/171ffa9179794f35432a3943785110c30a44665b/centos7/tikv-server.tar.gz" -staging=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type tpch -bench-sub-types tpch-tikv-50g -duration 20m -versions v5.3.0 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-replicas 1 -tiflash-replicas 2 -staging true
#KUBECONFIG=./kubeconfig.yml CGO_ENABLED=0 ginkgo -focus bench -- perftest -bench-type tpcds -bench-sub-types tpcds-tikv-50g -duration 20m -versions nightly -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-replicas 1 -tiflash-replicas 2 -staging=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type job -bench-sub-types job-tikv-50g  -duration 20m -versions v5.2.2 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-replicas 1  -versions nightly -staging=false
KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type sysbench -bench-sub-types "oltp_insert" -versions v6.0.0 -threads 2000 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 1200m -tidb-configs "{prepared-plan-cache.enabled: true}" -tikv-replicas 5 
KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type taobench -bench-sub-types "workload_a" -versions v6.1.0 -threads 32 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 1200m -tidb-configs "{prepared-plan-cache.enabled: true}" -tiflash-replicas 1
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type sysbench -bench-sub-types "oltp_read_write" -versions v4.0.14 -storage-url "s3://benchmark/sysbench-32-10000000-release4.0" -db-name test  -threads 5 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 10m -tidb-configs '{plugin: {load: "audit-1,whitelist-1", dir: "/tiup/deploy/plugins"}}' -tidb-replicas 1 -plugin-url-prefix "http://fileserver.pingcap.net/download/builds/pingcap/tidb-plugins/optimization/v4.0.14/centos7/,http://fileserver.pingcap.net/download/builds/pingcap/tidb-plugins/v4.0.14-20220303/centos7" -tidb-urls ",http://fileserver.pingcap.net/download/builds/pingcap/tidb/patch/v4.0.14-20220303/825699d6949d441cb229e1dd6fdd220f7898fe3f/centos7/tidb-server.tar.gz" -tidb-globals "admin plugins enable whitelist;admin plugins enable audit;insert into mysql.tidb_audit_table_access (user, db, tbl, access_type) values ('.*', '.*', '.*', ''); insert into mysql.whitelist (name, list) values ('default', '10.233.64.0/18,10.244.0.0/16');" -tikv-configs "{import: {num-threads: 12}}" -destroy-on-failure=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type tpcc -versions v5.3.0 -threads 40,60 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 10m -tidb-configs "{prepared-plan-cache.enabled: true}" -tidb-replicas 1
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type sysbench -bench-sub-types "oltp_read_write" -storage-url "s3://benchmark/sysbench-32-10000000" -db-name test -versions v5.3.0 -threads 40,60 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 10m -tidb-configs "{prepared-plan-cache.enabled: true}" -tidb-replicas 1  -warmup=false -staging=true
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type shenma -bench-sub-types "shenma_first_try" -storage-url "s3://bank/shenma-full-with-stats/" -versions nightly -threads 1 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 30m -tidb-configs "{prepared-plan-cache.enabled: true}" -tidb-replicas 1 -staging=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type tpcc -storage-url "s3://benchmark/tpcc-1000-new" -db-name tpcc -versions v5.3.0 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-replicas 1   -duration 20m staging true -stability true
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type tpch -bench-sub-types tpch-tikv-50g -storage-url "s3://benchmark/tpch50-release4.0" -db-name tpch50 -duration 20m -versions v5.3.0 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-replicas 1   -staging true
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type tpcds -bench-sub-types tpcds-tikv-50g -storage-url "s3://benchmark/tpcds50" -db-name tpcds50 -duration 20m -versions v5.2.2 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-replicas 1 -tikv-replicas 3 -queries query_1.sql,query_3.sql,query_6.sql,query_7.sql,query_8.sql,query_9.sql,query_10.sql,query_12.sql,query_13.sql,query_15.sql,query_16.sql,query_17.sql,query_19.sql,query_20.sql,query_21.sql,query_24_1.sql,query_24_0.sql,query_25.sql,query_26.sql,query_28.sql,query_29.sql,query_30.sql,query_31.sql,query_32.sql,query_33.sql,query_34.sql,query_35.sql,query_37.sql,query_40.sql,query_41.sql,query_42.sql,query_43.sql,query_44.sql,query_45.sql,query_46.sql,query_47.sql,query_48.sql,query_49.sql,query_50.sql,query_51.sql,query_52.sql,query_53.sql,query_54.sql,query_55.sql,query_56.sql,query_57.sql,query_58.sql,query_60.sql,query_61.sql,query_62.sql,query_63.sql,query_64.sql,query_65.sql,query_66.sql,query_68.sql,query_69.sql,query_71.sql,query_72.sql,query_73.sql,query_74.sql,query_75.sql,query_76.sql,query_79.sql,query_81.sql,query_82.sql,query_83.sql,query_84.sql,query_87.sql,query_88.sql,query_89.sql,query_90.sql,query_91.sql,query_92.sql,query_93.sql,query_94.sql,query_95.sql,query_96.sql,query_97.sql,query_98.sql,query_99.sql -staging false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type job -bench-sub-types job-tikv-50g -storage-url "s3://benchmark/imdb" -db-name imdb  -duration 20m -versions v5.2.2 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -queries 10a.sql,10b.sql,10c.sql,11a.sql,11b.sql,11c.sql,11d.sql,12a.sql,12b.sql,12c.sql,13a.sql,13b.sql,13c.sql,13d.sql,14a.sql,14b.sql,14c.sql,15a.sql,15b.sql,15c.sql,15d.sql,16a.sql,16b.sql,16c.sql,16d.sql,17a.sql,17b.sql,17c.sql,17d.sql,17e.sql,17f.sql,18a.sql,18b.sql,18c.sql,19a.sql,19b.sql,19c.sql,19d.sql,1a.sql,1b.sql,1c.sql,1d.sql,20a.sql,20b.sql,20c.sql,21a.sql,21b.sql,21c.sql,22a.sql,22b.sql,22c.sql,22d.sql,23a.sql,23b.sql,23c.sql,24a.sql,24b.sql,25a.sql,25b.sql,25c.sql,26a.sql,26b.sql,26c.sql,27a.sql,27b.sql,27c.sql,28a.sql,28b.sql,28c.sql,29a.sql,29b.sql,29c.sql,2a.sql,2b.sql,2c.sql,2d.sql,30a.sql,30b.sql,30c.sql,31a.sql,31b.sql,31c.sql,32a.sql,32b.sql,33a.sql,33b.sql,33c.sql,3a.sql,3b.sql,3c.sql,4a.sql,4b.sql,4c.sql,5a.sql,5b.sql,5c.sql,6a.sql,6b.sql,6c.sql,6d.sql,6e.sql,6f.sql,7a.sql,7b.sql,7c.sql,8a.sql,8b.sql,8c.sql,8d.sql,9a.sql,9b.sql,9c.sql,9d.sql -tidb-replicas 1 -tikv-replicas 3 -versions nightly -staging=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type bank -bench-sub-types "bank" -versions nightly -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-replicas 1  -tidb-configs "{prepared-plan-cache.enabled: true}"  -threads 100 -tikv-configs "{raftstore: {store-io-pool-size: 1}, raft-engine: {enable: true}}" -tikv-configs "{raftstore: {store-io-pool-size: 1}, raft-engine: {enable: false}}" -staging false
#tpcds tiflash
#KUBECONFIG=./kubeconfig.yml CGO_ENABLED=0 ginkgo -focus bench -- perftest -bench-type tpcds -bench-sub-types tpcds-tikv-50g -storage-url "s3://benchmark/tpcds50" -db-name tpcds50 -duration 20m -versions nightly -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-replicas 1  -tiflash-replicas 2  -staging=false
#KUBECONFIG=./kubeconfig.yml CGO_ENABLED=0  ginkgo -focus bench -- perftest -bench-type tpch -bench-sub-types "tpch-tikv-50g" -db-name test -versions nightly -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -threads 1 -tidb-replicas 1 -tikv-replicas 3  -tidb-globals "set global tidb_distsql_scan_concurrency = 30;set global tidb_executor_concurrency = 16;" -tidb-configs "{mem-quota-query: 64424509440}" -reserve-env 8h -staging=false