Skip to content

Instantly share code, notes, and snippets.

@sbtourist

sbtourist/largebatches.yaml

Last active November 27, 2023 17:31
Show Gist options
  • Save sbtourist/a281e9ae7520712ea308d7d28c8547bb to your computer and use it in GitHub Desktop.
Save sbtourist/a281e9ae7520712ea308d7d28c8547bb to your computer and use it in GitHub Desktop.
Download ZIP
largebatches.yaml
Raw
largebatches.yaml
description: |
A key-value workload with batches over large values to test large batches
bindings:
rw_key: TEMPLATE(keydist,Uniform(0,1000000000));
large_rw_value: Hash(); TEMPLATE(valdist,Uniform(0,1000000000)); CharBufImage('A-Za-z0-9 _|/',16000000,HashRange(TEMPLATE(mintext,250000)TEMPLATE(addzeros,),TEMPLATE(maxtext,500000)TEMPLATE(addzeros,))); ToString();
blocks:
- tags:
phase: schema
type: create-keyspace
params:
prepared: false
statements:
- create-keyspace: |
create keyspace if not exists TEMPLATE(keyspace,baselines)
WITH replication = {'class': 'NetworkTopologyStrategy', 'replication_factor': 'TEMPLATE(rf,3)'}
AND durable_writes = true;
- tags:
phase: schema
type: create-table
params:
prepared: false
statements:
- create-table: |
create table if not exists TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (
pkey bigint,
ckey bigint,
value text,
PRIMARY KEY (pkey, ckey)
);
- tags:
phase: truncate
params:
prepared: false
statements:
- truncate-table: |
truncate table TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue);
- tags:
phase: write-batch
params:
cl: TEMPLATE(write_cl,LOCAL_QUORUM)
statements:
- batch: |
BEGIN UNLOGGED BATCH
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (1,1,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (2,2,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (3,3,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (4,4,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (5,5,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (6,6,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (7,7,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (8,8,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (9,9,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (10,10,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (11,11,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (12,12,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (13,13,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (14,14,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (15,15,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (16,16,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (17,17,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (18,18,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (19,19,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (20,20,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (21,21,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (22,22,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (23,23,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (24,24,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (25,25,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (26,26,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (27,27,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (28,28,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (29,29,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (30,30,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (31,31,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (32,32,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (33,33,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (34,34,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (35,35,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (36,36,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (37,37,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (38,38,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (39,39,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (40,40,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (41,41,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (42,42,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (43,43,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (44,44,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (45,45,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (46,46,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (47,47,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (48,48,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (49,49,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (50,50,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (51,51,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (52,52,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (53,53,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (54,54,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (55,55,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (56,56,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (57,57,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (58,58,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (59,59,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (60,60,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (61,61,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (62,62,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (63,63,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (64,64,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (65,65,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (66,66,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (67,67,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (68,68,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (69,69,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (70,70,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (71,71,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (72,72,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (73,73,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (74,74,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (75,75,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (76,76,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (77,77,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (78,78,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (79,79,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (80,80,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (81,81,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (82,82,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (83,83,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (84,84,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (85,85,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (86,86,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (87,87,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (88,88,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (89,89,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (90,90,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (91,91,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (92,92,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (93,93,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (94,94,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (95,95,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (96,96,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (97,97,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (98,98,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (99,99,{large_rw_value});
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,ckeyvalue) (pkey, ckey, value) values (100,100,{large_rw_value});
APPLY BATCH;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment