<div dir="ltr"><div dir="ltr">Hi Pavol<br><div><br></div><div><div><br></div><div>I will apply your recommendations, I am looking for exactly what to analyze to identify the slowness in the production environment.</div><div>Thanks again for your guidance. </div></div><div><br></div><div>Regards</div><div><br></div><div>Gus</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">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></p>
<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">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">midPoint@lists.evolveum.com</a>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<pre cols="72">--
Pavol Mederly
Software developer
<a href="http://evolveum.com" target="_blank">evolveum.com</a></pre>
</div>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div>