[ https://issues.apache.org/jira/browse/CASSANDRA-9607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14598061#comment-14598061 ]
Tyler Hobbs commented on CASSANDRA-9607: ---------------------------------------- [~study] what sort of queries do you perform on the {{ginger.supply_ad_log}} table? Just looking at the heap dump, it looks like you're doing something like {{SELECT * FROM ginger.supply_ad_log}} without paging and with no limit on the query. The results for just one small token range include 150,000+ cells. > Get high load after upgrading from 2.1.3 to cassandra 2.1.6 > ----------------------------------------------------------- > > Key: CASSANDRA-9607 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9607 > Project: Cassandra > Issue Type: Bug > Environment: OS: > CentOS 6 * 4 > Ubuntu 14.04 * 2 > JDK: Oracle JDK 7, Oracle JDK 8 > VM: Azure VM Standard A3 * 6 > RAM: 7 GB > Cores: 4 > Reporter: Study Hsueh > Assignee: Tyler Hobbs > Priority: Critical > Fix For: 2.1.x, 2.2.x > > Attachments: GC_state.png, cassandra.yaml, client_blocked_thread.png, > cpu_profile.png, dump.tdump, load.png, log.zip, schema.zip, vm_monitor.png > > > After upgrading cassandra version from 2.1.3 to 2.1.6, the average load of my > cassandra cluster grows from 0.x~1.x to 3.x~6.x. > What kind of additional information should I provide for this problem? -- This message was sent by Atlassian JIRA (v6.3.4#6332)