Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-37193

N1QL request rate graph shows incorrect data

    XMLWordPrintable

Details

    • Untriaged
    • Unknown

    Description

      I noticed that "N1QL request rate" graph in UI shows incorrect data when I was creating indexes using cbq utility.

      Graph shows I have roughly 0.4 req per sec but actually I execute about 1 request per 10 sec (since execution of 1 command takes ~10 sec).

      In the beginning of the process when I was creating 1 index every 3 sec, the graph showed me from 1 to 3 query requests per second.

      Please see graph on screenshot attached.

      Command that I use for index creation is the following:

      $ for i in {201..300}; do time ./cbq -u Administrator -p asdasd -engine=http://127.0.0.1:9000/ -script "create index index${i} on \`test1\`(address)"; done
       
      ...
       
       Connected to : http://127.0.0.1:9000/. Type Ctrl-D or \QUIT to exit.
       
       Path to history file for the shell : /Users/timofeybarmin/.cbq_history
       
       create index index288 on `test1`(address)
      {
          "requestID": "adb17bd2-fd99-4a06-b49c-e25315becd53",
          "signature": null,
          "results": [
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "10.381078442s",
              "executionTime": "10.381003414s",
              "resultCount": 0,
              "resultSize": 0
          }
      }
       
      real	0m10.491s
      user	0m0.016s
      sys	0m0.078s
      ...
      

       

      Assigning to query for initial investigation.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            kamini.jagtiani Kamini Jagtiani
            timofey.barmin Timofey Barmin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty