[ 
https://issues.apache.org/jira/browse/CASSANDRA-11459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15217393#comment-15217393
 ] 

Jeff Jirsa commented on CASSANDRA-11459:
----------------------------------------

2.0.x isn't supported anymore, but it sounds like CASSANDRA-9754 . 

> cassandra performance problem when streaming large data 
> --------------------------------------------------------
>
>                 Key: CASSANDRA-11459
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11459
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: ubuntu 14.04, 3 nodes in each datacenter,
> 1g networking, each node has 128G ram, 3*300G SSD in RAID5, dual E5-2620v3 
> processors
>            Reporter: Yan Cui
>
> We found the problem on Cassandra 2.0.15, and have not tested on other 
> versions.
> there is one core table, and the schema is 
> [user_id int, device_token text, deleted bool, device_info map<text, text>, 
> human_code text]   
> user_id and device token is the primary key, and user_id is the partition key,
> we have the statement that caused latency spike (3500ms to 4000 ms).
> select * from table where user_id = <hotuserid>.   the hotuserid has roughly 
> 80000 rows. On average, there is 200 bytes for each row. We feel this should 
> be slow because of more results out there, but it is not expected to be that 
> slow.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to