Grouper Users - Open Discussion List

[Richard Frovarp <>]

Possibly increasing max connections in MariaDB, but if it is going for 20k threads, that's a little crazy.

Yes, I'm doing a group list. It's the other setting that makes me think it is multiplying out:

# if should use threads in the loader for each group in a group of groups
loader.use.groupThreads=true

So since that is true, I think it is using the groupThreadPoolSize for each department for instance. Which even for departments, 90 departments * 20 groupThreadPoolSize equals 1,800 connections. I'm guessing that I'm going to bottleneck on something else even if I up MariaDB to 2k connections.

On 1/7/19 4:52 PM, Hyzer, Chris wrote:

You can decrease the thread pool size if you want.  But maybe you should also increase the max_connections var in mariadb...

 

The docs in the config say its one pool for each list of groups job, is that the type of job you are running?

 

# number of threads to use for each list of groups job (not shared among jobs)

# {valueType: "integer", required: true}

loader.groupThreadPoolSize=20

 

 

Thanks

Chris

 

-----Original Message-----
From: On Behalf Of Richard Frovarp
Sent: Monday, January 07, 2019 5:12 PM
To:
Subject: [grouper-users] Performance tuning guide?

 

Is there a performance tuning guide somewhere. I know to kick up the

memory offered to Tomcat. That helped out a good amount for the UI.

 

In particular at the moment I'm having trouble with the loader. I'm

trying to load in our legacy groups for lack of a better term, and it's

firing up way too many threads. We have around 1k legacy groups. I can

see from jconsole that it's easily starting over 200 pool threads. Then

they start to time out, and MariaDB starts to complain about too many

connections. I see in the loader config file reference to

loader.use.groupThreads, and loader.groupThreadPoolSize, but not

entirely sure how they work.

 

loader.use.groupThreads means that it is trying to use threads for each

of my 1k groups? And loader.groupThreadPoolSize means it is trying to

use 20 threads for each group? So is it trying to start 20k threads?

That would seem to indicate that the right option would be to set

loader.use.groupThreads to false. Or is there something else? I've hit

the same problem trying to load departments, and we're a mid-sized school.

 

Is there anything else to performance tune the system?

 

Thanks,

 

Richard