Page MenuHomePhabricator
Paste P13740

sh-session
ActivePublic

Authored by Eevans on Tue, Jan 12, 7:52 PM.
eevans@restbase1016:~$ for i in `c-cqlsh a -e 'describe keyspaces' | sed s"/\"//g" | grep parsoidphp`; do nodetool-a tablestats -- $i.data; done | grep -B12 'SSTable Compression Ratio: '
Keyspace : enwiki_T_parsoidphp
Read Count: 45981193
Read Latency: 1.6735738149073252 ms
Write Count: 9475295
Write Latency: 0.28238401854506906 ms
Pending Flushes: 0
Table: data
SSTable count: 41
Space used (live): 91226866105
Space used (total): 91226866105
Space used by snapshots (total): 0
Off heap memory used (total): 125065415
SSTable Compression Ratio: 0.30910691964034565
--
Keyspace : commons_T_parsoidphp
Read Count: 2047259
Read Latency: 2.1093662482372775 ms
Write Count: 7577715
Write Latency: 0.06577415447796597 ms
Pending Flushes: 0
Table: data
SSTable count: 46
Space used (live): 128934713130
Space used (total): 128934713130
Space used by snapshots (total): 0
Off heap memory used (total): 302687314
SSTable Compression Ratio: 0.2900460869802322
--
Keyspace : commons_T_parsoidphpAetaDBIXR_iWCeS5MknjkVQgnFw
Read Count: 804
Read Latency: 0.2831442786069652 ms
Write Count: 2922
Write Latency: 0.05146440793976728 ms
Pending Flushes: 0
Table: data
SSTable count: 7
Space used (live): 1109891
Space used (total): 1109891
Space used by snapshots (total): 0
Off heap memory used (total): 58778
SSTable Compression Ratio: 0.32387092412301033
--
Keyspace : others_T_parsoidphp
Read Count: 5255116
Read Latency: 1.9292927046710293 ms
Write Count: 3507315
Write Latency: 0.08652081121883835 ms
Pending Flushes: 0
Table: data
SSTable count: 44
Space used (live): 70687132563
Space used (total): 70687132563
Space used by snapshots (total): 0
Off heap memory used (total): 235950478
SSTable Compression Ratio: 0.3031727942634503
--
Keyspace : enwiki_T_parsoidphpAetaDBIXR_iWCeS5MknjkVQgnFw
Read Count: 89905
Read Latency: 1.0463247427840499 ms
Write Count: 152879
Write Latency: 0.21603851411900915 ms
Pending Flushes: 0
Table: data
SSTable count: 12
Space used (live): 382111100
Space used (total): 382111100
Space used by snapshots (total): 0
Off heap memory used (total): 5657162
SSTable Compression Ratio: 0.30278798062677204
--
Keyspace : wikipedia_T_parsoidphp
Read Count: 60145793
Read Latency: 3.012910206354749 ms
Write Count: 16409742
Write Latency: 0.3191373108730168 ms
Pending Flushes: 0
Table: data
SSTable count: 46
Space used (live): 257263204441
Space used (total): 257263204441
Space used by snapshots (total): 0
Off heap memory used (total): 261130730
SSTable Compression Ratio: 0.30434670861691354
--
Keyspace : wikipedia_T_parsoidphpAetaDBIXR_iWCeS5MknjkVQgnF
Read Count: 257071
Read Latency: 0.8860332359542694 ms
Write Count: 794042
Write Latency: 0.14047291075283172 ms
Pending Flushes: 0
Table: data
SSTable count: 20
Space used (live): 1606784285
Space used (total): 1606784285
Space used by snapshots (total): 0
Off heap memory used (total): 211358760
SSTable Compression Ratio: 0.31129842532146573
--
Keyspace : others_T_parsoidphpAetaDBIXR_iWCeS5MknjkVQgnFw
Read Count: 5639
Read Latency: 0.4571773364071644 ms
Write Count: 122732
Write Latency: 0.04774819932861846 ms
Pending Flushes: 0
Table: data
SSTable count: 8
Space used (live): 10517047
Space used (total): 10517047
Space used by snapshots (total): 0
Off heap memory used (total): 2559647
SSTable Compression Ratio: 0.2884520835866633
eevans@restbase1016:~$

Event Timeline

Eevans created this paste.Tue, Jan 12, 7:52 PM
Eevans changed the title of this paste from untitled to sh-session.