Re: Help debugging a very slow query

2016-01-13 Thread Robert Coli
On Wed, Jan 13, 2016 at 12:40 PM, Bryan Cheng wrote: > 1) What's up with the megapartition? What's the best way to debug this? > Our data model is largely write once, we don't do any updates. We do > DELETE, but the partitions that are giving us issues haven't been removed. > We had some suspicio

Re: Help debugging a very slow query

2016-01-13 Thread Jeff Jirsa
;user@cassandra.apache.org" Date: Wednesday, January 13, 2016 at 12:40 PM To: "user@cassandra.apache.org" Subject: Help debugging a very slow query Hi list, Would appreciate some insight into some irregular performance we're seeing. We have a column family that has be

Help debugging a very slow query

2016-01-13 Thread Bryan Cheng
Hi list, Would appreciate some insight into some irregular performance we're seeing. We have a column family that has become problematic recently. We've noticed a few queries take enormous amounts of time, and seem to clog up read resources on the machine (read pending tasks pile up, then immedia