We have a lock contention of more than 50,000 executions on qrtz_locks table. quartz 2.1.7 version is being used.
Application is running on 3 nodes in a clustered environment.
34 jobs are being executed every 6 seconds, means total number of times
the jobs were triggered in 1 hour in each node is 20400. so for 3 nodes the following query would be executed morethan 60000.
SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'Scheduler1' AND LOCK_NAME = :1 FOR UPDATE
It is impacting the performance of the DB. How can i reduce the lock contention ? Can i have multiple schedulers with in a cluster ?
current qrtz_locks table has following entries ,
TRIGGER_ACCESS
STATE_ACCESS
Any other entries would reduce the lock contention ?
|