Grouper Users - Open Discussion List

[Siju Jacob <>]

Hi Chris,

   I just joined the grouper slack.

 

Thanks,

Siju Jacob

 

From: Hyzer, Chris <>
Sent: Wednesday, March 17, 2021 1:19 PM
To: ; Siju Jacob <>
Subject: Re: performance issue with grouper 2.4

 

are you on slack to discuss this there?

 

It shouldnt take that long.  How long does the query take to return the results in a SQL client?

 

Is the database located in the same data center as the app server?

 

Have analyzed the tables/indexes recently?

 

It should be fast without an upgrade but do you have plans for an upgrade?

 

Thanks!

Chris

---

From: <> on behalf of Siju Jacob <>
Sent: Tuesday, March 9, 2021 10:32 AM
To: <>
Subject: [grouper-users] performance issue with grouper 2.4

 

Hi Team,

     We are using grouper 2.4 with latest updates. We are trying to scale our grouper to enterprise level. We are facing some performance issues.

    While trying to run the loaders with below configuration its taking days for a loader to load all members in grouper from source system.

 

    We are running on JDK 1.8 , Linux system with X86 Large - 4vCPU 16GB Mem and Centos, Oracle 11g database.

 

Please let me know what will be the ideal hardware configurations based on your experience for the enterprise level grouper with below mentioned load.

 

 

First time loading of a student group with 75,000 members take 24 hours.

Subsequent run of the same loader with no update take 7 hours to complete

 

Below is the loader email report.

 

-----------------------------------------------------------------------

environment:           TEST

memberships:           15,589,329

groups:                54,113

members:               733,651

folders:               6,326

unresolvable subjects: 3

bad memberships:       0

 

 

----------------

WITHIN LAST DAY:

----------------

new memberships:       4,217,129

new groups:            5

updated groups:        0

new folders:           0

 

----------------

LOADER SUMMARY WITHIN LAST DAY

----------------

jobs:                  16,923

started:               3

errors:                226

unresolvable subjects: 0

inserts:               468,662

updates:               0

deletes:               5

total loader mships:   1,084,974

processing time:       7d, 23h, 34m, 40s, 367ms

 

--------------------------------------------

GROUPER INFO

----------------------------------------

version: 2.4.0, build date: 2018/08/23 07:48:38, env: TEST

os.name: Linux

os.arch: amd64

os.version: 3.10.0-1160.15.2.el7.x86_64

java.version: 1.8.0_282

java.vendor: Red Hat, Inc.

java.class.path: /opt/grouper/grouper.apiBinary-2.4.0

heapSize: 1 GB

heapMaxSize: 4 GB

heapSizeFree: 50 MB

 

privileges.access.cache.interface:

privileges.naming.cache.interface:

groups.wheel.use: true

groups.wheel.group: etc:sysadmingroup

 

 

    

Any advice or guidance will be of great help and would be greatly appreciated..!

 

 

Thanks,

Siju Jacob