cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason Baker <ja...@apture.com>
Subject Tuning a column family for archival
Date Thu, 11 Aug 2011 01:18:24 GMT
I have a column family that I'm using to archive records.  They're mostly
kept around for historical purposes.  Aside from that, they're mostly
considered deleted.  It's probably going to be very rare that anyone reads
from this table *ever*.  I don't really even write to it that much.

Does anyone have advice for me as far as how (or if) I should tune this
table with that in mind?  My concern is less speeding up access to this
table than it is making sure that it doesn't impact the performance of any
other column families in any way.

Here's the data from nodetool cfstat (although this table was just created a
few days ago):

Column Family: ArchivedLinks
SSTable count: 1
Space used (live): 29580801
Space used (total): 97838786
Number of Keys (estimate): 93184
Memtable Columns Count: 7497
Memtable Data Size: 3223587
Memtable Switch Count: 11
Read Count: 0
Read Latency: NaN ms.
Write Count: 139091
Write Latency: 0.007 ms.
Pending Tasks: 0
Key cache: disabled
Row cache: disabled
Compacted row minimum size: 259
Compacted row maximum size: 372
Compacted row mean size: 311

Mime
View raw message