cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Anderstedt <john.anderst...@svenskaspel.se>
Subject Re: Cassandra Performance Testing
Date Fri, 24 Jan 2014 14:07:53 GMT
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 <dpinkston@technicacorp.com<mailto:dpinkston@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 postmaster@technicacorp.com<mailto:postmaster@technicacorp.com>.
Thank you.

AB SVENSKA SPEL
621 80 Visby
Norra Hansegatan 17, Visby
Växel: +4610-120 00 00
https://svenskaspel.se

Please consider the environment before printing this email

Mime
View raw message