页面树结构

版本比较

标识

  • 该行被添加。
  • 该行被删除。
  • 格式已经改变。

...

runningCount / totalCount 【待执行 waitingCount个】

...

Image Added

代码块
languagesql
指标说明:

运行中的计划(runningCount):
select count(1) from QRTZ_FIRED_TRIGGERS;

服务器数量(serverCount):
select count(1) from QRTZ_SCHEDULER_STATE where LAST_CHECKIN_TIME + CHECKIN_INTERVAL > unix_timestamp();

每台服务器最大并发数(threadCount):
org_quartz_threadPool_threadCount=10

totalCount = serverCount * threadCount
当 runningCount >= totalCount ,超载(waitingCount):

待执行(waitingCount)
select count(1) from QRTZ_TRIGGERS where NEXT_FIRE_TIME < unix_timestamp() and TRIGGER_STATE = 'WAITING';

...