Re: write latency on single partition table

The size is less than 50MB Sent using Zoho Mail On Sat, 07 Apr 2018 09:09:41 +0430 Laxmikant Upadhyay wrote It seems your partition size is more..what is the size of value field ? Try to keep your partition size within 100 mb. On Sat, Apr 7, 2018

Re: write latency on single partition table

It seems your partition size is more..what is the size of value field ? Try to keep your partition size within 100 mb. On Sat, Apr 7, 2018, 9:45 AM onmstester onmstester wrote: > > I've defained a table like this > > create table test ( > hours int, > key1 int, > value1 varchar, > primary key (h

write latency on single partition table

I've defained a table like this create table test ( hours int, key1 int, value1 varchar, primary key (hours,key1) ) For one hour every input would be written in single partition, because i need to group by some 500K records in the partition for a report with expected response time in

Re: How to restrict users to specific DC.

Thanks Jim for your reply, > ... just in case even he change his contact points he shouldn't be able execute queries on DC2. What I mean was we have 2 DC only 1 serving traffic, Let's say an individual user wants to run a query from cqlsh/Devcenter on DC serving requests, I want to prevent it.

Re: How to restrict users to specific DC.

Pranay, > Is it possible to restrict users to specific DC in cassandra, let's say an > user A is connecting to DC1 and executing queries, how to can I restrict that > user to that particular DC... This part sounds like a job for a DC-aware load-balancing policy in the driver. > ... just in ca

How to restrict users to specific DC.

Hi all, Is it possible to restrict users to specific DC in cassandra, let's say an user A is connecting to DC1 and executing queries, how to can I restrict that user to that particular DC, just in case even he change his contact points he shouldn't be able execute queries on DC2. Is it something

Re: tablestats and gossip

Yes, its the count of all locally applied writes to that table. A insert to a table with a RF=3 should increase the local write count by 1 on 3 different nodes. Chris > On Apr 6, 2018, at 5:00 AM, Grzegorz Pietrusza wrote: > > Hi all > > Does local write count provided by tablestats include

Re: Cassandra Table "Rename"

No, it’s a standard method for renaming tables/kespaces. For Cassandra datafiles can be renamed, as long as table definition and path is correct and version is same. Sent from my iPhone > On Apr 6, 2018, at 5:58 AM, Marcel Villet wrote: > > Hi All > > I did an experiment whereby I recreated

Cassandra Table "Rename"

Hi All I did an experiment whereby I recreated a table but with a different name and copied the original sstable files to the sstable directory of the new table. When I queried the new table the old data was shown. So it looks like this trick worked. Are there any caveats with copying data thi

tablestats and gossip

Hi all Does local write count provided by tablestats include writes from gossip?

Re: Shifting data to DCOS

Without looking at the code I'd say maybe the keyspaces are displayed purely because the directories exist (but it seems unlikely). The process you should follow instead is to exclude the system keyspaces for each node and manually apply your schema, then upload your CFs into the correct directory.

Re: Upgrade to 3.11.2 disabled JMX

Hi Lucas, There are usually some logs in system.log at node startup regarding JMX initialization, are those OK ? On 5 April 2018 at 22:13, Lucas Benevides wrote: > Dear community members, > > I have just upgraded my Cassandra from version 3.11.1 to 3.11.2. I kept my > previous configuration fil

Re: Shifting data to DCOS

Michael, both of the folders are with hash, so I dont think that would be an issue. What is strange is why the tables dont show up if the keyspaces are visible. Shouldnt that be a meta data that can be edited once and then be visible? Affan - Affan On Thu, Apr 5, 2018 at 7:55 PM, Michael Shule