Question

Which of the following represents number of times the operation acquired the lock in the specified mode?

(a) system.profile.locks.acquireCount

(b) system.profile.locks.acquireWaitCount

(c) system.profile.locks.Count

(d) none of the mentioned

The question was posed to me during an interview for a job.

My doubt stems from Database Profiler topic in division Production Checklist, Security Concepts and Network Security of MongoDB

Answer 1

Right answer is (a) system.profile.locks.acquireCount

To elaborate: system.profile.locks.acquireWaitCount is number of times the operation had to wait for the acquireCount lock acquisitions because the locks were held in a conflicting mode. acquireWaitCount is less than or equal to acquireCount.