-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: A 2m long 2s latency spike during online primary key changes with TPCC #44501
Copy link
Copy link
Closed
Labels
C-investigationFurther steps needed to qualify. C-label will change.Further steps needed to qualify. C-label will change.
Description
Cluster setup for testing online primary key changes during TPC-C.
roachprod create $CLUSTER -n 4 --clouds=aws --aws-machine-type-ssd=c5d.4xlarge
roachprod stage $CLUSTER:1-3 cockroach
roachprod stage $CLUSTER:4 workload
roachprod start $CLUSTER:1-3
roachprod adminurl --open $CLUSTER:1
roachprod run $CLUSTER:1 -- "./cockroach workload fixtures import tpcc --warehouses=2500 --db=tpcc"
roachprod run $CLUSTER:4 "./workload run tpcc --ramp=5m --warehouses=2500 --active-warehouses=2000 --duration=15m --split --scatter {pgurl:1-3}"In another window:
set experimental_enable_primary_key_changes =true;
ALTER TABLE customer ALTER COLUMN c_city set not null;
ALTER TABLE customer ALTER PRIMARY KEY USING COLUMNS (c_city, c_w_id ASC, c_d_id ASC, c_id ASC);version V20.1.0-ALPHA.20191118-1665-GABBE4BC
cluster andy-3node
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-investigationFurther steps needed to qualify. C-label will change.Further steps needed to qualify. C-label will change.
