<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>