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: Jim Fox <>
  • To: Shilen Patel <>
  • Cc: Chris Hyzer <>, grouper users list <>
  • Subject: Re: [grouper-users] adding large group as member group is slow
  • Date: Tue, 4 Dec 2012 20:50:26 -0800


It's our own UI, but making a standard grouper API call. The groupB is also
simple.

I'm doing some more testing.

Jim

On Dec 4, 2012, at 9:56 AM, Shilen Patel wrote:

> 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