RE: Finding big rows

2011-05-11 Thread Meler Wojciech
in it. Any ideas what to check next? Regards, Wojtek From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Wednesday, May 11, 2011 12:29 AM To: user@cassandra.apache.org Subject: Re: Finding big rows I'm not aware of anything to find the row sizes, and your code looks like a good approach

Re: Finding big rows

2011-05-11 Thread aaron morton
what to check next? Regards, Wojtek From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Wednesday, May 11, 2011 12:29 AM To: user@cassandra.apache.org Subject: Re: Finding big

RE: Finding big rows

2011-05-11 Thread Meler Wojciech
reading SliceFromReadCommand with the big row key. Switching to IRC... Regards, Wojtek From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Wednesday, May 11, 2011 12:20 PM To: user@cassandra.apache.org Subject: Re: Finding big rows Couple of questions to ask. You may also get some value from

Re: Finding big rows

2011-05-11 Thread Peter Schuller
What is the best way to find keys of such big rows? One, if not necessarily the best, way is to check system.log for large row warnings that trigger for rows large enough to be compacted lazily. Grep for 'azy' (or lazy case-insens) and you should find it. -- / Peter Schuller

Re: Finding big rows

2011-05-11 Thread aaron morton
. Switching to IRC… Regards, Wojtek From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Wednesday, May 11, 2011 12:20 PM To: user@cassandra.apache.org Subject: Re: Finding big rows Couple of questions to ask. You may also get some value from the #cassandra chat room where you can

Finding big rows

2011-05-10 Thread Meler Wojciech
Hello, I've noticed very nice stats exposed with JMX. I was quite shocked when I saw that MaxRowSize was about 400MB (it was expected to be several MB). What is the best way to find keys of such big rows? I couldn't find anything so I've written simple program to dump sizes from Index files

Re: Finding big rows

2011-05-10 Thread aaron morton
I'm not aware of anything to find the row sizes, and your code looks like a good approach. Converting the key bytes to a string only makes sense if your app is doing the same thing. In the cli try using one of the data type functions to format the key the same way as your app is, e.g. get