Server performance declining constantly

  1. Good question - but the answer is - I do, cause I measured. I am pulling a batch (a 1000 in this case) of records from the other DB, and then doing the “insert/update” in couchbase per record, and repeat. Pulling the 1000 from the other DB into memory takes <1s. Putting the thousand into couch takes up to few minutes.
  2. I’m still not sure how to read those results. Will look into it. Any specific pointers? or entries to look for?
  3. Attached
  4. “cache-miss ratio” grew at the beginning and stabled around 20%
    “Active resident %” started at 100% (expected) but dropped sharply and stabled around 5%
    “disk reads per sec” has a similar pattern then the total ops decrease (but more jagged). seems to stable around 2.5 only
    "disk write queue" ALSO dropped with the same shape, very sharp, and is around 2.8. If that was higher it will explain - couch is waiting for the disk. but it’s not…

IMG_month_full_screen