<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Hi All,</div><div class=""><br class=""></div><div class=""> A couple of people noticed that accessing the MySQL CCDB today has been sluggish. This was</div><div class="">evident in both slow program start up (when calibrations are read in) and in writing to the CCDB.</div><div class="">It looks like there has been unusually high load on the DB server that is causing this. We will need </div><div class="">to explore options if this is going to be a trend. In the meantime, you might consider using a local</div><div class="">SQLite file if just running jobs that need to read from the DB.</div><div class=""><br class=""></div><div class="">-David</div><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">Begin forwarded message:</div><br class="Apple-interchange-newline"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; color:rgba(0, 0, 0, 1.0);" class=""><b class="">From: </b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" class="">Paul Letta <<a href="mailto:letta@jlab.org" class="">letta@jlab.org</a>><br class=""></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; color:rgba(0, 0, 0, 1.0);" class=""><b class="">Subject: </b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" class=""><b class="">Fwd: hallddb load</b><br class=""></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; color:rgba(0, 0, 0, 1.0);" class=""><b class="">Date: </b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" class="">April 21, 2017 at 5:50:51 PM EDT<br class=""></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; color:rgba(0, 0, 0, 1.0);" class=""><b class="">To: </b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" class="">David Lawrence <<a href="mailto:davidl@jlab.org" class="">davidl@jlab.org</a>><br class=""></span></div><br class=""><div class=""><div class=""><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" class=""><div class=""><br class=""></div><div class="">hallddb is being hammered today... That is loads above 400. Its a 4 core machine.</div><div class="">Paul</div><div data-marker="__QUOTED_TEXT__" class=""><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-mce-style="font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000;" class=""><br class=""><br class=""><div class=""><br class=""></div><div class=""><img alt="" data-mce-src="cid:56db54c95220ac31bb658d62a17ae57a0a59348d@zimbra" class="" apple-inline="yes" id="CF328680-ABF8-4F96-B8C8-92DF90DDA85A" height="317" width="422" apple-width="yes" apple-height="yes" src="cid:56db54c95220ac31bb658d62a17ae57a0a59348d@zimbra"></div></div><br class=""></div></div></div></div></blockquote></div><br class=""></body></html>