7019-none.yaml

# Performance Testing
# Small Row

keyspace: keyspace1

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

table: standard1

table_definition: |
  CREATE TABLE keyspace1.standard1 (
    key blob,
    c0 blob,
    c1 blob,
    c2 blob,
    c3 blob,
    c4 blob,
    PRIMARY KEY (key, c0)
  ) WITH bloom_filter_fp_chance = 0.01
      AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
      AND comment = ''
      AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'provide_overlapping_tombstones': 'NONE', 'log_all': true}
      AND compression = {'enabled': 'false'}
      AND crc_check_chance = 1.0
      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 = '99PERCENTILE';


insert:
  partitions: fixed(1)
  select: fixed(1)/1
  batchtype: UNLOGGED
  
columnspec:
  - name: c0
    cluster: gaussian(1..5)

queries:
  read:
    cql: select * from standard1 where key = ?
    fields: samerow
  rowdelete:
    cql: DELETE FROM standard1 where key = ? and c0 = ?
    fields: samerow
  delete:
    cql: DELETE FROM standard1 where key = ?
    fields: samerow
  columndelete:
    cql: INSERT INTO standard1 (key, c0, c1, c2, c3, c4) VALUES (?, ?, null, ?, ?, ?)
    fields: samerow