Skip to content

sql: A 2m long 2s latency spike during online primary key changes with TPCC #44501

@awoods187

Description

@awoods187

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);

image

version V20.1.0-ALPHA.20191118-1665-GABBE4BC
cluster andy-3node

Metadata

Metadata

Labels

C-investigationFurther steps needed to qualify. C-label will change.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions