AxsrAp97

1CREATE TABLE IF NOT EXISTS `jobs` (
2    `job_id` varchar(36) NOT NULL,
3    `job_status` varchar(30) NOT NULL,
4    `created_at` datetime NOT NULL,
5    `lease_date` datetime,
6    `priority` int NOT NULL,
7    PRIMARY KEY(`job_id`),
8    INDEX `job_status_priority_lease_date` (`job_status`, `priority`, `lease_date`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 
10     
11select * from jobs 
12where job_status="IN_PROGRESS"
13and lease_date<"10minutesago"
14order by 
15priority,
16lease_date/created_at
17limit 100