cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From André Cruz <andre.c...@co.sapo.pt>
Subject Re: Strange delay in query
Date Wed, 07 Nov 2012 00:34:29 GMT
Can anyone shed some light on this matter, please? I don't want to just increase the timeout
without understanding why this is happening. Some pointer for me to investigate would be helpful.

I'm running Cassandra 1.1.5 and these are wide rows (lots of small columns). I would think
that fetching the first 34 columns would be fast, and just a little bit slower than 33 columns,
but this is a big difference.

Thank you and best regards,
André Cruz

On Nov 6, 2012, at 2:43 PM, André Cruz <andre.cruz@co.sapo.pt> wrote:

> Hello.
> 
> I have a SCF that is acting strange. See these 2 query times:
> 
> 
> get NamespaceRevision[3cd88d97-ffde-44ca-8ae9-5336caaebc4e] limit 33;
> ...
> Returned 33 results.
> Elapsed time: 41 msec(s).
> 
> get NamespaceRevision[3cd88d97-ffde-44ca-8ae9-5336caaebc4e] limit 34;
> ...
> Returned 34 results.
> Elapsed time: 3569 msec(s).
> 
> 
> What can be the cause of this delay? I have a 3 node cluster with a replication factor
of 3, so all of the nodes should have a copy of the data.
> 
> -> describe cluster;
> Cluster Information:
>   Snitch: org.apache.cassandra.locator.PropertyFileSnitch
>   Partitioner: org.apache.cassandra.dht.RandomPartitioner
>   Schema versions: 
> 	a354e01a-d342-3755-9821-c550dcd1caba: [zzz, yyy, xxx]
> 
> 
> Is there more information that I can provide?
> 
> Best regards,
> André Cruz


Mime
View raw message