[midPoint] AWS - RDS Postgres - DB - Very Slow

[Gus Lou]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20210203/15e0d22a/attachment.htm>