<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" lang="en" 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)"><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)"><br></span></div><div><span style="background-color:rgb(245,245,245)"><font color="#000000" face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif"><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 color="#000000" face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif"><span style="font-size:18px;white-space:pre-wrap"><br></span></font></span></div><div><span style="background-color:rgb(245,245,245)"><font color="#000000" face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif"><span style="font-size:18px;white-space:pre-wrap">Regards</span></font></span></div><div><span style="background-color:rgb(245,245,245)"><font color="#000000" face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif"><span style="font-size:18px;white-space:pre-wrap"><br></span></font></span></div><div><span style="background-color:rgb(245,245,245)"><font color="#000000" face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif"><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">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>