Uploaded image for project: 'MongoDB Database Tools'
  1. MongoDB Database Tools
  2. TOOLS-1437

mongostat repl-stats-indicating asterisk shows when value is zero, even if primary

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Accepted
    • Priority: Minor - P4
    • Resolution: Unresolved
    • Affects Version/s: 3.2.0-rc5
    • Fix Version/s: None
    • Component/s: mongostat
    • Labels:
      None

      Description

      I was showing mongostat to someone and they had a question about the asterisk that appears next to the insert/query/update/delete/getmore counters. Per the documentation this just indicates when the figures shown are for replicated operations on a secondary (i.e. would come from db.serverStatus().opcountersRepl rather than db.serverStatus().opcounters).

      What I've noticed is that when the value is zero it gets an asterisk even if it's the PRIMARY.

      akira:~$ mongostat --host=testrs/akira-macbookpro:27017,akira-macbookpro:27018,akira-macbookpro:27019 5
       
                             insert query update delete getmore command % dirty % used flushes  vsize   res qr|qw ar|aw netIn netOut conn    set repl                      time
      akira-macbookpro:27017     *0    *0     *0     *0       0     1|0     0.0    0.0       1 649.0M 79.0M   0|0   0|0  344b     4k    7 testrs  PRI 2016-09-13T16:01:40+10:00
      akira-macbookpro:27018     *0    *0     *0     *0       0     1|0     0.0    0.0       1 639.0M 79.0M   0|0   0|0  160b     4k    3 testrs  SEC 2016-09-13T16:01:40+10:00
      akira-macbookpro:27019     *0    *0     *0     *0       0     1|0     0.0    0.0       1 639.0M 79.0M   0|0   0|0  160b     4k    4 testrs  SEC 2016-09-13T16:01:40+10:00
       
      akira-macbookpro:27017     *0    *0     *0     *0       0     2|0     0.0    0.0       0 649.0M 79.0M   0|0   0|0  411b     4k    7 testrs  PRI 2016-09-13T16:01:45+10:00
      akira-macbookpro:27018     *0    *0     *0     *0       0     1|0     0.0    0.0       0 639.0M 79.0M   0|0   0|0  227b     4k    3 testrs  SEC 2016-09-13T16:01:45+10:00
      akira-macbookpro:27019     *0    *0     *0     *0       0     1|0     0.0    0.0       0 639.0M 79.0M   0|0   0|0  227b     4k    4 testrs  SEC 2016-09-13T16:01:45+10:00
       
      akira-macbookpro:27017   4000    *0     *0     *0      25    14|0     0.3    0.3       0 694.0M 107.0M   0|0   0|0    1m     3m   10 testrs  PRI 2016-09-13T16:01:50+10:00
      akira-macbookpro:27018  *4000    *0     *0     *0       0     1|0     0.3    0.3       0 670.0M 104.0M   0|0   0|0  160b     4k    3 testrs  SEC 2016-09-13T16:01:50+10:00
      akira-macbookpro:27019  *3994    *0     *0     *0       0     1|0     0.3    0.3       0 671.0M 104.0M   0|0   0|1  160b     4k    4 testrs  SEC 2016-09-13T16:01:50+10:00
       
      akira-macbookpro:27017  28000    *0     *0     *0     189    87|0     2.0    2.0       0 831.0M 244.0M   0|0   0|0    9m    24m   11 testrs  PRI 2016-09-13T16:01:55+10:00
      akira-macbookpro:27018 *28000    *0     *0     *0       0     1|0     1.7    1.7       0 813.0M 238.0M   0|0   0|0  227b     4k    3 testrs  SEC 2016-09-13T16:01:55+10:00
      akira-macbookpro:27019 *28005    *0     *0     *0       0     1|0     1.9    1.9       0 812.0M 237.0M   0|0   0|0  227b     4k    4 testrs  SEC 2016-09-13T16:01:55+10:00
       
      akira-macbookpro:27017  29907    *0     *0     *0     202   100|0     3.8    3.8       0 975.0M 389.0M   1|0   0|1    9m    25m   11 testrs  PRI 2016-09-13T16:02:00+10:00
      akira-macbookpro:27018 *29049    *0     *0     *0       0     1|0     3.4    3.4       0 936.0M 362.0M   1|0   0|0  160b     4k    3 testrs  SEC 2016-09-13T16:02:00+10:00
      akira-macbookpro:27019 *29022    *0     *0     *0       0     1|0     3.4    3.4       0 937.0M 362.0M   0|0   0|1  160b     4k    4 testrs  SEC 2016-09-13T16:02:00+10:00
       
      akira-macbookpro:27017  28092    *0     *0     *0     189    92|0     5.5    5.5       0   1.1G 524.0M   0|0   0|0   10m    24m   11 testrs  PRI 2016-09-13T16:02:05+10:00
      akira-macbookpro:27018 *28950    *0     *0     *0       0     1|0     4.8    4.8       0   1.0G 474.0M   0|0   0|0  227b     4k    3 testrs  SEC 2016-09-13T16:02:05+10:00
      akira-macbookpro:27019 *28977    *0     *0     *0       0     1|0     5.0    5.0       0   1.0G 491.0M   0|0   0|0  227b     4k    4 testrs  SEC 2016-09-13T16:02:05+10:00
       
      akira-macbookpro:27017  28537    *0     *0     *0     172    91|0     7.2    7.2       0   1.2G 663.0M   0|0   0|1    9m    24m   11 testrs  PRI 2016-09-13T16:02:10+10:00
      akira-macbookpro:27018 *28264    *0     *0     *0       0     1|0     6.4    6.4       0   1.1G 602.0M   0|0   0|1  171b     4k    3 testrs  SEC 2016-09-13T16:02:10+10:00
      akira-macbookpro:27019 *28212    *0     *0     *0       0     1|0     6.5    6.5       0   1.2G 612.0M   0|0   0|2  171b     4k    4 testrs  SEC 2016-09-13T16:02:10+10:00
       
      akira-macbookpro:27017   1462    *0     *0     *0       5     5|0     7.3    7.3       0   1.2G 671.0M   0|0   0|0  658k     1m    9 testrs  PRI 2016-09-13T16:02:15+10:00
      akira-macbookpro:27018  *1735    *0     *0     *0       0     1|0     6.5    6.5       0   1.2G 611.0M   0|0   0|0  227b     4k    3 testrs  SEC 2016-09-13T16:02:15+10:00
      akira-macbookpro:27019  *1787    *0     *0     *0       0     1|0     6.6    6.6       0   1.2G 621.0M   0|0   0|0  227b     4k    4 testrs  SEC 2016-09-13T16:02:15+10:00
       
      akira-macbookpro:27017     *0    *0     *0     *0       0     1|0     7.3    7.3       0   1.2G 671.0M   0|0   0|0  344b     4k    9 testrs  PRI 2016-09-13T16:02:20+10:00
      akira-macbookpro:27018     *0    *0     *0     *0       0     1|0     6.5    6.5       0   1.2G 611.0M   0|0   0|0  160b     4k    3 testrs  SEC 2016-09-13T16:02:20+10:00
      akira-macbookpro:27019     *0    *0     *0     *0       0     1|0     6.6    6.6       0   1.2G 621.0M   0|0   0|0  160b     4k    4 testrs  SEC 2016-09-13T16:02:20+10:00
      

      This printing behaviour is obviously a trivial difference (zero is zero either way) but it does make it hard for people to work it out themselves what the asterisk is meant to mean. Could this be fixed?

        Attachments

          Activity

            People

            Assignee:
            backlog-server-tools Backlog - Server Tools Team
            Reporter:
            akira.kurogane Akira Kurogane
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: