Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-2700

Improve termtagging performance due table locks

    XMLWordPrintable

Details

    • Critical
    • The queuing of the segments prepared for term tagging is improved, so that multiple term taggers really should work in parallel.

    Description

      problem

      The termtagger import workers are running in parallel, but they are waiting on each other due the locking of the LEK_segments_meta table.

      solution

      This could be solved by using SKIP LOCKED after the SELECT FOR UPDATE clause in the loadUntaggedSegmentIds method, which is possible with Mysql 8 / mariadb 10.6.

      Attachments

        Activity

          People

            tlauria Thomas Lauria
            tlauria Thomas Lauria
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: