#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type benchmarksql -versions nightly -arch arm64 -threads 100 -duration=10m -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
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type hzbank -versions v5.3.0 -arch arm64 -threads 3 -duration=10m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-configs "{abcprepared-plan-cache: {enabled: true}}"  -tikv-configs "{abcprepared-plan-cache: {enabled: true}}" -tidb-replicas 1 -jdbc "?useServerPrepStmts=true&cachePrepStmts=true&useConfig=maxPerformance" -tidb-globals "alter table heronsdb1.pm_spma_bank_para cache; alter table heronsdb1.pm_spma_base_code cache; alter table heronsdb1.pm_spma_calendar_para cache; alter table heronsdb1.pm_spma_currency_para cache; alter table heronsdb1.pm_spma_serial_record cache; alter table heronsdb1.pm_spma_summary_para cache; alter table heronsdb1.pm_spma_system_para cache;" -staging=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type corebanking -versions v5.3.0 -arch arm64 -threads 3 -duration=10m -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 -jdbc "?useServerPrepStmts=true&cachePrepStmts=true&useConfig=maxPerformance" -staging=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type apdogfood -versions v5.3.0 -duration=120m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-replicas 1 -tiflash-replicas 2 -mysql-ignore-errors 2013 -arch arm64 -tidb-globals "set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'" -staging=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type shenma -bench-sub-types "shenma_first_try" -storage-url "s3://bank/shenma-full-with-stats/" -arch arm64 -versions nightly -threads 5 -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 benchmarksql -versions nightly -arch arm64 -threads 100 -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}}" -jdbc "?serverTimezone=UTC&characterEncoding=utf-8&useServerPrepStmts=true&cachePrepStmts=true&useConfig=maxPerformance?useSSL=false&rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull" --tidb-replicas 1 -staging=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 -- perftest -bench-type sysbench -arch arm64 -bench-sub-types "oltp_read_write" -versions v5.2.1 -threads 40 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -duration 1000m -tidb-configs "{prepared-plan-cache.enabled: true}" -tidb-globals "set global tidb_stats_load_sync_wait=9999;set global tidb_enable_pseudo_for_outdated_stats=off;set global tidb_distsql_scan_concurrency = 16;set global tidb_executor_concurrency = 16;" -tidb-replicas 3 -mysql-ignore-errors 2013 -ignore-config-check=true
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type sysbench -arch arm64 -bench-sub-types "oltp_read_write" -versions v5.2.1 -threads 40 -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-globals "set global tidb_stats_load_sync_wait=9999;set global tidb_enable_pseudo_for_outdated_stats=off;set global tidb_distsql_scan_concurrency = 16;set global tidb_executor_concurrency = 16;" -tikv-configs "{raftstore: {store-io-pool-size: 1}, raft-engine: {enable: true}}" -tidb-replicas 3 -mysql-ignore-errors 2013
#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  -mysql-ignore-errors 2013 -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 20 -duration=10m -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  -mysql-ignore-errors 2013 -arch arm64 -staging=false -warmup=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type apdogfood -versions nightly -duration=60m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-replicas 1 -tiflash-replicas 2 -mysql-ignore-errors 2013 -tidb-urls "http://fileserver.pingcap.net/download/builds/pingcap/tidb-check/pr/c3efa75d8ae993b1f43683a123c438df8cc30543/centos7/tidb-server.tar.gz" -arch arm64 -staging=false
#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 nightly -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"
#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_read_write" -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  -mysql-ignore-errors 2013
#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 -versions nightly -arch arm64 -threads 1 -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local" -tidb-globals "xyz" -duration 30m -tidb-configs "{prepared-plan-cache.enabled: true}" -tidb-replicas 1 -staging=false -reset-env=false
#KUBECONFIG=./kubeconfig.yml ginkgo -focus bench -- perftest -bench-type apdogfood -versions v5.3.0 -duration=120m -dsn "perfdata:g2dmtGjk@tcp(172.16.4.36:3306)/perfdata?charset=utf8mb4&parseTime=True&loc=Local"  -tidb-replicas 1 -tiflash-replicas 2 -tidb-configs "{log.slow-threshold: 0}" -arch arm64 -tidb-globals "set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'" -staging=false -reset-env=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