Re: Reading from big partitions

Data spread between a SSD disk and a 15K disk. the table has 26 tables totally. I haven't try tracing, but i will and inform you! Sent using Zoho Mail On Sun, 20 May 2018 08:26:33 +0430 Jonathan Haddad wrote What disks are you using? How many sstables a

Re: Reading from big partitions

I've increased column_index_size_in_kb to 512 and then 4096 : no change in response time, it even got worse. Even increasing Key cache size and Row cache size did not help. Sent using Zoho Mail On Sun, 20 May 2018 08:52:03 +0430 Jeff Jirsa wrote Column in

Re: Reading from big partitions

Should i run compaction after changing column_index_size_in_kb? Sent using Zoho Mail On Sun, 20 May 2018 15:06:57 +0430 onmstester onmstester wrote I've increased column_index_size_in_kb to 512 and then 4096 : no change in response time, it even got wor

IN clause of prepared statement

The table is something like Samples ... partition key (partition,resource,(timestamp,metric_name) creating prepared statement : session.prepare("select * from samples where partition=:partition and resource=:resource and timestamp>=:start and timestamp<=:end and metric_name in :metric_n

Re: Question About Reaper

Hi, I recently tested reaper and it actually helped us alot. Even with our small footprint 18 node reaper takes close to 6 hrs.. But it really depends on number nodes. For example if you have 4 nodes then it runs on 4*256 =1024 segements , so for your env. Ut will be 256*144 close to 36k segements

Re: Question About Reaper

FWIW the largest deployment I know about is a single reaper instance managing 50 clusters and over 2000 nodes. There might be bigger, but I either don’t know about it or can’t remember. On Sun, May 20, 2018 at 10:04 AM Abdul Patel wrote: > Hi, > > I recently tested reaper and it actually helped

RE: dtests failing with - ValueError: unsupported hash type md5

This Issue resolved:   Since I only had Python 3.6 installed on my machine cqlsh was referring to some default location when it tried to call python2.7 libraries. Obviously these libraries did not have all the dependencies installed for cqlsh.   In order to make a valid environment for cqlsh

Resource Intensive and Upgrade tests (Dtest Cassandra)

Hi All, We have setup a dtest environment to run against Cassandra db version 3.11.1 and 3.0.5 During the test run we see that tests under the category of Resource intensive and Upgrade tests Are skipped by default during the collection phase. And this is a huge number (1100+ out of th

Re: Question About Reaper

Thanks a lot for your inputs, Abdul, how did u tune reaper? On Sun, May 20, 2018 at 10:10 AM Jonathan Haddad wrote: > FWIW the largest deployment I know about is a single reaper instance > managing 50 clusters and over 2000 nodes. > > There might be bigger, but I either don’t know about it or ca