John, Yep that makes perfect sense. Thank you for your time I appreciate it!
From: John Anderstedt [mailto:john.anderst...@svenskaspel.se] Sent: Friday, January 24, 2014 9:08 AM To: user@cassandra.apache.org Subject: Re: Cassandra Performance Testing It sounds to me that the limitation in this setup is the disks. if it's in a mirror the cost for write's is the dubble. If you have the flatfile and the db on the same disk there will be a lot of io wait. There is also a question of diskspace and fragmentation, if the flat file occupies 1,2TB of a total of 2TB and then add the db to that. It will fill up and on the way it would go slower by the hour because the background processes that runs the compaction needs space to run. make sense? mvh / regards John 24 jan 2014 kl. 13:46 skrev Devin Pinkston <dpinks...@technicacorp.com<mailto:dpinks...@technicacorp.com>>: Hello, I am using a single node Cassandra setup with version 2.0.4 to do some simple performance testing. I generated a 1.2TB flat file from DBGEN (TPC-H), and I am loading that into Cassandra. I used the "COPY FROM" method from the CQLSH. My question/problem, the import has been running for over two days! Is there something I am potentially doing wrong? I setup the single node Cassandra from the getting started page. Specs for the server being used, (Ubuntu 12.0.4.3 LTS x64) Model 1950 Dell PowerEdge 1950 Server II Processor 2 2x Intel Quad Core 2.33GHz E5345 8MB Memory Installed 32GB 32GB PC2-5300F Fully Buffered Memory Memory Size 4GB Eight Slots Available: 8 x 4GB Memory Sticks Hard Drives Included 2x 1TB 7.2K SATA Hard Drives Thanks The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Technica Corporation does not represent this e-mail to be free from any virus, fault or defect and it is therefore the responsibility of the recipient to first scan it for viruses, faults and defects. To reply to our e-mail administrator directly, please send an e-mail to postmas...@technicacorp.com<mailto:postmas...@technicacorp.com>. Thank you. AB SVENSKA SPEL 621 80 Visby Norra Hansegatan 17, Visby Växel: +4610-120 00 00 https://svenskaspel.se<https://svenskaspel.se/> [https://svenskaspel.se/img/mailsignatur.gif] PPlease consider the environment before printing this email The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Technica Corporation does not represent this e-mail to be free from any virus, fault or defect and it is therefore the responsibility of the recipient to first scan it for viruses, faults and defects. To reply to our e-mail administrator directly, please send an e-mail to postmas...@technicacorp.com. Thank you.
