but it seems the row cache is cluster wide, how will the change of row cache affect the read speed?
On Mon, Aug 15, 2011 at 7:33 AM, Jonathan Ellis <jbel...@gmail.com> wrote: > Or leave row cache enabled but disable cache saving (and remove the > one already on disk). > > On Sun, Aug 14, 2011 at 5:05 PM, aaron morton <aa...@thelastpickle.com> > wrote: > > INFO [main] 2011-08-14 09:24:52,198 ColumnFamilyStore.java (line 547) > > completed loading (1744370 ms; 200000 keys) row cache for COMMENT > > > > It's taking 29 minutes to load 200,000 rows in the row cache. Thats a > > pretty big row cache, I would suggest reducing or disabling it. > > Background > http://www.datastax.com/dev/blog/maximizing-cache-benefit-with-cassandra > > > > and server can not afford the load then crashed. after come back, node 3 > can > > not return for more than 96 hours > > > > Crashed how ? > > You may be seeing https://issues.apache.org/jira/browse/CASSANDRA-2280 > > Watch nodetool compactionstats to see when the Merkle tree build finishes > > and nodetool netstats to see which CF's are streaming. > > Cheers > > ----------------- > > Aaron Morton > > Freelance Cassandra Developer > > @aaronmorton > > http://www.thelastpickle.com > > On 15 Aug 2011, at 04:23, Yan Chunlu wrote: > > > > > > I got 3 nodes and RF=3, when I repairing ndoe3, it seems alot data > > generated. and server can not afford the load then crashed. > > after come back, node 3 can not return for more than 96 hours > > > > for 34GB data, the node 2 could restart and back online within 1 hour. > > > > I am not sure what's wrong with node3 and should I restart node 3 again? > > thanks! > > > > Address Status State Load Owns Token > > > > 113427455640312821154458202477256070484 > > node1 Up Normal 34.11 GB 33.33% 0 > > node2 Up Normal 31.44 GB 33.33% > > 56713727820156410577229101238628035242 > > node3 Down Normal 177.55 GB 33.33% > > 113427455640312821154458202477256070484 > > > > > > the log shows it is still going on, not sure why it is so slow: > > > > > > INFO [main] 2011-08-14 08:55:47,734 SSTableReader.java (line 154) > Opening > > /cassandra/data/COMMENT > > INFO [main] 2011-08-14 08:55:47,828 ColumnFamilyStore.java (line 275) > > reading saved cache /cassandra/saved_caches/COMMENT-RowCache > > INFO [main] 2011-08-14 09:24:52,198 ColumnFamilyStore.java (line 547) > > completed loading (1744370 ms; 200000 keys) row cache for COMMENT > > INFO [main] 2011-08-14 09:24:52,299 ColumnFamilyStore.java (line 275) > > reading saved cache /cassandra/saved_caches/COMMENT-RowCache > > INFO [CompactionExecutor:1] 2011-08-14 10:24:55,480 CacheWriter.java > (line > > 96) Saved COMMENT-RowCache (200000 items) in 2535 ms > > > > > > > > > > > > > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of DataStax, the source for professional Cassandra support > http://www.datastax.com >
