cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Johnson <matt.john...@algomi.com>
Subject RE: unsubscribe
Date Wed, 22 Apr 2015 14:40:36 GMT
Hi Bill,



To remove your address from the list, send a message to:

   <user-unsubscribe@cassandra.apache.org>



Cheers,

Matt





*From:* Bill Tsay [mailto:btsay@splunk.com]
*Sent:* 22 April 2015 15:36
*To:* user@cassandra.apache.org
*Subject:* unsubscribe







*From: *Mich Talebzadeh <mich@peridale.co.uk>
*Reply-To: *"user@cassandra.apache.org" <user@cassandra.apache.org>
*Date: *Wednesday, April 22, 2015 at 3:06 AM
*To: *"user@cassandra.apache.org" <user@cassandra.apache.org>
*Subject: *RE: ROperationTimedOut in selerct count statement in cqlsh



Thanks Umang.



I have 9GB of memory free here out of 24GB



cassandra@rhes564::/apps/cassandra> free

             total       used       free     shared    buffers     cached

Mem:      24675328   14774532    9900796          0     539900    9097992

-/+ buffers/cache:    5136640   19538688

Swap:     24579440        668   24578772



But I am still getting the same error



cqlsh:ase> select count(1) from t;

OperationTimedOut: errors={}, last_host=127.0.0.1



thx



Mich Talebzadeh



http://talebzadehmich.wordpress.com



Author of the books* "A Practitioner’s Guide to Upgrading to Sybase ASE
15", ISBN 978-0-9563693-0-7*.

co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN
978-0-9759693-0-4*

*Publications due shortly:*

*Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and
Coherence Cache*

*Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4,
volume one out shortly



NOTE: The information in this email is proprietary and confidential. This
message is for the designated recipient only, if you are not the intended
recipient, you should destroy it immediately. Any information in this
message shall not be understood as given or endorsed by Peridale Ltd, its
subsidiaries or their employees, unless expressly so stated. It is the
responsibility of the recipient to ensure that this email is virus free,
therefore neither Peridale Ltd, its subsidiaries nor their employees accept
any responsibility.



*From:* Umang Shah [mailto:shahumang4@gmail.com <shahumang4@gmail.com>]
*Sent:* 22 April 2015 10:44
*To:* user@cassandra.apache.org
*Subject:* Re: ROperationTimedOut in selerct count statement in cqlsh



HI,



It is common problem, if your machine has 4 GB of RAM then you can only
retrieve records about 200000 so you have to increase the RAM of your
system to avoid this problem..



Thanks,

Umang Shah



On Wed, Apr 22, 2015 at 9:34 AM, Mich Talebzadeh <mich@peridale.co.uk>
wrote:

Hi,



I have a table of 300,000 rows.



When I try to do a simple



cqlsh:ase> select count(1) from t;

OperationTimedOut: errors={}, last_host=127.0.0.1



Appreciate any feedback



Thanks,



Mich





NOTE: The information in this email is proprietary and confidential. This
message is for the designated recipient only, if you are not the intended
recipient, you should destroy it immediately. Any information in this
message shall not be understood as given or endorsed by Peridale Ltd, its
subsidiaries or their employees, unless expressly so stated. It is the
responsibility of the recipient to ensure that this email is virus free,
therefore neither Peridale Ltd, its subsidiaries nor their employees accept
any responsibility.







-- 

Regards,

Umang Shah

+919886829019

Mime
View raw message