[midPoint] AWS - RDS Postgres - DB - Very Slow
Gus Lou
gugalou38 at gmail.com
Thu Feb 4 14:04:51 CET 2021
Hi Pavol
Great,
I will make this adjustment to see analyze the result
Regards
Gus
Em qui., 4 de fev. de 2021 às 09:56, Pavol Mederly via midPoint <
midpoint at lists.evolveum.com> escreveu:
> Hello Gus,
>
> I meant this:
>
> (it is in the sysconfig object)
>
> The result then looks like this (or very similar - I am using 4.3-SNAPSHOT
> here):
>
> Note that performance tuning is quite complex process, and so,
> unfortunately, we are not able to do that through this public mailing list.
> I suggest engaging our professional services for that.
>
> Best regards,
> Pavol
> On 04/02/2021 13:02, Gus Lou via midPoint wrote:
>
> Hi Pavol
>
> I did not find the informed path:
> internals / repository / statistics / classification sysconfig property
> Is this configuration in the midpoint web interface?
>
> Regards
>
> Gus
>
>
> Em qui., 4 de fev. de 2021 às 06:55, Pavol Mederly via midPoint <
> midpoint at lists.evolveum.com> escreveu:
>
>> Hi Gus,
>>
>> In the production environment with AWS RDS DB the timing of some actions
>> seems to me to be very high.
>>
>> Are you reading the right numbers? Because the most important are the
>> *avg:* values.
>>
>> You can also (temporarily) enable recording values not only per
>> operation, but also per object type. So you will be able to compare e.g.
>> modifyObject times for e.g. user and task objects separately. Please see
>> *internals/repository/statistics/classification* sysconfig property and
>> its *perOperationAndObjectType* value.
>>
>> Best regards,
>> Pavol
>> On 03/02/2021 14:35, Gus Lou via midPoint wrote:
>>
>> Hi Guys
>> Some Information:
>> Comparative - Midpoint Test vs Midpoint Prod
>> From Midpoint -> Internals Configuration -> Performance
>>
>> Midpoint-Test (Midpoint App (01 node) and DB all single instance)
>> Repository performance information:
>> audit: count: 1, total time: 27 ms [min:
>> 27, max: 27, avg: 27.0]
>> cleanupAuditMaxAge: count: 1, total time: 386 ms [min:
>> 386, max: 386, avg: 386.0]
>> countContainers: count: 12, total time: 194 ms [min:
>> 2, max: 97, avg: 16.2]
>> countObjects: count: 6, total time: 281 ms [min:
>> 4, max: 147, avg: 46.8]
>> deleteObject: count: 1, total time: 303 ms [min:
>> 303, max: 303, avg: 303.0]
>> fetchExtItems: count: 1, total time: 62 ms [min:
>> 62, max: 62, avg: 62.0]
>> getObject: count: 390, total time: 12245 ms [min:
>> 1, max: 5602, avg: 31.4]
>> getVersion: count: 32, total time: 173 ms [min:
>> 0, max: 23, avg: 5.4]
>> modifyObject: count: 80, total time: 8911 ms [min:
>> 7, max: 521, avg: 111.4], wasted time for 1 retry/retries: 276
>> ms [min: 0, max: 276, avg: 3.5] ( 3.10%)
>> searchContainers: count: 1, total time: 142 ms [min:
>> 142, max: 142, avg: 142.0]
>> searchObjects: count: 54, total time: 1737 ms [min:
>> 1, max: 332, avg: 32.2]
>> searchShadowOwner: count: 16, total time: 86 ms [min:
>> 1, max: 13, avg: 5.4]
>>
>>
>>
>> Midpoint Prod (Midpoint App (02 Nodes) and AWD RDS DB)
>> Repository performance information:
>> countContainers: count: 20, total time: 80 ms [min: 1,
>> max: 25, avg: 4.0]
>> countObjects: count: 7, total time: 118 ms [min: 2,
>> max: 97, avg: 16.9]
>> getObject: count:1081559, total time: 2099910 ms [min: 1,
>> max: 7652, avg: 1.9]
>> getVersion: count: 51009, total time: 73060 ms [min: 0,
>> max: 35, avg: 1.4]
>> modifyObject: count: 47729, total time: 322292 ms [min: 5,
>> max: 662, avg: 6.8]
>> searchObjects: count: 52523, total time: 75512 ms [min: 1,
>> max: 148, avg: 1.4]
>>
>> In the production environment with AWS RDS DB the timing of some actions
>> seems to me to be very high.
>> I continue to analyze, when I have news I share here.
>> Regards
>> Gus
>>
>>
>> Em qua., 3 de fev. de 2021 às 09:22, Gus Lou <gugalou38 at gmail.com>
>> escreveu:
>>
>>> Hi Guys
>>>
>>> Does anyone here use Amazon RDS for PostgreSQL for midpoint database?
>>> I started testing this service and all midpoint access were very slow. I
>>> am investigating the cause, but if anyone has any experience in using
>>> database solutions as a service in conjunction with midpoint and can share
>>> I appreciate it.
>>>
>>> My Settings:
>>> Midpoint: 4.2
>>> Midpoint Nodes: 02
>>> OpenJDK: 11
>>> Postgres (AWS RDS): 11.8
>>> AWS Region: east2
>>> Instance Class: DB.m5.large
>>>
>>> Regards
>>>
>>> Gus
>>>
>>>
>> _______________________________________________
>> midPoint mailing listmidPoint at lists.evolveum.comhttps://lists.evolveum.com/mailman/listinfo/midpoint
>>
>> --
>> Pavol Mederly
>> Software developerevolveum.com
>>
>> _______________________________________________
>> midPoint mailing list
>> midPoint at lists.evolveum.com
>> https://lists.evolveum.com/mailman/listinfo/midpoint
>>
>
> _______________________________________________
> midPoint mailing listmidPoint at lists.evolveum.comhttps://lists.evolveum.com/mailman/listinfo/midpoint
>
> --
> Pavol Mederly
> Software developerevolveum.com
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20210204/85f7970b/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mcalpifiaddalflm.png
Type: image/png
Size: 21987 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20210204/85f7970b/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kccmmmajblcjamcj.png
Type: image/png
Size: 48583 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20210204/85f7970b/attachment-0003.png>
More information about the midPoint
mailing list