@Max Kostikov 6M is a lot :astonished_face:
Mostly convo right?
Mostly convo right?
Comment on @Hubzilla Support Forum If you are under reliatively fresh MySQL 8 then try
kostikov@zotum.net@zotum.net 2 days ago @Mario Vavti
It was this one on the queue with 6M+ tasks
The MySQL version is 8.0.46
It was this one on the queue with 6M+ tasks
SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE SKIP LOCKED;The MySQL version is 8.0.46
mario@hub.somaton.com@hub.somaton.com 2 days ago
- @Mario Vavti That's right. But the queue moves along normally after the index is added.
Yes, it seems everything works fine even without `worker_id`. Perhaps, to ensure compatibility with older versions of MySQL, you could also omit `DESC`.