Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Changelog size issues when applying Grouper privilege rules

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Changelog size issues when applying Grouper privilege rules


Chronological Thread 
  • From: Shilen Patel <>
  • To: Robert Bradley <>, "" <>
  • Subject: Re: [grouper-users] Changelog size issues when applying Grouper privilege rules
  • Date: Wed, 1 Apr 2015 16:25:21 +0000
  • Accept-language: en-US
  • Authentication-results: it.ox.ac.uk; dkim=none (message not signed) header.d=none;

Do you need privileges to be in the change log? If not, then set
changeLog.includeFlattenedPrivileges=false in grouper-loader.properties.

Thanks!

- Shilen

On 4/1/15, 12:18 PM, "Robert Bradley"
<>
wrote:

>On 01/04/15 17:16, Robert Bradley wrote:
>> The problem I'm seeing is that when the rules are applied, the
>> change log table size increases massively to 26 million records or
>> more (~11 GB for the table, with changelog indexes of >24 GB). This
>> caused problems with disk space, but also creates huge multi-day lags
>> in provisioning new group members using PSP until the changelog
>> clears.
>>
>
>As a followup to my previous email, I have tried the following to
>improve matters slightly, but without much success:
>
>- Reducing changelog retention time from 14 days.
>- Removing the indexes on the string* columns in
>grouper_change_log_entry since the indexes were not being used. This
>does reduce the disk space used and the rate of increase, but is not a
>full solution.
>- ANALYZE and VACUUM ANALYZE to improve query plans and clean up unused
>space. This did nothing.
>
>--
>Dr Robert Bradley
>Identity and Access Management, IT Services, University of Oxford
>




Archive powered by MHonArc 2.6.16.

Top of Page