Cassandra stress config

stress.yml

### DML ###
keyspace: stress

keyspace_definition: |
  CREATE KEYSPACE stress WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};

table: messages

table_definition: |
  CREATE TABLE stress.messages (
    chat_id bigint,
    uid_to bigint,
    message_id bigint,
    text blob,
    uid blob,
    PRIMARY KEY ((chat_id, uid_to), message_id)
  ) WITH CLUSTERING ORDER BY (message_id ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
    AND comment = ''
    AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32'}
    AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99.0PERCENTILE';

columnspec:

  - name: text
    size: gaussian(0..44)

  - name: uid
    size: gaussian(0..32)

  - name: chat_id
    size: uniform(0..64)
    population: uniform(500..2K)

  - name: uid_to
    size: uniform(0..64)
    population: uniform(500..2K)

  - name: message_id
    size: uniform(0..64)

insert:
  myinsert:
    partitions: fixed(1)
    batchtype:  UNLOGGED
    select:     fixed(1)/1

queries:
  scan:
    cql: select * from stress.messages where chat_id = ? and uid_to = ? and message_id > ? limit 50;
    fields: samerow