Comment on Markus wrote the following post Wed, 21 Oct 2026 13:22:48 +0200

kostikov@zotum.net@zotum.net ⁨1⁩ ⁨week⁩ ago

@Hubzilla Support Forum
If you are under reliatively fresh MySQL 8 then try to add this index
ALTER TABLE workerq ADD INDEX idx_claim (workerq_reservationid, workerq_priority DESC, workerq_id);
In my case, on the `dev` branch of Hubzilla, this significantly improved the performance of the queueworker from tens of seconds to a couple hundred milliseconds.
UPD: CPU usage has also dropped sharply.

FYI @Mario Vavti

original
Sort:hotnewtop