Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-1674

add daemon to trim auditing table

    XMLWordPrintable

Details

    • New Feature
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 2.3.1, 2.4.0, 2.3.0.patch
    • grouperLoader
    • None

    Description

      Penn currently has 11,685,969 records in grouper_audit_entry_v
      addGroupMemberhip and deleteGroupMembership has 80% of the entries
      99% of entries have no logged_in_subject_id
      99% are loader, blank, grouperShell
      30% are blank user id
      70k are from the UI less than 1%
      we could delete any record over 5 years if people want (we have 90k records older than 5 years which are grouperUI or grouperWS)

      select count(1) from grouper_audit_entry_v;
       
      select GAEV.ACTION_NAME, count(*) from grouper_audit_entry_v gaev group by gaev.action_name;
       
      select GAEV.LOGGED_IN_SUBJECT_ID, count(*) from grouper_audit_entry_v gaev group by GAEV.LOGGED_IN_SUBJECT_ID;
       
      select GAEV.GROUPER_ENGINE , count(*) from grouper_audit_entry_v gaev group by GAEV.GROUPER_ENGINE;
       
      select  count(*) from grouper_audit_entry_v gaev where GAEV.ACT_AS_MEMBER_ID is null and GAEV.LOGGED_IN_MEMBER_ID is null;
       
      select  count(*) from grouper_audit_entry_v gaev where GAEV.GROUPER_ENGINE = 'grouperUI';
       
      select  count(*) from grouper_audit_entry_v gaev where GAEV.GROUPER_ENGINE in ('grouperUI', 'grouperWS') and GAEV.CREATED_ON < 1357016400000;
      

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist