[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
[Expert]
Messages posted by: rssviswa  XML
Profile for rssviswa -> Messages posted by rssviswa [1]
Author Message
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 ?
 
Profile for rssviswa -> Messages posted by rssviswa [1]
Go to:   
Powered by JForum 2.1.7 © JForum Team