首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何校准cassandra-stress图选项?

如何校准cassandra-stress图选项?
EN

Stack Overflow用户
提问于 2019-04-16 20:58:46
回答 1查看 167关注 0票数 0

我设法在集群之外运行了压力工具。我已经在cassa集群的bank关键字空间中准备好了基本的表bank_transactions。

bank.bank_transactions ( customerid文本,年份int,月份int,id timeuuid,金额int,卡片文本,状态文本,主键((customerid,年,月),id) );这是我的资料yaml文件:

代码语言:javascript
复制
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

我的压力很大

代码语言:javascript
复制
./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站点上有一些类似于图形的东西

但结果真的很奇怪:

你能帮帮我吗,出什么事了?

另外,不要介意发行版本等等,它只是一个游乐场…

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-04-16 21:59:32

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

希望能对某些人有所帮助;)

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/55708768

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档