Re: Hi Memory consumption with Copy command

That's really excellent! Thank you so much for sharing the results. Regarding sstableloader, I am not familiar with its performance so I cannot make any recommendation as I've never compared it with COPY FROM. I have however compared COPY FROM with another bulk import tool, cassandra-loader,

Re: Upgrading to SSD

You could do the following instead to minimize server downtime: 1. rsync while the server is running 2. rsync again to get any new files 3. shut server down 4. rsync for the 3rd time 5. change directory in yaml and start back up On Sat, Apr 23, 2016 at 12:23 PM Clint Martin <

Re: Upgrading to SSD

As long as you shut down the node before you start copying and moving stuff around it shouldn't matter if you take backups or snapshots or whatever. When you add the filesystem for the ssd will you be removing the existing filesystem? Or will you be able to keep both filesystems mounted at the

Upgrading to SSD

Hi We have a 3 node cluster of 2.0.14. We use Read/Write Qorum and RF is 3.  We want to move data and commitlog directory from a SATA HDD to SSD. We have planned to do a rolling upgrade. We plan to run repair -pr on all nodes  to sync data upfront and then execute following steps on each server

Re: Efficient Paging Option in Wide Rows

Hi, Can anyone take this question? ThanksAnuj Sent from Yahoo Mail on Android On Sat, 23 Apr, 2016 at 2:30 PM, Anuj Wadehra wrote: I think I complicated the question..so I am trying to put the question crisply.. We have a table defined with clustering key/column.

Re: Hi Memory consumption with Copy command

I built cython and disabled bundled driver, the performance has been impressive. Memory issue is resolved and Im currently getting around 100,000 rows per second, its stressing both the client CPU as well as cassandra nodes. Thats the fastest I have ever seen it perform. With 60 Million rows

Re: Efficient Paging Option in Wide Rows

I think I complicated the question..so I am trying to put the question crisply.. We have a table defined with clustering key/column. We have  5 different clustering key values.  If we want to fetch all 5 rowd,Which query option would be faster and why? 1. Given a single primary

Re: Most stable version?

Hi, Thanks for your advice and discussion, Carlos and Jason. I'm going to wait for 2.2.6 release. And I'll verify that version by my self. Regards, Satoshi On Sat, Apr 23, 2016 at 5:57 AM, Jason J. W. Williams < jasonjwwilli...@gmail.com> wrote: > Thanks for the advice Carlos. Do appreciate

Re: Hi Memory consumption with Copy command

Thanks Stefania for the informative answer. The next blog was pretty useful as well: http://www.datastax.com/dev/blog/how-we-optimized-cassandra-cqlsh-copy-from . Ill upgrade to 3.0.5 and test with C extensions enabled and report on this thread. On Sat, Apr 23, 2016 at 8:54 AM, Stefania