grouper-users - Re: [grouper-users] Re: Performance tuning guide?
Subject: Grouper Users - Open Discussion List
List archive
- From: Shilen Patel <>
- To: "Hyzer, Chris" <>, Richard Frovarp <>
- Cc: "" <>
- Subject: Re: [grouper-users] Re: Performance tuning guide?
- Date: Tue, 8 Jan 2019 01:56:42 +0000
- Accept-language: en-US
- Authentication-results: mail-gw.oit.duke.edu; spf=none ; dmarc=none
- Ironport-phdr: 9a23:V4FjRReC1pK2Eh1L+4C0vTXalGMj4u6mDksu8pMizoh2WeGdxcS9bB7h7PlgxGXEQZ/co6odzbaO4+a4ASQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9HiTahYr5+Ngm6oRnMvcQKnIVuLbo8xAHUqXVSYeRWwm1oJVOXnxni48q74YBu/SdNtf8/7sBMSar1cbg2QrxeFzQmLns65Nb3uhnZTAuA/WUTX2MLmRdVGQfF7RX6XpDssivms+d2xSeXMdHqQb0yRD+v9LlgRgP2hygbNj456GDXhdJ2jKJHuxKquhhzz5fJbI2JKPZye6XQds4YS2VcRMZcTyxPDJ2hYYsTAeQPPuhXr4jhqFQBthaxHxWgBOb1xzNUnHL736s32PkhHwHc2wwgGsoDvmnUrNX0MKcdT+a1x7TSwzrZc/NZxzP945XPfxA6ofGMXLZwftTXyUQ0CgzFk1aQppL/MzyLy+sNrnGW4ux9Xuysk24qsxx9rzixyss2hITFnJ8Zx1PA+Clj3oo4K961RFZmbdOmDpdcrSOXOoRsTs8/X21kpDw2xqAItJKmZCQKxoooyh3DZ/GCdoWE/xHuW/yTLDp9hH9odrOyiAu3/EWg1uLxUsy530xWoiVejtXBsG0G2QbJ5cidUPR9+1+s2TaR2ADX7eFJOUU0mrDaK54l27IwmZQSvV3eEiPogkn2i66Wdlk+9ue19uTnYavpqoWCOIBplwHyKqUumsqhDuQkKgUCQmiW9fqm2LDt50H1XbZHg/ksnqXHvp3XJtwXpqujDA9U1oYj5Qy/DzCj0NkAhnkHLFNFeBaZgIjvIFzBPe34DfShjFi2jjhk2u3GMqX7AprRNnjDjKvhfbFl5k5T0gozys1f54pKBbEbOf7zR1Txu8LCDh8iKAG0x+fnCM5h1oMFR26DGK6ZMKXOsVCW/OIvJfeDZJMLtDrnNfcq+uPu3jcFngpXXbi70IFTIFu4BPV9aQ3NZHHsk8UMC08LpQF4UfTnjlvEXDJOMTL6ZaM35jghBMqIF4DdT5q1yOib3Sy7F4daIG5cDU6FC2/AcYmfRrEBZD/EceF7lTlRbrigT4InnSmnqAL+g+58LuvQ9yswuY/g2Z546/CFxkJ6ziB9E8nIizLFdGpzhG5dAmZuhPol80Vg1leO17R5iPVEFNtVoulESRo+KYWDkb5/AtH2Hw3eONCIVBCqX9arRzw9U4FUob4Ve0goHdKkg1jY2jayRboclriFHpsxp7nc3nz8Ie5x1nXLkqQtkgpDIKpDMGS8jft58A7eCg==
- Spamdiagnosticmetadata: NSPM
- Spamdiagnosticoutput: 1:99
Right if it’s a single group list, then it should be 20 total (not 20 per group in the group list). However, there’s also loader.membershipThreadPoolSize. # number of threads to use for each group job (not shared among jobs) loader.membershipThreadPoolSize=10 So I think each of those 20 threads might use up to 10 threads (by default) if you have a lot of membership changes. Thanks! - Shilen From:
<> on behalf of "Hyzer, Chris" <> I dont think thats how it works but Shilen can confirm From: <> on behalf of 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 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:
|
- Re: [grouper-users] Re: Performance tuning guide?, Shilen Patel, 01/08/2019
- Re: [grouper-users] Re: Performance tuning guide?, Richard Frovarp, 01/08/2019
Archive powered by MHonArc 2.6.19.