qrtz_scheduler_state.md
1.06 KB
qrtz_scheduler_state
存储集群中note实例信息，quartz会定时读取该表的信息判断集群中每个实例的当前状态
- Rows (estimated): 1
- Data size: 16.0 KB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:55:02
- Updated: 2026-04-27 18:55:02
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | SCHED_NAME |
varchar(120) |
NO | PRI | 调度名称 | ||
| 2 | INSTANCE_NAME |
varchar(200) |
NO | PRI | 之前配置文件中org.quartz.scheduler.instanceId配置的名字，就会写入该字段 | ||
| 3 | LAST_CHECKIN_TIME |
bigint |
NO | 上次检查时间 | |||
| 4 | CHECKIN_INTERVAL |
bigint |
NO | 检查间隔时间 |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
PRIMARY |
✓ | BTREE |
SCHED_NAME, INSTANCE_NAME
|
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.