<html><head><meta http-equiv="content-type" content="text/html; charset=us-ascii"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">We don't use pooled databases currently and I haven't heard of or seen any in use for Evergreen in some time.<br><div>
<meta charset="UTF-8"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div><br></div><div>Jason</div><div><br>-- <br>Jason Boyer<br>Senior System Administrator<br>Equinox Open Library Initiative<br>JBoyer@equinoxOLI.org<br>+1 (877) Open-ILS (673-6457)<br>https://equinoxOLI.org/</div></div></div></div>
</div>
<div><br><blockquote type="cite"><div>On Mar 20, 2023, at 4:07 PM, Bill Erickson via Evergreen-dev <evergreen-dev@list.evergreen-ils.org> wrote:</div><br class="Apple-interchange-newline"><div><div dir="ltr"><font face="monospace">Hi All,</font><div><font face="monospace"><br></font></div><div><font face="monospace">I was recently reviewing some activity logs and found these top 5 API calls (with counts) for last Thursday:</font></div><div><font face="monospace"><br></font></div><div><font face="monospace"> 46398 <a href="http://open-ils.pcrud.retrieve.au/">open-ils.pcrud.retrieve.au</a><br> 41363 open-ils.actor.get_barcodes<br> 33044 open-ils.pcrud.transaction.begin<br> 32591 open-ils.pcrud.transaction.rollback<br> 30549 open-ils.pcrud.search.atc<br></font></div><div><font face="monospace"><br></font></div><div><font face="monospace">Way down the list I have:</font></div><div><font face="monospace"><br></font></div><div><font face="monospace"> 452 open-ils.pcrud.transaction.commit<br></font></div><div><font face="monospace"><br></font></div><div><font face="monospace">If I take out the ~450 begin/commit pairs, which perform real work, I'm left with ~65k begin + rollback API calls. That's roughly 1 of every 10 API calls that hit our system.</font></div><div><font face="monospace"><br></font></div><div><font face="monospace">Not only are there a lot of them, each results in a begin or rollback call in the database. The calls are fast and generally harmless on a per-call basis, but they do make it to the database every time, so they're not exactly trivial/superficial.</font></div><div><font face="monospace"><br></font></div><div><font face="monospace">The begin/rollback pairs are the result of using "authoritative" data retrieval -- calls that start a database transaction so the caller can be sure any data retrieved comes from the primary database. This is useful when a) data must be up to date to avoid confusion/oddness in the UI and b) the Evergreen system is running one or more pooled database replicas that handle live read queries -- live replicas can occasionally lag behind with replication and return very slightly older data than the primary database.</font></div><div><font face="monospace"><br></font></div><div><font face="monospace">For sites like KCLS, where all live queries go to one primary database, these API calls serve no purpose. (We have replicas, but they are not part of an active load-balanced pool. They are used instead for reporting, bulk data collection, debugging, and of course backups).</font></div><div><font face="monospace"><br></font></div><div><font face="monospace">Since these begin + rollback pairs (and ".authoritative" APIs) serve no purpose in our environment, I was considering creating a local patch to disable them. However, before I start patching locally, </font><span style="font-family:monospace">I'm curious if there is a broader desire for deprecating authoritative APIs? I suspect they can be turned into NO-OP's with 2 or 3 well-placed lines of code.</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">Do many/any of you use live, read-only pooled database replicas?</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">I'd love to hear your thoughts/concerns/etc.</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">Thanks,</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">-b</span></div><div><br></div><div><font face="monospace"><br></font></div><div><font face="monospace"><br></font></div><div><font face="monospace"><br></font></div><div><span style="font-family:monospace"><br></span></div></div>
_______________________________________________<br>Evergreen-dev mailing list<br>Evergreen-dev@list.evergreen-ils.org<br>http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev<br></div></blockquote></div><br></body></html>