Re: Tracing in cassandra

2018-10-13 Thread Nitan Kainth
gt;>>>>> >>>>>>> Name text, >>>>>>> >>>>>>> Lastvisit date, >>>>>>> >>>>>>> Phone text, >>>>>>> >>>>>>> Primary key (customerid) ); >

Re: Tracing in cassandra

2018-10-12 Thread Abdul Patel
mit 5000; >>>> >>>> >>>> >>>> The query is asking for 5000 different partitions to be selected across >>>> the cluster. This is a very EXPENSIVE query for Cassandra, especially as >>>> the number of nodes goes up. Typically, you w

Re: Tracing in cassandra

2018-10-12 Thread Nitan Kainth
;>>>> Phone text, >>>>> >>>>> Primary key (customerid) ); >>>>> >>>>> >>>>> >>>>> Query >>>>> >>>>> Select customerid from customer limit 5000; >>>>>

Re: Tracing in cassandra

2018-10-12 Thread Abdul Patel
erid from customer limit 5000; >>> >>> >>> >>> The query is asking for 5000 different partitions to be selected across >>> the cluster. This is a very EXPENSIVE query for Cassandra, especially as >>> the number of nodes goes up. Typically, you want t

Re: Tracing in cassandra

2018-10-12 Thread Abdul Patel
are selecting >> many partitions or a very large partition. That is why a schema for the >> involved table could help. >> >> >> >> >> >> Sean Durity >> >> >> >> *From:* Abdul Patel >> *Sent:* Friday, October 12, 2018 10

Re: [EXTERNAL] Re: Tracing in cassandra

2018-10-12 Thread Nitan Kainth
> number of nodes goes up. Typically, you want to query a single partition. >> Read timeouts are usually caused by queries that are selecting many >> partitions or a very large partition. That is why a schema for the involved >> table could help. >> >> >&

Re: [EXTERNAL] Re: Tracing in cassandra

2018-10-12 Thread Abdul Patel
partition. That is why a schema for the > involved table could help. > > > > > > Sean Durity > > > > *From:* Abdul Patel > *Sent:* Friday, October 12, 2018 10:04 AM > *To:* user@cassandra.apache.org > *Subject:* [EXTERNAL] Re: Tracing in cassandra > >

Re: Tracing in cassandra

2018-10-12 Thread Abdul Patel
t; > *From:* Abdul Patel > *Sent:* Thursday, October 11, 2018 5:54 PM > *To:* a...@instaclustr.com > *Cc:* user@cassandra.apache.org > *Subject:* [EXTERNAL] Re: Tracing in cassandra > > > > Query : > > SELECT * FROM keysoace.tablenameWHERE user_id = 390797583

Re: Tracing in cassandra

2018-10-11 Thread Adam Zegelin
Hi Abdul, Can you post the timeout error and also the trace output? The trace output is detailed, but often refers to Cassandra internals. If we can see the error and the trace it'd be easier to pin-point the problem. - Adam On Thu, 11 Oct 2018 at 08:53, Abdul Patel wrote: > Hi, > > We have

Tracing in cassandra

2018-10-11 Thread Abdul Patel
Hi, We have multiple timeouts with select queries. I ran trace to see why its timing out ..do we jave a good document to interpretate whats causing the queries to timeout?