<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hello Gus,</p>
    <p>I meant this:</p>
    <p><img src="cid:part1.F14064F9.1E0EC1FE@evolveum.com" alt=""></p>
    <p>(it is in the sysconfig object)</p>
    <p>The result then looks like this (or very similar - I am using
      4.3-SNAPSHOT here):</p>
    <p><img src="cid:part2.12AC7E59.79F23F2A@evolveum.com" alt=""></p>
    <p>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.</p>
    <p>Best regards,<br>
      Pavol<br>
    </p>
    <div class="moz-cite-prefix">On 04/02/2021 13:02, Gus Lou via
      midPoint wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+XZjGQKLPXYZSkfC2nX12viokOtaaJojptTPxSju1jQXL5kBA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">Hi Pavol<br>
          <div><br>
          </div>
          <div>
            <div>I did not find the informed path:</div>
            <div>internals / repository / statistics / classification
              sysconfig property</div>
            <div>Is this configuration in the midpoint web interface? </div>
          </div>
          <div><br>
          </div>
          <div>Regards</div>
          <div><br>
          </div>
          <div>Gus</div>
          <div><br>
          </div>
        </div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">Em qui., 4 de fev. de 2021 às
          06:55, Pavol Mederly via midPoint <<a
            href="mailto:midpoint@lists.evolveum.com"
            moz-do-not-send="true">midpoint@lists.evolveum.com</a>>
          escreveu:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px
          0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
          <div>
            <p>Hi Gus,</p>
            <p> </p>
            <blockquote type="cite"><span style="display:inline;color:rgb(0,0,0);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:18px;white-space:pre-wrap;background-color:rgb(245,245,245)" lang="en"><span><span>In the production environment with AWS RDS DB the timing of some actions seems to me to be very high.</span></span></span><span style="color:rgb(0,0,0);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:18px;white-space:pre-wrap;background-color:rgb(245,245,245)"> </span></blockquote>
            Are you reading the right numbers? Because the most
            important are the <b>avg:</b> values.
            <p>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 <b>internals/repository/statistics/classification</b>
              sysconfig property and its <b>perOperationAndObjectType</b>
              value.</p>
            <p>Best regards,<br>
              Pavol<br>
            </p>
            <div>On 03/02/2021 14:35, Gus Lou via midPoint wrote:<br>
            </div>
            <blockquote type="cite">
              <div dir="ltr">
                <div dir="ltr">
                  <div dir="ltr">
                    <div dir="ltr">
                      <div dir="ltr">Hi Guys</div>
                      <div dir="ltr">Some Information:<br>
                        <div>
                          <div>Comparative - Midpoint Test vs Midpoint
                            Prod</div>
                          <div>From Midpoint -> Internals
                            Configuration -> Performance</div>
                        </div>
                        <div><br>
                        </div>
                        <div>
                          <div>Midpoint-Test (Midpoint App (01 node) and
                            DB all single instance)</div>
                          <div>Repository performance information:</div>
                          <div>  audit:               count:      1,
                            total time:       27 ms [min:    27, max:   
                            27, avg:    27.0]</div>
                          <div>  cleanupAuditMaxAge:  count:      1,
                            total time:      386 ms [min:   386, max: 
                             386, avg:   386.0]</div>
                          <div>  countContainers:     count:     12,
                            total time:      194 ms [min:     2, max:   
                            97, avg:    16.2]</div>
                          <div>  countObjects:        count:      6,
                            total time:      281 ms [min:     4, max: 
                             147, avg:    46.8]</div>
                          <div>  deleteObject:        count:      1,
                            total time:      303 ms [min:   303, max: 
                             303, avg:   303.0]</div>
                          <div>  fetchExtItems:       count:      1,
                            total time:       62 ms [min:    62, max:   
                            62, avg:    62.0]</div>
                          <div>  getObject:           count:    390,
                            total time:    12245 ms [min:     1, max: 
                            5602, avg:    31.4]</div>
                          <div>  getVersion:          count:     32,
                            total time:      173 ms [min:     0, max:   
                            23, avg:     5.4]</div>
                          <div>  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%)</div>
                          <div>  searchContainers:    count:      1,
                            total time:      142 ms [min:   142, max: 
                             142, avg:   142.0]</div>
                          <div>  searchObjects:       count:     54,
                            total time:     1737 ms [min:     1, max: 
                             332, avg:    32.2]</div>
                          <div>  searchShadowOwner:   count:     16,
                            total time:       86 ms [min:     1, max:   
                            13, avg:     5.4]</div>
                          <div><br>
                          </div>
                          <div><br>
                          </div>
                          <div><br>
                          </div>
                          <div>Midpoint Prod (Midpoint App (02 Nodes) 
                            and AWD RDS DB)</div>
                          <div>Repository performance information:</div>
                          <div>  countContainers:  count:     20, total
                            time:       80 ms [min:     1, max:    25,
                            avg:     4.0]</div>
                          <div>  countObjects:     count:      7, total
                            time:      118 ms [min:     2, max:    97,
                            avg:    16.9]</div>
                          <div>  getObject:        count:1081559, total
                            time:  2099910 ms [min:     1, max:  7652,
                            avg:     1.9]</div>
                          <div>  getVersion:       count:  51009, total
                            time:    73060 ms [min:     0, max:    35,
                            avg:     1.4]</div>
                          <div>  modifyObject:     count:  47729, total
                            time:   322292 ms [min:     5, max:   662,
                            avg:     6.8]</div>
                          <div>  searchObjects:    count:  52523, total
                            time:    75512 ms [min:     1, max:   148,
                            avg:     1.4]</div>
                        </div>
                        <div><br>
                        </div>
                        <div><span style="display:inline;color:rgb(0,0,0);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:18px;white-space:pre-wrap;background-color:rgb(245,245,245)" lang="en"><span><span>In the production environment with AWS RDS DB the timing of some actions seems to me to be very high.</span></span></span><span style="color:rgb(0,0,0);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:18px;white-space:pre-wrap;background-color:rgb(245,245,245)"> </span><br>
                        </div>
                        <div><span style="color:rgb(0,0,0);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:18px;white-space:pre-wrap;background-color:rgb(245,245,245)">
</span></div>
                        <div><span
                            style="background-color:rgb(245,245,245)"><font
                              face="Roboto, RobotoDraft, Helvetica,
                              Arial, sans-serif" color="#000000"><span style="font-size:18px;white-space:pre-wrap">I continue to analyze, when I have news I share here.</span></font><br>
                          </span></div>
                        <div><span
                            style="background-color:rgb(245,245,245)"><font
                              face="Roboto, RobotoDraft, Helvetica,
                              Arial, sans-serif" color="#000000"><span style="font-size:18px;white-space:pre-wrap">
</span></font></span></div>
                        <div><span
                            style="background-color:rgb(245,245,245)"><font
                              face="Roboto, RobotoDraft, Helvetica,
                              Arial, sans-serif" color="#000000"><span style="font-size:18px;white-space:pre-wrap">Regards</span></font></span></div>
                        <div><span
                            style="background-color:rgb(245,245,245)"><font
                              face="Roboto, RobotoDraft, Helvetica,
                              Arial, sans-serif" color="#000000"><span style="font-size:18px;white-space:pre-wrap">
</span></font></span></div>
                        <div><span
                            style="background-color:rgb(245,245,245)"><font
                              face="Roboto, RobotoDraft, Helvetica,
                              Arial, sans-serif" color="#000000"><span style="font-size:18px;white-space:pre-wrap">Gus</span></font></span></div>
                        <div><br>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
              <br>
              <div class="gmail_quote">
                <div dir="ltr" class="gmail_attr">Em qua., 3 de fev. de
                  2021 às 09:22, Gus Lou <<a
                    href="mailto:gugalou38@gmail.com" target="_blank"
                    moz-do-not-send="true">gugalou38@gmail.com</a>>
                  escreveu:<br>
                </div>
                <blockquote class="gmail_quote" style="margin:0px 0px
                  0px 0.8ex;border-left:1px solid
                  rgb(204,204,204);padding-left:1ex">
                  <div dir="ltr">
                    <div dir="ltr">Hi Guys<br>
                      <div><br>
                      </div>
                      <div>
                        <div>Does anyone here use Amazon RDS for
                          PostgreSQL for midpoint database?</div>
                        <div>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.</div>
                        <div><br>
                        </div>
                        <div>My Settings:</div>
                        <div>Midpoint: 4.2</div>
                        <div>Midpoint Nodes: 02</div>
                        <div>OpenJDK: 11</div>
                        <div>Postgres (AWS RDS): 11.8</div>
                      </div>
                      <div>AWS Region: east2</div>
                      <div>Instance Class: DB.m5.large</div>
                      <div><br>
                      </div>
                      <div>Regards</div>
                      <div><br>
                      </div>
                      <div>Gus</div>
                      <div><br>
                      </div>
                    </div>
                  </div>
                </blockquote>
              </div>
              <br>
              <fieldset></fieldset>
              <pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank" moz-do-not-send="true">midPoint@lists.evolveum.com</a>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank" moz-do-not-send="true">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
            </blockquote>
            <pre cols="72">-- 
Pavol Mederly
Software developer
<a href="http://evolveum.com" target="_blank" moz-do-not-send="true">evolveum.com</a></pre>
          </div>
          _______________________________________________<br>
          midPoint mailing list<br>
          <a href="mailto:midPoint@lists.evolveum.com" target="_blank"
            moz-do-not-send="true">midPoint@lists.evolveum.com</a><br>
          <a href="https://lists.evolveum.com/mailman/listinfo/midpoint"
            rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
        </blockquote>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="https://lists.evolveum.com/mailman/listinfo/midpoint">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
    </blockquote>
    <pre class="moz-signature" cols="72">-- 
Pavol Mederly
Software developer
evolveum.com</pre>
  </body>
</html>