Re: Timeout for only one keyspace in cluster

2018-07-23 Thread learner dba
, 10:44:29 PM CDT, wxn...@zjqunshuo.com wrote: Your partition key is foreignid. You may have a large partition. Why not use foreignid+timebucket as partition key? From: learner dbaDate: 2018-07-19 01:48To: User cassandra.apache.orgSubject:  Timeout for only one keyspace

Re: Timeout for only one keyspace in cluster

2018-07-23 Thread Jonathan Haddad
42510 > any thing else that we can check? > > On Wednesday, July 18, 2018, 10:44:29 PM CDT, wxn...@zjqunshuo.com < > wxn...@zjqunshuo.com> wrote: > > > Your partition key is foreignid. You may have a large partition. Why not > use foreignid+timebucket as par

Re: Timeout for only one keyspace in cluster

2018-07-23 Thread learner dba
James, Yes, counter is implemented due to valid reasons. We need this value column to  have unique values being used at the time of registering new devices.On Monday, July 23, 2018, 10:07:54 AM CDT, James Shaw wrote: does your application really need counter ?  just an option. Thanks,

Re: Timeout for only one keyspace in cluster

2018-07-23 Thread James Shaw
00 88.15 0.00 7007506 > 42510 > any thing else that we can check? > > On Wednesday, July 18, 2018, 10:44:29 PM CDT, wxn...@zjqunshuo.com < > wxn...@zjqunshuo.com> wrote: > > > Your partition key is foreignid. You may have a

Re: Timeout for only one keyspace in cluster

2018-07-23 Thread learner dba
Thanks a lot Ben. This makes sense but feel bad that we don't have a solution yet. We can try consistency level one but that will be against general rule for having local_quorum for production. Also, consistency ONE will not guarantee 0 race condition. Is there any better solution? On Satur

Re: Timeout for only one keyspace in cluster

2018-07-23 Thread learner dba
Goutham, How will it make any difference? Could you please elaborate? On Saturday, July 21, 2018, 8:20:31 PM CDT, Goutham reddy wrote: Hi,As it is a single partition key, try to update the key with only partition key instead of passing other columns. And try to set consistency level ON

Re: Timeout for only one keyspace in cluster

2018-07-21 Thread Ben Slater
; Max 0.00 88.15 0.00 7007506 >> 42510 >> any thing else that we can check? >> >> On Wednesday, July 18, 2018, 10:44:29 PM CDT, wxn...@zjqunshuo.com < >> wxn...@zjqunshuo.com> wrote: >> >> >&

Re: Timeout for only one keyspace in cluster

2018-07-21 Thread Goutham reddy
42510 > any thing else that we can check? > > On Wednesday, July 18, 2018, 10:44:29 PM CDT, wxn...@zjqunshuo.com < > wxn...@zjqunshuo.com> wrote: > > > Your partition key is foreignid. You may have a large partition. Why not > use foreignid+timebucket as partition k

Re: Timeout for only one keyspace in cluster

2018-07-20 Thread learner dba
Anybody has any ideas about this? This is happening in production and we really need to fix it. On Thursday, July 19, 2018, 10:41:59 AM CDT, learner dba wrote: Our foreignid is unique idetifier and we did check for wide partitions; cfhistorgrams show all partitions are evenly sized:

Re: Timeout for only one keyspace in cluster

2018-07-19 Thread learner dba
Our foreignid is unique idetifier and we did check for wide partitions; cfhistorgrams show all partitions are evenly sized: Percentile  SSTables     Write Latency      Read Latency    Partition Size        Cell Count                               (micros)          (micros)           (bytes)  

Re: Timeout for only one keyspace in cluster

2018-07-18 Thread wxn...@zjqunshuo.com
Your partition key is foreignid. You may have a large partition. Why not use foreignid+timebucket as partition key? From: learner dba Date: 2018-07-19 01:48 To: User cassandra.apache.org Subject: Timeout for only one keyspace in cluster Hi, We have a cluster with multiple keyspaces. All

Timeout for only one keyspace in cluster

2018-07-18 Thread learner dba
Hi, We have a cluster with multiple keyspaces. All queries are performing good but write operation on few tables in one specific keyspace gets write timeout. Table has counter column and counter update query times out always. Any idea? CREATE TABLE x.y (     foreignid uuid,     timebucket text