Uploaded image for project: 'MidPoint'
  1. MidPoint
  2. MID-2514

Cleanup task for audit events is running slowly for thousands records

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.2 (Tycho)
    • Fix Version/s: 3.3 (Lincoln)
    • Component/s: Repository
    • Labels:
      None

      Description

      Deleting thousands rows in tables m_audit_deltas and m_audit_events is running very slowly and in one big transaction.

      Suggestions to improve performance:

      • Delete audit records without temporary table
      • Create index on timestampValue column in m_audit_event table
      • Divide one large transaction into several smaller (or delete records without transactions)

        Attachments

          Activity

            People

            • Assignee:
              rpudil Roman Pudil
              Reporter:
              rpudil Roman Pudil
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: