Advertisement
Guest User

cfstats

a guest
Feb 8th, 2013
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.66 KB | None | 0 0
  1. Keyspace: cassa_tt
  2. Read Count: 172523220
  3. Read Latency: 6.653334991144961 ms.
  4. Write Count: 644794068
  5. Write Latency: 0.044937816451810164 ms.
  6. Pending Tasks: 0
  7. Column Family: algo_goal_newcapping
  8. SSTable count: 7
  9. Space used (live): 8152904262
  10. Space used (total): 8152904262
  11. Number of Keys (estimate): 64439680
  12. Memtable Columns Count: 41684
  13. Memtable Data Size: 19622658
  14. Memtable Switch Count: 158
  15. Read Count: 15814235
  16. Read Latency: 3.745 ms.
  17. Write Count: 21878809
  18. Write Latency: 0.027 ms.
  19. Pending Tasks: 0
  20. Bloom Filter False Postives: 35561
  21. Bloom Filter False Ratio: 0.45161
  22. Bloom Filter Space Used: 88439856
  23. Compacted row minimum size: 150
  24. Compacted row maximum size: 17084
  25. Compacted row mean size: 276
  26.  
  27. Column Family: stats_format_uv
  28. SSTable count: 13
  29. Space used (live): 5684236603
  30. Space used (total): 5684236603
  31. Number of Keys (estimate): 90368
  32. Memtable Columns Count: 142560
  33. Memtable Data Size: 18030771
  34. Memtable Switch Count: 140
  35. Read Count: 0
  36. Read Latency: NaN ms.
  37. Write Count: 33295028
  38. Write Latency: 0.103 ms.
  39. Pending Tasks: 0
  40. Bloom Filter False Postives: 0
  41. Bloom Filter False Ratio: 0.00000
  42. Bloom Filter Space Used: 119120
  43. Compacted row minimum size: 73
  44. Compacted row maximum size: 268650950
  45. Compacted row mean size: 106145
  46.  
  47. Column Family: active_ad
  48. SSTable count: 1
  49. Space used (live): 381048
  50. Space used (total): 381048
  51. Number of Keys (estimate): 1152
  52. Memtable Columns Count: 142538
  53. Memtable Data Size: 17474
  54. Memtable Switch Count: 138
  55. Read Count: 5
  56. Read Latency: NaN ms.
  57. Write Count: 16994283
  58. Write Latency: 0.015 ms.
  59. Pending Tasks: 0
  60. Bloom Filter False Postives: 0
  61. Bloom Filter False Ratio: 0.00000
  62. Bloom Filter Space Used: 2576
  63. Compacted row minimum size: 73
  64. Compacted row maximum size: 20501
  65. Compacted row mean size: 570
  66.  
  67. Column Family: data_transac
  68. SSTable count: 7
  69. Space used (live): 7745745979
  70. Space used (total): 7745745979
  71. Number of Keys (estimate): 46025856
  72. Memtable Columns Count: 11867
  73. Memtable Data Size: 2696249
  74. Memtable Switch Count: 139
  75. Read Count: 220894
  76. Read Latency: 0.513 ms.
  77. Write Count: 569946
  78. Write Latency: 0.023 ms.
  79. Pending Tasks: 0
  80. Bloom Filter False Postives: 2719
  81. Bloom Filter False Ratio: 1.00000
  82. Bloom Filter Space Used: 57534352
  83. Compacted row minimum size: 180
  84. Compacted row maximum size: 535
  85. Compacted row mean size: 461
  86.  
  87. Column Family: active_product
  88. SSTable count: 3
  89. Space used (live): 1338359
  90. Space used (total): 1338359
  91. Number of Keys (estimate): 1536
  92. Memtable Columns Count: 856295
  93. Memtable Data Size: 91956
  94. Memtable Switch Count: 137
  95. Read Count: 21919
  96. Read Latency: 5.043 ms.
  97. Write Count: 30292117
  98. Write Latency: 0.055 ms.
  99. Pending Tasks: 0
  100. Bloom Filter False Postives: 0
  101. Bloom Filter False Ratio: 0.00000
  102. Bloom Filter Space Used: 2784
  103. Compacted row minimum size: 73
  104. Compacted row maximum size: 24601
  105. Compacted row mean size: 2277
  106.  
  107. Column Family: stats_product
  108. SSTable count: 3
  109. Space used (live): 106595166
  110. Space used (total): 106595166
  111. Number of Keys (estimate): 5504
  112. Memtable Columns Count: 886456
  113. Memtable Data Size: 760784
  114. Memtable Switch Count: 140
  115. Read Count: 72043631
  116. Read Latency: 6.496 ms.
  117. Write Count: 138856925
  118. Write Latency: 0.086 ms.
  119. Pending Tasks: 0
  120. Bloom Filter False Postives: 33493
  121. Bloom Filter False Ratio: 0.98925
  122. Bloom Filter Space Used: 9112
  123. Compacted row minimum size: 125
  124. Compacted row maximum size: 8409007
  125. Compacted row mean size: 69327
  126.  
  127. Column Family: data_transac_action
  128. SSTable count: 14
  129. Space used (live): 6127041780
  130. Space used (total): 6127041780
  131. Number of Keys (estimate): 38412928
  132. Memtable Columns Count: 7940
  133. Memtable Data Size: 3657144
  134. Memtable Switch Count: 92
  135. Read Count: 0
  136. Read Latency: NaN ms.
  137. Write Count: 227630
  138. Write Latency: 0.022 ms.
  139. Pending Tasks: 0
  140. Bloom Filter False Postives: 0
  141. Bloom Filter False Ratio: 0.00000
  142. Bloom Filter Space Used: 24009672
  143. Compacted row minimum size: 73
  144. Compacted row maximum size: 785939
  145. Compacted row mean size: 300
  146.  
  147. Column Family: algo_ad_budget
  148. SSTable count: 1
  149. Space used (live): 8843
  150. Space used (total): 8843
  151. Number of Keys (estimate): 128
  152. Memtable Columns Count: 936
  153. Memtable Data Size: 8641
  154. Memtable Switch Count: 137
  155. Read Count: 131148
  156. Read Latency: 0.262 ms.
  157. Write Count: 394404
  158. Write Latency: 0.024 ms.
  159. Pending Tasks: 0
  160. Bloom Filter False Postives: 0
  161. Bloom Filter False Ratio: 0.00000
  162. Bloom Filter Space Used: 1296
  163. Compacted row minimum size: 104
  164. Compacted row maximum size: 372
  165. Compacted row mean size: 224
  166.  
  167. Column Family: stats_ad_product
  168. SSTable count: 4
  169. Space used (live): 250656287
  170. Space used (total): 250656287
  171. Number of Keys (estimate): 163968
  172. Memtable Columns Count: 130714
  173. Memtable Data Size: 752633
  174. Memtable Switch Count: 139
  175. Read Count: 9502636
  176. Read Latency: 8.445 ms.
  177. Write Count: 21645982
  178. Write Latency: 0.030 ms.
  179. Pending Tasks: 0
  180. Bloom Filter False Postives: 906
  181. Bloom Filter False Ratio: 0.20000
  182. Bloom Filter Space Used: 213088
  183. Compacted row minimum size: 125
  184. Compacted row maximum size: 2816159
  185. Compacted row mean size: 5118
  186.  
  187. Column Family: stats_creative_pool
  188. SSTable count: 2
  189. Space used (live): 384966
  190. Space used (total): 384966
  191. Number of Keys (estimate): 3840
  192. Memtable Columns Count: 26002
  193. Memtable Data Size: 128198
  194. Memtable Switch Count: 137
  195. Read Count: 2245942
  196. Read Latency: 3.758 ms.
  197. Write Count: 6804022
  198. Write Latency: 0.021 ms.
  199. Pending Tasks: 0
  200. Bloom Filter False Postives: 0
  201. Bloom Filter False Ratio: 0.00000
  202. Bloom Filter Space Used: 6248
  203. Compacted row minimum size: 104
  204. Compacted row maximum size: 1916
  205. Compacted row mean size: 340
  206.  
  207. Column Family: active_ad_product
  208. SSTable count: 2
  209. Space used (live): 5860221
  210. Space used (total): 5860221
  211. Number of Keys (estimate): 1280
  212. Memtable Columns Count: 120530
  213. Memtable Data Size: 194472
  214. Memtable Switch Count: 136
  215. Read Count: 1344
  216. Read Latency: NaN ms.
  217. Write Count: 16974215
  218. Write Latency: 0.016 ms.
  219. Pending Tasks: 0
  220. Bloom Filter False Postives: 0
  221. Bloom Filter False Ratio: 0.00000
  222. Bloom Filter Space Used: 2600
  223. Compacted row minimum size: 73
  224. Compacted row maximum size: 1131752
  225. Compacted row mean size: 7939
  226.  
  227. Column Family: algo_product_view
  228. SSTable count: 1
  229. Space used (live): 9170
  230. Space used (total): 9170
  231. Number of Keys (estimate): 128
  232. Memtable Columns Count: 0
  233. Memtable Data Size: 0
  234. Memtable Switch Count: 0
  235. Read Count: 1048
  236. Read Latency: NaN ms.
  237. Write Count: 0
  238. Write Latency: NaN ms.
  239. Pending Tasks: 0
  240. Bloom Filter False Postives: 0
  241. Bloom Filter False Ratio: 0.00000
  242. Bloom Filter Space Used: 1296
  243. Compacted row minimum size: 180
  244. Compacted row maximum size: 2759
  245. Compacted row mean size: 898
  246.  
  247. Column Family: data_action
  248. SSTable count: 10
  249. Space used (live): 183258202657
  250. Space used (total): 183258202657
  251. Number of Keys (estimate): 1109640832
  252. Memtable Columns Count: 123025
  253. Memtable Data Size: 42174051
  254. Memtable Switch Count: 1468
  255. Read Count: 0
  256. Read Latency: NaN ms.
  257. Write Count: 79753843
  258. Write Latency: 0.032 ms.
  259. Pending Tasks: 0
  260. Bloom Filter False Postives: 0
  261. Bloom Filter False Ratio: 0.00000
  262. Bloom Filter Space Used: 138705840
  263. Compacted row minimum size: 150
  264. Compacted row maximum size: 1916
  265. Compacted row mean size: 326
  266.  
  267. Column Family: algo_ad_time_interval
  268. SSTable count: 9
  269. Space used (live): 5192769365
  270. Space used (total): 5192769365
  271. Number of Keys (estimate): 49383680
  272. Memtable Columns Count: 29672
  273. Memtable Data Size: 23022364
  274. Memtable Switch Count: 148
  275. Read Count: 128751
  276. Read Latency: 4.593 ms.
  277. Write Count: 10940444
  278. Write Latency: 0.037 ms.
  279. Pending Tasks: 0
  280. Bloom Filter False Postives: 2104
  281. Bloom Filter False Ratio: 0.83333
  282. Bloom Filter Space Used: 61771024
  283. Compacted row minimum size: 87
  284. Compacted row maximum size: 149
  285. Compacted row mean size: 149
  286.  
  287. Column Family: algo_goal_time_interval
  288. SSTable count: 10
  289. Space used (live): 5191426872
  290. Space used (total): 5191426872
  291. Number of Keys (estimate): 49325952
  292. Memtable Columns Count: 29672
  293. Memtable Data Size: 23023145
  294. Memtable Switch Count: 151
  295. Read Count: 133
  296. Read Latency: NaN ms.
  297. Write Count: 10938605
  298. Write Latency: 0.036 ms.
  299. Pending Tasks: 0
  300. Bloom Filter False Postives: 0
  301. Bloom Filter False Ratio: 0.00000
  302. Bloom Filter Space Used: 61665280
  303. Compacted row minimum size: 87
  304. Compacted row maximum size: 149
  305. Compacted row mean size: 149
  306.  
  307. Column Family: stats_ad_product_uv
  308. SSTable count: 6
  309. Space used (live): 14700307029
  310. Space used (total): 14700307029
  311. Number of Keys (estimate): 4661248
  312. Memtable Columns Count: 114172
  313. Memtable Data Size: 16315631
  314. Memtable Switch Count: 139
  315. Read Count: 0
  316. Read Latency: NaN ms.
  317. Write Count: 36541623
  318. Write Latency: 0.451 ms.
  319. Pending Tasks: 0
  320. Bloom Filter False Postives: 0
  321. Bloom Filter False Ratio: 0.00000
  322. Bloom Filter Space Used: 5836352
  323. Compacted row minimum size: 73
  324. Compacted row maximum size: 43388628
  325. Compacted row mean size: 11214
  326.  
  327. Column Family: stats_ad_uv
  328. SSTable count: 13
  329. Space used (live): 15066373066
  330. Space used (total): 15066373066
  331. Number of Keys (estimate): 804608
  332. Memtable Columns Count: 148608
  333. Memtable Data Size: 18875471
  334. Memtable Switch Count: 141
  335. Read Count: 54
  336. Read Latency: NaN ms.
  337. Write Count: 33076197
  338. Write Latency: 0.171 ms.
  339. Pending Tasks: 0
  340. Bloom Filter False Postives: 0
  341. Bloom Filter False Ratio: 0.00000
  342. Bloom Filter Space Used: 1012240
  343. Compacted row minimum size: 73
  344. Compacted row maximum size: 268650950
  345. Compacted row mean size: 48275
  346.  
  347. Column Family: stats_ad
  348. SSTable count: 3
  349. Space used (live): 33467455
  350. Space used (total): 33467455
  351. Number of Keys (estimate): 4096
  352. Memtable Columns Count: 53775
  353. Memtable Data Size: 117518
  354. Memtable Switch Count: 138
  355. Read Count: 12813274
  356. Read Latency: 14.029 ms.
  357. Write Count: 16308320
  358. Write Latency: 0.183 ms.
  359. Pending Tasks: 0
  360. Bloom Filter False Postives: 15
  361. Bloom Filter False Ratio: 0.00000
  362. Bloom Filter Space Used: 6104
  363. Compacted row minimum size: 125
  364. Compacted row maximum size: 5839588
  365. Compacted row mean size: 15190
  366.  
  367. Column Family: active_product_ad
  368. SSTable count: 2
  369. Space used (live): 5181986
  370. Space used (total): 5181986
  371. Number of Keys (estimate): 640
  372. Memtable Columns Count: 0
  373. Memtable Data Size: 0
  374. Memtable Switch Count: 0
  375. Read Count: 1609
  376. Read Latency: NaN ms.
  377. Write Count: 0
  378. Write Latency: NaN ms.
  379. Pending Tasks: 0
  380. Bloom Filter False Postives: 0
  381. Bloom Filter False Ratio: 0.00000
  382. Bloom Filter Space Used: 1152
  383. Compacted row minimum size: 216
  384. Compacted row maximum size: 1131752
  385. Compacted row mean size: 21686
  386.  
  387. Column Family: data_ip_viewer
  388. SSTable count: 7
  389. Space used (live): 1625691514
  390. Space used (total): 1625691514
  391. Number of Keys (estimate): 18569344
  392. Memtable Columns Count: 271502
  393. Memtable Data Size: 124721735
  394. Memtable Switch Count: 230
  395. Read Count: 3272112
  396. Read Latency: 40.426 ms.
  397. Write Count: 37740232
  398. Write Latency: 0.036 ms.
  399. Pending Tasks: 0
  400. Bloom Filter False Postives: 5593
  401. Bloom Filter False Ratio: 0.02110
  402. Bloom Filter Space Used: 26510544
  403. Compacted row minimum size: 73
  404. Compacted row maximum size: 1109
  405. Compacted row mean size: 125
  406.  
  407. Column Family: stats_product_uv
  408. SSTable count: 14
  409. Space used (live): 12768884042
  410. Space used (total): 12768884042
  411. Number of Keys (estimate): 1972352
  412. Memtable Columns Count: 118588
  413. Memtable Data Size: 15628298
  414. Memtable Switch Count: 140
  415. Read Count: 0
  416. Read Latency: NaN ms.
  417. Write Count: 35751869
  418. Write Latency: 0.025 ms.
  419. Pending Tasks: 0
  420. Bloom Filter False Postives: 0
  421. Bloom Filter False Ratio: 0.00000
  422. Bloom Filter Space Used: 2478968
  423. Compacted row minimum size: 73
  424. Compacted row maximum size: 89970660
  425. Compacted row mean size: 17640
  426.  
  427. Column Family: data_viewer
  428. SSTable count: 14
  429. Space used (live): 12673962699
  430. Space used (total): 12673962699
  431. Number of Keys (estimate): 68588288
  432. Memtable Columns Count: 824328
  433. Memtable Data Size: 117131581
  434. Memtable Switch Count: 931
  435. Read Count: 10389099
  436. Read Latency: 55.663 ms.
  437. Write Count: 37688294
  438. Write Latency: 0.072 ms.
  439. Pending Tasks: 0
  440. Bloom Filter False Postives: 37187
  441. Bloom Filter False Ratio: 0.02500
  442. Bloom Filter Space Used: 86459632
  443. Compacted row minimum size: 73
  444. Compacted row maximum size: 1597
  445. Compacted row mean size: 618
  446.  
  447. Column Family: algo_product_budget
  448. SSTable count: 3
  449. Space used (live): 57822
  450. Space used (total): 57822
  451. Number of Keys (estimate): 512
  452. Memtable Columns Count: 1548
  453. Memtable Data Size: 75027
  454. Memtable Switch Count: 126
  455. Read Count: 11394
  456. Read Latency: NaN ms.
  457. Write Count: 34065
  458. Write Latency: 0.026 ms.
  459. Pending Tasks: 0
  460. Bloom Filter False Postives: 0
  461. Bloom Filter False Ratio: 0.00000
  462. Bloom Filter Space Used: 1648
  463. Compacted row minimum size: 180
  464. Compacted row maximum size: 3973
  465. Compacted row mean size: 451
  466.  
  467. Column Family: algo_product_newcapping
  468. SSTable count: 11
  469. Space used (live): 10604169729
  470. Space used (total): 10604169729
  471. Number of Keys (estimate): 82055296
  472. Memtable Columns Count: 61646
  473. Memtable Data Size: 30144552
  474. Memtable Switch Count: 155
  475. Read Count: 7296668
  476. Read Latency: 22.376 ms.
  477. Write Count: 21850128
  478. Write Latency: 0.030 ms.
  479. Pending Tasks: 0
  480. Bloom Filter False Postives: 41058
  481. Bloom Filter False Ratio: 0.14706
  482. Bloom Filter Space Used: 102582272
  483. Compacted row minimum size: 150
  484. Compacted row maximum size: 17084
  485. Compacted row mean size: 274
  486.  
  487. Column Family: algo_ad_view
  488. SSTable count: 1
  489. Space used (live): 591375
  490. Space used (total): 591375
  491. Number of Keys (estimate): 128
  492. Memtable Columns Count: 2016
  493. Memtable Data Size: 13034
  494. Memtable Switch Count: 139
  495. Read Count: 5028142
  496. Read Latency: 0.572 ms.
  497. Write Count: 1240788
  498. Write Latency: 0.021 ms.
  499. Pending Tasks: 0
  500. Bloom Filter False Postives: 0
  501. Bloom Filter False Ratio: 0.00000
  502. Bloom Filter Space Used: 1296
  503. Compacted row minimum size: 125
  504. Compacted row maximum size: 545791
  505. Compacted row mean size: 33496
  506.  
  507. Column Family: stats_button
  508. SSTable count: 3
  509. Space used (live): 16133
  510. Space used (total): 16133
  511. Number of Keys (estimate): 384
  512. Memtable Columns Count: 0
  513. Memtable Data Size: 0
  514. Memtable Switch Count: 0
  515. Read Count: 6
  516. Read Latency: NaN ms.
  517. Write Count: 0
  518. Write Latency: NaN ms.
  519. Pending Tasks: 0
  520. Bloom Filter False Postives: 0
  521. Bloom Filter False Ratio: 0.00000
  522. Bloom Filter Space Used: 1008
  523. Compacted row minimum size: 150
  524. Compacted row maximum size: 924
  525. Compacted row mean size: 338
  526.  
  527. Column Family: algo_goal_budget
  528. SSTable count: 2
  529. Space used (live): 15077
  530. Space used (total): 15077
  531. Number of Keys (estimate): 256
  532. Memtable Columns Count: 1089
  533. Memtable Data Size: 11960
  534. Memtable Switch Count: 137
  535. Read Count: 680727
  536. Read Latency: 1.431 ms.
  537. Write Count: 369975
  538. Write Latency: NaN ms.
  539. Pending Tasks: 0
  540. Bloom Filter False Postives: 0
  541. Bloom Filter False Ratio: 0.00000
  542. Bloom Filter Space Used: 1328
  543. Compacted row minimum size: 104
  544. Compacted row maximum size: 372
  545. Compacted row mean size: 225
  546.  
  547. Column Family: algo_ad_newcapping
  548. SSTable count: 15
  549. Space used (live): 22421781408
  550. Space used (total): 22421781408
  551. Number of Keys (estimate): 141831424
  552. Memtable Columns Count: 78702
  553. Memtable Data Size: 36421613
  554. Memtable Switch Count: 157
  555. Read Count: 29271581
  556. Read Latency: 19.218 ms.
  557. Write Count: 21885883
  558. Write Latency: 0.030 ms.
  559. Pending Tasks: 0
  560. Bloom Filter False Postives: 12508
  561. Bloom Filter False Ratio: 0.12245
  562. Bloom Filter Space Used: 214249328
  563. Compacted row minimum size: 125
  564. Compacted row maximum size: 126934
  565. Compacted row mean size: 345
  566.  
  567. Column Family: algo_product_time_interval
  568. SSTable count: 11
  569. Space used (live): 5389842843
  570. Space used (total): 5389842843
  571. Number of Keys (estimate): 49983488
  572. Memtable Columns Count: 14867
  573. Memtable Data Size: 11950081
  574. Memtable Switch Count: 148
  575. Read Count: 3879
  576. Read Latency: NaN ms.
  577. Write Count: 10924115
  578. Write Latency: 0.034 ms.
  579. Pending Tasks: 0
  580. Bloom Filter False Postives: 10
  581. Bloom Filter False Ratio: 0.00000
  582. Bloom Filter Space Used: 62502952
  583. Compacted row minimum size: 87
  584. Compacted row maximum size: 149
  585. Compacted row mean size: 149
  586.  
  587. Column Family: data_viewer_transac
  588. SSTable count: 7
  589. Space used (live): 2609267211
  590. Space used (total): 2609267211
  591. Number of Keys (estimate): 17497600
  592. Memtable Columns Count: 3935
  593. Memtable Data Size: 2534260
  594. Memtable Switch Count: 138
  595. Read Count: 0
  596. Read Latency: NaN ms.
  597. Write Count: 407013
  598. Write Latency: 0.026 ms.
  599. Pending Tasks: 0
  600. Bloom Filter False Postives: 0
  601. Bloom Filter False Ratio: 0.00000
  602. Bloom Filter Space Used: 10937712
  603. Compacted row minimum size: 61
  604. Compacted row maximum size: 4866323
  605. Compacted row mean size: 220
  606.  
  607. Column Family: algo_goal_view
  608. SSTable count: 2
  609. Space used (live): 180317
  610. Space used (total): 180317
  611. Number of Keys (estimate): 256
  612. Memtable Columns Count: 2016
  613. Memtable Data Size: 18721
  614. Memtable Switch Count: 139
  615. Read Count: 3639048
  616. Read Latency: 0.609 ms.
  617. Write Count: 1359453
  618. Write Latency: 0.021 ms.
  619. Pending Tasks: 0
  620. Bloom Filter False Postives: 0
  621. Bloom Filter False Ratio: 0.00000
  622. Bloom Filter Space Used: 1328
  623. Compacted row minimum size: 104
  624. Compacted row maximum size: 51012
  625. Compacted row mean size: 3864
  626.  
  627. Column Family: data_cust_website_viewer
  628. SSTable count: 2
  629. Space used (live): 68294060
  630. Space used (total): 68294060
  631. Number of Keys (estimate): 778112
  632. Memtable Columns Count: 516
  633. Memtable Data Size: 101467
  634. Memtable Switch Count: 137
  635. Read Count: 3953
  636. Read Latency: NaN ms.
  637. Write Count: 50010
  638. Write Latency: 0.020 ms.
  639. Pending Tasks: 0
  640. Bloom Filter False Postives: 4
  641. Bloom Filter False Ratio: 0.00000
  642. Bloom Filter Space Used: 486904
  643. Compacted row minimum size: 61
  644. Compacted row maximum size: 8409007
  645. Compacted row mean size: 137
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement