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

Submitted ⁨⁨3⁩ ⁨weeks⁩ ago⁩ by ⁨adminsforum@hubzilla.org [bot]⁩ to ⁨adminsforum@hubzilla.org⁩

MarkusMarkus wrote the following post Wed, 21 Oct 2026 13:22:48 +0200

Hubzilla isn't running well right now. The database and, at times, the queue are running significantly slower than usual. Have you noticed this, too?

Comments

Sort:hotnew top

sk@utsukta.org ⁨3⁩ ⁨weeks⁩ ago
on my hub enabling pubstream adds a lot to cpu load which contributes to this, irrespective of what theme i use. So disabling pubstream or keeping it local only helps.
original
kostikov@zotum.net@zotum.net ⁨3⁩ ⁨weeks⁩ 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
- mario@hub.somaton.com@hub.somaton.com ⁨1⁩ ⁨week⁩ ago
  @Max Kostikov i have just pushed the update. Make sure to review your DB after next pull so you will not end up with duplicate indices...
  original
  - kostikov@zotum.net@zotum.net ⁨1⁩ ⁨week⁩ ago
    @Mario Vavti Thank you, I will do.
    original