Uploaded image for project: 'StoRM'
  1. StoRM
  2. STOR-776

Inefficient SQL query for surl status checks

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.11.8
    • 1.11.7
    • backend
    • Security Level: Public (Visbile by non-authn users.)
    • None

      The query used to check if a SURL is pinned does not leverage the index built on the SURL hash value, resulting in all the rows being checked by MySQL to get the status of the SURL.

      This causes unnecessary high load on the MySQL server and slows down request handling

            Unassigned Unassigned
            aceccant Andrea Ceccanti
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: