Invention Grant
- Patent Title: Lock wait tracing
-
Application No.: US17089355Application Date: 2020-11-04
-
Publication No.: US11698898B2Publication Date: 2023-07-11
- Inventor: Piyush Kumar Jain Mahendra Kumar , Mark F. Wilding , James E. Mace , Thomas Fanghaenel
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: Salesforce, Inc.
- Current Assignee: Salesforce, Inc.
- Current Assignee Address: US CA San Francisco
- Agency: Kowert, Hood, Munyon, Rankin & Goetzel, P.C.
- Agent Mark D. Seegers; Dean M. Munyon
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/22

Abstract:
Techniques are disclosed relating to lock wait tracing. A computer system may operate a database that includes a lockable object. The computer may maintain a lock wait queue that stores an indication of processes waiting to acquire a lock on the lockable object. The computer system may store trace records for those processes that, upon releasing a respective lock on the lockable object when another process is waiting in the lock wait queue, have been in contention for the respective lock for over a threshold amount of time. The computer system may present ones of the trace records that identify a timeline that is usable to determine a set of processes that contributed to a delay in a process acquiring a lock on the lockable object.
Public/Granted literature
- US20220138175A1 LOCK WAIT TRACING Public/Granted day:2022-05-05
Information query