I used py_stress module to insert 10m test data with a secondary index. I got the following exceptions.
# python stress.py -d xxx -o insert -n 10000000 -c 5 -s 34 -C 5 -x keys total,interval_op_rate,interval_key_rate,avg_latency,elapsed_time 265322,26532,26541,0.00186140829433,10 630300,36497,36502,0.00129331431204,20 986781,35648,35640,0.0013310986218,30 1332190,34540,34534,0.00135942295893,40 1473578,14138,14138,0.00142941070007,50 Process Inserter-38: Traceback (most recent call last): File "/usr/lib64/python2.4/site-packages/multiprocessing/process.py", line 237, in _bootstrap self.run() File "stress.py", line 242, in run self.cclient.batch_mutate(cfmap, consistency) File "/root/apache-cassandra-0.7.4-src/interface/thrift/gen-py/cassandra/Cassandra.py", line 784, in batch_mutate TimedOutException: TimedOutException(args=()) self.run() File "stress.py", line 242, in run self.recv_batch_mutate() File "/root/apache-cassandra-0.7.4-src/interface/thrift/gen-py/cassandra/Cassandra.py", line 810, in recv_batch_mutate raise result.te Tests without secondary index is ok at about 40k ops/sec. There is a `GC for ParNew` for about 200ms taking place every second. Does it matter? The same gc for about 400ms happens every 2 seconds, which does not hurt the inserts without secondary index. Thanks in advance for any advice. Sheng