On 26 Nov 2014, at 19:07, Robert Coli <rc...@eventbrite.com> wrote: > > Yes. Do you know if 5748 was created as a result of compaction or via a flush > from a memtable?
It was the result of a compaction: INFO [CompactionExecutor:22422] 2014-11-13 13:08:41,926 CompactionTask.java (line 262) Compacted 2 sstables to [/servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5744,]. 10,732,071 bytes to 10,824,798 (~100% of original) in 2,950ms = 3.499435MB/s. 36,632 total rows, 35,545 unique. Row merge counts were {1:34460, 2:1086, } INFO [CompactionExecutor:22528] 2014-11-13 14:55:09,944 CompactionTask.java (line 262) Compacted 2 sstables to [/servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5746,]. 15,790,121 bytes to 14,913,599 (~94% of original) in 3,491ms = 4.074110MB/s. 46,167 total rows, 43,745 unique. Row merge counts were {1:41323, 2:2422, } INFO [CompactionExecutor:22590] 2014-11-13 15:26:50,087 CompactionTask.java (line 262) Compacted 2 sstables to [/servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5748,]. 16,088,983 bytes to 16,110,649 (~100% of original) in 2,741ms = 5.605367MB/s. 48,332 total rows, 47,392 unique. Row merge counts were {1:46452, 2:940, } <--------------------------- INFO [CompactionExecutor:22718] 2014-11-13 18:05:36,326 CompactionTask.java (line 262) Compacted 2 sstables to [/servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5750,]. 21,508,530 bytes to 21,342,786 (~99% of original) in 3,461ms = 5.880979MB/s. 66,361 total rows, 63,219 unique. Row merge counts were {1:60077, 2:3142, } INFO [CompactionExecutor:22817] 2014-11-13 19:06:04,564 CompactionTask.java (line 262) Compacted 2 sstables to [/servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5752,]. 23,232,660 bytes to 23,087,822 (~99% of original) in 3,144ms = 7.003264MB/s. 68,968 total rows, 67,602 unique. Row merge counts were {1:66236, 2:1366, } Regarding flushes I have: INFO [FlushWriter:3079] 2014-11-13 13:08:38,972 Memtable.java (line 436) Completed flushing /servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5743-Data.db (4698473 bytes) for commitlog position ReplayPosition(segmentId=1413900469571, position=6240) INFO [FlushWriter:3093] 2014-11-13 14:55:06,436 Memtable.java (line 436) Completed flushing /servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5745-Data.db (4965323 bytes) for commitlog position ReplayPosition(segmentId=1413900469603, position=2518) INFO [FlushWriter:3101] 2014-11-13 15:26:47,336 Memtable.java (line 436) Completed flushing /servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5747-Data.db (1175384 bytes) for commitlog position ReplayPosition(segmentId=1413900469635, position=9984) INFO [FlushWriter:3121] 2014-11-13 18:05:32,853 Memtable.java (line 436) Completed flushing /servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5749-Data.db (5397881 bytes) for commitlog position ReplayPosition(segmentId=1413900469667, position=8533) INFO [FlushWriter:3134] 2014-11-13 19:06:01,416 Memtable.java (line 436) Completed flushing /servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5751-Data.db (1889874 bytes) for commitlog position ReplayPosition(segmentId=1413900469699, position=108) INFO [FlushWriter:3147] 2014-11-13 21:20:58,312 Memtable.java (line 436) Completed flushing /servers/storage/cassandra-data/Disco/NamespaceFile2/Disco-NamespaceFile2-ic-5753-Data.db (3283519 bytes) for commitlog position ReplayPosition(segmentId=1413900469731, position=6848) André