Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] adding large group as member group is slow

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] adding large group as member group is slow


Chronological Thread 
  • From: Shilen Patel <>
  • To: Jim Fox <>
  • Cc: Chris Hyzer <>, grouper users list <>
  • Subject: Re: [grouper-users] adding large group as member group is slow
  • Date: Tue, 4 Dec 2012 17:56:59 +0000
  • Accept-language: en-US

Similar question: Is groupB a member of many groups or does groupB have a
lot of privileges to other groups/stems?

Also, what client were you using when making this update (admin UI, lite
UI, your own UI, web services, GSH/API)? If you haven't tried with GSH,
can you try there too? Maybe you can set hibernate.show_sql=true and see
if there's a particular query that's stalling or if there's a continuous
loop of sql statements.

Thanks!

-- Shilen

On 12/4/12 12:02 PM, "Jim Fox"
<>
wrote:

>>
>> A few questions to try to narrow down the problem:
>>
>> Does groupA have many members that are groups (either directly or
>> indirectly)? If so, the issue may be related to many groupSets being
>> added.
>
>No, groupA is just people.
>
>>
>> Is groupB a factor in any composite (either directly or indirectly)? If
>> so, the issue may be related to many composite memberships being added
>> (possibly 150K for each composite group).
>
>No, we don't use composites.
>
>>
>> What do you have groups.updateLastMembershipTime set to?
>
>groups.updateLastMembershipTime = false
>
>>
>> Did you try analyzing all the grouper tables?
>>
>
>Not just before this, but I believe our DBAs do an analyze once a week.
>
>Jim
>
>
>> Thanks!
>>
>> -- Shilen
>>
>> On 12/3/12 4:58 PM, "Jim Fox"
>> <>
>> wrote:
>>
>>>
>>> version 1.6.1
>>>
>>> Jim
>>>
>>>
>>> On Mon, 3 Dec 2012, Chris Hyzer wrote:
>>>
>>>> Date: Mon, 3 Dec 2012 13:55:40 -0800
>>>> From: Chris Hyzer
>>>> <>
>>>> To: Jim Fox
>>>> <>,
>>>> grouper users list
>>>> <>
>>>> Subject: RE: [grouper-users] adding large group as member group is
>>>>slow
>>>>
>>>> What grouper version are you using exactly?
>>>>
>>>> -----Original Message-----
>>>> From:
>>>>
>>>> [mailto:]
>>>> On Behalf Of Jim Fox
>>>> Sent: Monday, December 03, 2012 4:51 PM
>>>> To: grouper users list
>>>> Subject: [grouper-users] adding large group as member group is slow
>>>>
>>>>
>>>> Suppose groupA has membership of 150K members.
>>>>
>>>> I add groupA as a member to groupB.
>>>>
>>>> That add takes several hours.
>>>>
>>>> What's going on?
>>>> Is there any configuration that would speed it up?
>>>> Are any tables locked during the add?
>>>>
>>>> Thanks,
>>>>
>>>> Jim
>>>>
>>>>
>>
>>




Archive powered by MHonArc 2.6.16.

Top of Page