如何校准Cassandra应力图选项?

8nuwlpux  于 2021-06-10  发布在  Cassandra
关注(0)|答案(1)|浏览(382)

我设法在集群外运行压力工具。一个;在我的cassa集群上的bank keyspace中准备好了基本表bank\u事务。
bank.bank_事务(customerid text,year int,month int,id timeuuid,amount int,card text,status text,主键((customerid,year,month),id));这是我的个人资料yaml文件:

table: bank_transactions

columnspec:
  - name: customerid
    size: uniform(5..10)
    population: uniform(1..10)
  - name: year
    size: fixed(4)
  - name: month
    size: fixed(2)
  - name: timeuuid
    cluster: uniform(20..40)
  - name: amount
    size: uniform(0..1000000)
  - name: text
    size: uniform(10..15)
  - name: status
    size: uniform(10..20)

insert:
    # How many partition to insert per batch
  partitions: fixed(2)
    # How many rows to update per partition
  select: fixed(1)/500
    # UNLOGGED or LOGGED batch for insert
  batchtype: UNLOGGED

queries:
   customer:
      cql: select *  from bank_transactions where customerid = ? and year = ? and month = ? and id = ?
      fields: multirow

# com.datastax.driver.core.exceptions.InvalidQueryException:

# Partition key parts: year, month, id, customerid must be restricted as other parts are

   transactions:
      cql: select customerid, amount, card, status, id from bank_transactions where id = ? and customerid = ? and year = ? and month = ? 
      fields: samerow
   regularupdate:
      cql: update bank_transactions set amount = ? where customerid = ? and year = ? and month = ? and id = ?
      fields: samerow

# nestihalo se v casovem limitu, lze navysit pamet, casovy limit...

# updatewithlwt:

# cql: update bank_transactions set amount = ? where customerid = ? and year = ? and month = ? and id = ? IF status = ?

# fields: samerow

我承受着压力

./cassandra-stress user profile=./stress_transactions.yaml ops\(insert=3,customer=3,transactions=2,regularupdate=1\) \
n=10000 -node 172.16.20.104,172.16.20.105,172.16.20.106 -port native=9042 thrift=9160 jmx=7199 -graph file=./transactions.html

我希望在cassandra.apache网站上有类似于graph的东西

但结果真的很奇怪:

你能帮帮我吗,出什么事了?
p、 别介意分配等等,那只是个Playground。。。

9cbw7uwe

9cbw7uwe1#

在另一个游戏时间之后,我设置了n=1000000(没有其他变化),结果要好得多。

希望对某人有所帮助;)

相关问题