I started exploring apache cassandra 1.1.3. I am facing problem with how to
improve performance of cassandra using caching configurations.
I tried setting following configurations:
./nodetool -h 107.108.189.204 setcachecapacity DemoUser Users 200005 0
./nodetool -h 107.108.189.204 setcachecapacity DemoUser Users 0 200005
./nodetool -h 107.108.189.204 setcachecapacity DemoUser Users 200005 200005
./nodetool -h 107.108.189.204 setcachecapacity DemoUser Users 444 444
But when i am checking that this particula configuration are really been
configured using command:
./nodetool -h 107.108.189.212 cfstats
it's showing following results for keySpace DemoUser and column Family
Users:
*Keyspace: DemoUser
Read Count: 21914
Read Latency: 0.08268495026010769 ms.
Write Count: 87656
Write Latency: 0.06009481381765082 ms.
Pending Tasks: 0
Column Family: Users
SSTable count: 1
Space used (live): 1573335
Space used (total): 1573335
Number of Keys (estimate): 22016
Memtable Columns Count: 0
Memtable Data Size: 0
Memtable Switch Count: 1
Read Count: 21914
Read Latency: 0.083 ms.
Write Count: 87656
Write Latency: 0.060 ms.
Pending Tasks: 0
Bloom Filter False Postives: 0
Bloom Filter False Ratio: 0.00000
Bloom Filter Space Used: 41104
Compacted row minimum size: 150
Compacted row maximum size: 179
Compacted row mean size: 179 *
I am unable to see the effect of above setcachecapacity command. Let me
know how i can configure the cache capacity, and check it's effect.
With Regards,
Amit