<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Gus,</p>
<p>
<blockquote type="cite"><span class="gmail-VIiyi" 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 class="gmail-JLqJ4b gmail-ChMk0b" style="cursor: pointer;"><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>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 class="moz-cite-prefix">On 03/02/2021 14:35, Gus Lou via
midPoint wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CA+XZjGR-BtdqjntiePk0kOXcWgnK9KGDDOsc8K08TB8=cDTHsA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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 class="gmail-VIiyi" 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 class="gmail-JLqJ4b gmail-ChMk0b" style="cursor: pointer;"><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"
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 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>