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 jji...@gmail.com wrote Column

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

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 onmstes...@zoho.com wrote I've increased column_index_size_in_kb to 512 and then 4096 : no change in response time, it even got

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 j...@jonhaddad.com wrote What disks are you using? How many sstables

Question About Reaper

Hi, We have a cluster with 144 nodes( 3 datacenter) with 256 Vnodes . When we tried to start repairs from opscenter then it showed 1.9Million ranges to repair . And even after doing compaction and strekamthroughput to 0 , opscenter is not able to help us much to finish repair in 9 days timeframe

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

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

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