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
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
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