Comment on @Hubzilla Support Forum If you are under reliatively fresh MySQL 8 then try

mario@hub.somaton.com@hub.somaton.com ⁨1⁩ ⁨day⁩ ago

• kostikov@zotum.net@zotum.net ⁨1⁩ ⁨day⁩ ago

  @Mario Vavti
  Yes, it seems everything works fine even without `worker_id`. Perhaps, to ensure compatibility with older versions of MySQL, you could also omit `DESC`.

  original

  • mario@hub.somaton.com@hub.somaton.com ⁨1⁩ ⁨day⁩ ago

    @Max Kostikov do you mean without workerq_id or without workerq_reservationid?

    original

    • kostikov@zotum.net@zotum.net ⁨1⁩ ⁨day⁩ ago

      @Mario Vavti
      Without `worker_id`, since omitting `worker_reservationid` did not have a positive effect.
      ALTER TABLE workerq ADD INDEX idx_claim (workerq_reservationid, workerq_priority DESC);

      original

      • mario@hub.somaton.com@hub.somaton.com ⁨1⁩ ⁨day⁩ ago

        @Max Kostikov ah... that is somehow suprising...
        
        Anyway, i think i will go with

        ALTER TABLE workerq
            ADD INDEX idx_claim (
                workerq_reservationid,
                workerq_priority DESC,
                workerq_id ASC
            );

        as you suggested first.

        original