<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p><br>
</p>
<p>Hi Maureen,</p>
<p><br>
</p>
<p>This is excellent. Percona is one of the premier MySQL experts, so this is great feedback.</p>
<p><br>
</p>
<p>Also, I have a page describing some <a id="LPlnk153950" href="http://archivesspace.github.io/archivesspace/user/tuning-archivesspace/">
MySQL and application tuning suggestions.</a> <br>
</p>
<p>One thing that I suggest is to run a profiler on the MySQL DB server, which can give you some ideas on where to look for problem areas. I've been using MySQL Tuner for years (
<a id="LPlnk970057" href="http://mysqltuner.com/">http://mysqltuner.com/)</a> but maybe there are some other things people are using? Any suggestions would help, and I can add them to the page ( or better yet send me a PR
<br>
</p>
<p>Also curious about various MySQL distributions ( Oracle, MariaDB, Percona, etc ) people are using? Are people using dedicated db servers, or clusters, or just having the db server on the same box as the application?
</p>
<p><br>
</p>
<p>Lastly, it would be great if we could start work on supporting other DBs. I think there's a strong interests ( especially from smaller orgs ) for MS Server, but are others wanting Oracle or postgres?
<br>
</p>
<p><br>
</p>
<p>best, chris. <br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Callahan, Maureen
<maureen.callahan@yale.edu><br>
<b>Sent:</b> Wednesday, August 26, 2015 3:36 PM<br>
<b>To:</b> 'archivesspace_users_group@lyralists.lyrasis.org'<br>
<b>Subject:</b> [Archivesspace_Users_Group] More ArchivesSpace performance analysis -- this time, the database</font>
<div> </div>
</div>
<div>
<div style="">
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Hi everyone,</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
As I’ve reported before, we at Yale are in the middle of an aggressive period of analysis to diagnose some of the slow performance we’ve been seeing with ArchivesSpace. As part of this initiative, we’ve contracted with Percona, a firm that specializes in MySQL
database analysis. Their report (attached), includes a number of action items that we believe the ArchivesSpace community may find helpful. We hope that this will result in further improvements to the application.</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Best wishes,</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Maureen</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Maureen Callahan</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Archivist, Metadata Specialist</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Manuscripts & Archives</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Yale University Library</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#8496B0"><a style="color: rgb(5, 99, 193); text-decoration: underline;" href="mailto:maureen.callahan@yale.edu"><span style="color:#8496B0">maureen.callahan@yale.edu</span></a></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">203.432.3627</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#7F7F7F"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Webpage:</span><span style="color:#7F7F7F"> </span><span style="color:#8496B0"><a style="color: rgb(5, 99, 193); text-decoration: underline;" href="web.library.yale.edu/mssa"><span style="color:#8496B0">web.library.yale.edu/mssa</span></a></span><span style="color:#7F7F7F"></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Collections:</span><span style="color:#7F7F7F"> </span>
<span style="color:#8496B0"><a style="color: rgb(5, 99, 193); text-decoration: underline;" href="drs.library.yale.edu"><span style="color:#8496B0">drs.library.yale.edu</span></a></span><span style="color:#7F7F7F"></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
</div>
</div>
</div>
</div>
</body>
</html>