Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?

RF=3, Ring=3, Up=3

write

  Execute CQL3 query | 2017-12-15 09:30:45.114000 | 127.0.0.1 |              0
            Parsing update count_by_id SET count = count + 1 WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:30:45.114000 | 127.0.0.1 |            320
                                                       Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:30:45.120000 | 127.0.0.1 |           5772
                                 Executing single-partition query on local [SharedPool-Worker-1] | 2017-12-15 09:30:45.172000 | 127.0.0.1 |          57252
                                              Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:30:45.172000 | 127.0.0.1 |          57735
                                             Key cache hit for sstable 689 [SharedPool-Worker-1] | 2017-12-15 09:30:45.173000 | 127.0.0.1 |          58783
 Skipped 0/1 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:30:45.174000 | 127.0.0.1 |          60057
                                Merging data from memtables and 1 sstables [SharedPool-Worker-1] | 2017-12-15 09:30:45.175000 | 127.0.0.1 |          60454
                                         Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-12-15 09:30:45.178000 | 127.0.0.1 |          63600
                                         Determining replicas for mutation [SharedPool-Worker-1] | 2017-12-15 09:30:45.185000 | 127.0.0.1 |          70529
                                    Enqueuing counter update to /127.0.0.3 [SharedPool-Worker-1] | 2017-12-15 09:30:45.186000 | 127.0.0.1 |          71370
           Sending COUNTER_MUTATION message to /127.0.0.3 [MessagingService-Outgoing-/127.0.0.3] | 2017-12-15 09:30:45.187000 | 127.0.0.1 |          73167
        COUNTER_MUTATION message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:30:45.207000 | 127.0.0.3 |            637
                                                   Acquiring counter locks [SharedPool-Worker-1] | 2017-12-15 09:30:45.214000 | 127.0.0.3 |           7029
                                      Fetching 1 counter values from cache [SharedPool-Worker-1] | 2017-12-15 09:30:45.220000 | 127.0.0.3 |          13168
                                      Reading 1 counter values from the CF [SharedPool-Worker-1] | 2017-12-15 09:30:45.221000 | 127.0.0.3 |          14775
                           Executing single-partition query on count_by_id [SharedPool-Worker-1] | 2017-12-15 09:30:45.222000 | 127.0.0.3 |          15126
                                              Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:30:45.222000 | 127.0.0.3 |          15228
 Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:30:45.222000 | 127.0.0.3 |          15369
                                 Executing single-partition query on local [SharedPool-Worker-1] | 2017-12-15 09:30:45.244000 | 127.0.0.3 |          22623
                                              Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:30:45.245000 | 127.0.0.3 |          38552
                                              Key cache hit for sstable 30 [SharedPool-Worker-1] | 2017-12-15 09:30:45.246000 | 127.0.0.3 |          39473
 Skipped 0/1 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:30:45.247000 | 127.0.0.3 |          40776
                                Merging data from memtables and 1 sstables [SharedPool-Worker-1] | 2017-12-15 09:30:45.248000 | 127.0.0.3 |          41457
                                         Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-12-15 09:30:45.249000 | 127.0.0.3 |          42225
                                                    Appending to commitlog [SharedPool-Worker-1] | 2017-12-15 09:30:45.250000 | 127.0.0.3 |          43716
                                            Adding to count_by_id memtable [SharedPool-Worker-1] | 2017-12-15 09:30:45.253000 | 127.0.0.3 |          46891
           Sending REQUEST_RESPONSE message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:30:45.265000 | 127.0.0.3 |          58624
        REQUEST_RESPONSE message received from /127.0.0.3 [MessagingService-Incoming-/127.0.0.3] | 2017-12-15 09:30:45.266000 | 127.0.0.1 |         151406
                                       Processing response from /127.0.0.3 [SharedPool-Worker-3] | 2017-12-15 09:30:45.266000 | 127.0.0.1 |         151855
                   Sending MUTATION message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:30:45.267000 | 127.0.0.3 |             --
                MUTATION message received from /127.0.0.3 [MessagingService-Incoming-/127.0.0.3] | 2017-12-15 09:30:45.268000 | 127.0.0.1 |         153962
                                                    Appending to commitlog [SharedPool-Worker-3] | 2017-12-15 09:30:45.268000 | 127.0.0.1 |         154226
                   Sending MUTATION message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:30:45.269000 | 127.0.0.3 |             --
                                            Adding to count_by_id memtable [SharedPool-Worker-3] | 2017-12-15 09:30:45.270000 | 127.0.0.1 |         155864
                                          Enqueuing response to /127.0.0.3 [SharedPool-Worker-3] | 2017-12-15 09:30:45.272000 | 127.0.0.1 |         158073
           Sending REQUEST_RESPONSE message to /127.0.0.3 [MessagingService-Outgoing-/127.0.0.3] | 2017-12-15 09:30:45.273000 | 127.0.0.1 |         158332
                MUTATION message received from /127.0.0.3 [MessagingService-Incoming-/127.0.0.3] | 2017-12-15 09:30:45.276000 | 127.0.0.2 |            839
                                                    Appending to commitlog [SharedPool-Worker-1] | 2017-12-15 09:30:45.277000 | 127.0.0.2 |           2386
                                            Adding to count_by_id memtable [SharedPool-Worker-1] | 2017-12-15 09:30:45.278000 | 127.0.0.2 |           2781
                                          Enqueuing response to /127.0.0.3 [SharedPool-Worker-1] | 2017-12-15 09:30:45.280000 | 127.0.0.2 |           4534
           Sending REQUEST_RESPONSE message to /127.0.0.3 [MessagingService-Outgoing-/127.0.0.3] | 2017-12-15 09:30:45.281000 | 127.0.0.2 |           5538
        REQUEST_RESPONSE message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:30:45.282000 | 127.0.0.3 |             --
                                       Processing response from /127.0.0.2 [SharedPool-Worker-5] | 2017-12-15 09:30:45.282000 | 127.0.0.3 |             --
        REQUEST_RESPONSE message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:30:45.288000 | 127.0.0.3 |             --
                                       Processing response from /127.0.0.1 [SharedPool-Worker-5] | 2017-12-15 09:30:45.296000 | 127.0.0.3 |             --
                                                                                Request complete | 2017-12-15 09:30:45.308859 | 127.0.0.1 |         194859

Read

activity                                                                                        | timestamp                  | source    | source_elapsed
-------------------------------------------------------------------------------------------------+----------------------------+-----------+----------------
                                                                              Execute CQL3 query | 2017-12-15 09:36:00.462000 | 127.0.0.1 |              0
                           Parsing select * from count_by_id WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:36:00.462000 | 127.0.0.1 |            410
                                                       Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:36:00.462000 | 127.0.0.1 |            662
                                              reading data from /127.0.0.3 [SharedPool-Worker-1] | 2017-12-15 09:36:00.463000 | 127.0.0.1 |           1350
                                      speculating read retry on /127.0.0.2 [SharedPool-Worker-1] | 2017-12-15 09:36:00.463000 | 127.0.0.1 |           1600
                       Sending READ message to /127.0.0.3 [MessagingService-Outgoing-/127.0.0.3] | 2017-12-15 09:36:00.463000 | 127.0.0.1 |           1807
                       Sending READ message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:36:00.464000 | 127.0.0.1 |           2095
                    READ message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:36:00.465000 | 127.0.0.2 |             32
                           Executing single-partition query on count_by_id [SharedPool-Worker-1] | 2017-12-15 09:36:00.466000 | 127.0.0.2 |           1209
                    READ message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:36:00.466000 | 127.0.0.3 |             31
                                              Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:36:00.466000 | 127.0.0.2 |           1412
 Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:36:00.467000 | 127.0.0.2 |           1696
                                Merging data from memtables and 0 sstables [SharedPool-Worker-1] | 2017-12-15 09:36:00.467000 | 127.0.0.2 |           1837
                                         Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-12-15 09:36:00.468000 | 127.0.0.2 |           2787
                                          Enqueuing response to /127.0.0.1 [SharedPool-Worker-1] | 2017-12-15 09:36:00.468000 | 127.0.0.2 |           3066
                           Executing single-partition query on count_by_id [SharedPool-Worker-3] | 2017-12-15 09:36:00.469000 | 127.0.0.3 |           3204
                                              Acquiring sstable references [SharedPool-Worker-3] | 2017-12-15 09:36:00.469000 | 127.0.0.3 |           3361
 Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-3] | 2017-12-15 09:36:00.469000 | 127.0.0.3 |           3521
                                Merging data from memtables and 0 sstables [SharedPool-Worker-3] | 2017-12-15 09:36:00.469000 | 127.0.0.3 |           3618
        REQUEST_RESPONSE message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:36:00.470000 | 127.0.0.1 |           7930
                                         Read 1 live and 0 tombstone cells [SharedPool-Worker-3] | 2017-12-15 09:36:00.470000 | 127.0.0.3 |           3944
                                       Processing response from /127.0.0.2 [SharedPool-Worker-3] | 2017-12-15 09:36:00.470000 | 127.0.0.1 |           8652
                                          Enqueuing response to /127.0.0.1 [SharedPool-Worker-3] | 2017-12-15 09:36:00.470000 | 127.0.0.3 |           4086
           Sending REQUEST_RESPONSE message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:36:00.471000 | 127.0.0.3 |           5113
        REQUEST_RESPONSE message received from /127.0.0.3 [MessagingService-Incoming-/127.0.0.3] | 2017-12-15 09:36:00.473000 | 127.0.0.1 |             --
                                       Processing response from /127.0.0.3 [SharedPool-Worker-1] | 2017-12-15 09:36:00.475000 | 127.0.0.1 |             --
                                                    Initiating read-repair [SharedPool-Worker-1] | 2017-12-15 09:36:00.476000 | 127.0.0.1 |             --
                                                                                Request complete | 2017-12-15 09:36:00.471932 | 127.0.0.1 |           9932

RF=3, Ring=3, Up=2

write

 activity                                                                                 | timestamp                  | source    | source_elapsed
------------------------------------------------------------------------------------------+----------------------------+-----------+----------------
                                                                       Execute CQL3 query | 2017-12-15 09:39:45.185000 | 127.0.0.1 |              0
     Parsing update count_by_id SET count = count + 1 WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:39:45.186000 | 127.0.0.1 |            270
                                                Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:39:45.186000 | 127.0.0.1 |            515
                                  Determining replicas for mutation [SharedPool-Worker-1] | 2017-12-15 09:39:45.186000 | 127.0.0.1 |           1076
                             Enqueuing counter update to /127.0.0.2 [SharedPool-Worker-1] | 2017-12-15 09:39:45.187000 | 127.0.0.1 |           1316
    Sending COUNTER_MUTATION message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:39:45.187000 | 127.0.0.1 |           1757
 COUNTER_MUTATION message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:39:45.188000 | 127.0.0.2 |             20
                                            Acquiring counter locks [SharedPool-Worker-1] | 2017-12-15 09:39:45.188000 | 127.0.0.2 |            276
                               Fetching 1 counter values from cache [SharedPool-Worker-1] | 2017-12-15 09:39:45.192000 | 127.0.0.2 |           4223
                                             Appending to commitlog [SharedPool-Worker-1] | 2017-12-15 09:39:45.192000 | 127.0.0.2 |           4497
                                     Adding to count_by_id memtable [SharedPool-Worker-1] | 2017-12-15 09:39:45.192000 | 127.0.0.2 |           4641
    Sending REQUEST_RESPONSE message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:39:45.195000 | 127.0.0.2 |           7541
            Sending MUTATION message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:39:45.196000 | 127.0.0.2 |             --
 REQUEST_RESPONSE message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:39:45.197000 | 127.0.0.1 |          11624
                                Processing response from /127.0.0.2 [SharedPool-Worker-5] | 2017-12-15 09:39:45.197000 | 127.0.0.1 |          12026
         MUTATION message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:39:45.197000 | 127.0.0.1 |          12115
                                             Appending to commitlog [SharedPool-Worker-5] | 2017-12-15 09:39:45.198000 | 127.0.0.1 |          12249
                                     Adding to count_by_id memtable [SharedPool-Worker-5] | 2017-12-15 09:39:45.198000 | 127.0.0.1 |          12443
                                   Enqueuing response to /127.0.0.2 [SharedPool-Worker-5] | 2017-12-15 09:39:45.199000 | 127.0.0.1 |          13547
 REQUEST_RESPONSE message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:39:45.200000 | 127.0.0.2 |             --
                                Processing response from /127.0.0.1 [SharedPool-Worker-7] | 2017-12-15 09:39:45.201000 | 127.0.0.2 |             --
    Sending REQUEST_RESPONSE message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:39:45.205000 | 127.0.0.1 |             --
                                                                         Request complete | 2017-12-15 09:39:45.198520 | 127.0.0.1 |          13520

read

                                                                              Execute CQL3 query | 2017-12-15 09:42:13.945000 | 127.0.0.1 |              0
                           Parsing select * from count_by_id WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:42:13.945000 | 127.0.0.1 |            130
                                                       Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:42:13.945000 | 127.0.0.1 |            293
                                                      Read-repair DC_LOCAL [SharedPool-Worker-1] | 2017-12-15 09:42:13.945000 | 127.0.0.1 |            892
                                              reading data from /127.0.0.2 [SharedPool-Worker-1] | 2017-12-15 09:42:13.946000 | 127.0.0.1 |           1037
                       Sending READ message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:42:13.946000 | 127.0.0.1 |           1266
                           Executing single-partition query on count_by_id [SharedPool-Worker-3] | 2017-12-15 09:42:13.946000 | 127.0.0.1 |           1569
                                              Acquiring sstable references [SharedPool-Worker-3] | 2017-12-15 09:42:13.946000 | 127.0.0.1 |           1672
 Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-3] | 2017-12-15 09:42:13.946000 | 127.0.0.1 |           1766
                                Merging data from memtables and 0 sstables [SharedPool-Worker-3] | 2017-12-15 09:42:13.946000 | 127.0.0.1 |           1804
                    READ message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:42:13.947000 | 127.0.0.2 |             21
                                         Read 1 live and 0 tombstone cells [SharedPool-Worker-3] | 2017-12-15 09:42:13.947000 | 127.0.0.1 |           2019
                           Executing single-partition query on count_by_id [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 |           1431
                                              Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 |           1534
 Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 |           1622
                                Merging data from memtables and 0 sstables [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 |           1665
                                         Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 |           1854
                                          Enqueuing response to /127.0.0.1 [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 |           1940
           Sending REQUEST_RESPONSE message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:42:13.953000 | 127.0.0.2 |           6002
        REQUEST_RESPONSE message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:42:13.956000 | 127.0.0.1 |             --
                                       Processing response from /127.0.0.2 [SharedPool-Worker-5] | 2017-12-15 09:42:13.958000 | 127.0.0.1 |             --
                                                    Initiating read-repair [SharedPool-Worker-5] | 2017-12-15 09:42:13.958000 | 127.0.0.1 |             --
                                                                                Request complete | 2017-12-15 09:42:13.947333 | 127.0.0.1 |           2333

Or, without read-repair

                                                                              Execute CQL3 query | 2017-12-15 09:43:15.999000 | 127.0.0.1 |              0
                           Parsing select * from count_by_id WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:43:15.999000 | 127.0.0.1 |            123
                                                       Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:43:15.999000 | 127.0.0.1 |            338
                           Executing single-partition query on count_by_id [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |            732
                                              Acquiring sstable references [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |            813
 Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |            887
                                Merging data from memtables and 0 sstables [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |            927
                                         Read 1 live and 0 tombstone cells [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |           1102
                                                                                Request complete | 2017-12-15 09:43:16.000361 | 127.0.0.1 |           1361

RF=3, Ring=3, Up=1

write

Execute CQL3 query | 2017-12-15 09:47:07.936000 | 127.0.0.1 |              0
 Parsing update count_by_id SET count = count + 1 WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:47:07.936000 | 127.0.0.1 |            259
                                            Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:47:07.936000 | 127.0.0.1 |            545
                              Determining replicas for mutation [SharedPool-Worker-1] | 2017-12-15 09:47:07.937000 | 127.0.0.1 |           1156
                                        Acquiring counter locks [SharedPool-Worker-2] | 2017-12-15 09:47:07.937000 | 127.0.0.1 |           1304
                           Fetching 1 counter values from cache [SharedPool-Worker-2] | 2017-12-15 09:47:07.937000 | 127.0.0.1 |           1572
                                         Appending to commitlog [SharedPool-Worker-2] | 2017-12-15 09:47:07.937001 | 127.0.0.1 |           1827
                                 Adding to count_by_id memtable [SharedPool-Worker-2] | 2017-12-15 09:47:07.938000 | 127.0.0.1 |           1921
                                                                     Request complete | 2017-12-15 09:47:07.938169 | 127.0.0.1 |           2169

read

                                                                              Execute CQL3 query | 2017-12-15 09:43:15.999000 | 127.0.0.1 |              0
                           Parsing select * from count_by_id WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:43:15.999000 | 127.0.0.1 |            123
                                                       Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:43:15.999000 | 127.0.0.1 |            338
                           Executing single-partition query on count_by_id [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |            732
                                              Acquiring sstable references [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |            813
 Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |            887
                                Merging data from memtables and 0 sstables [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |            927
                                         Read 1 live and 0 tombstone cells [SharedPool-Worker-3] |        2017-12-15 09:43:16 | 127.0.0.1 |           1102
                                                                                Request complete | 2017-12-15 09:43:16.000361 | 127.0.0.1 |           1361
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.