<div dir="ltr"><div><div>Hi Megan,<br><br></div>Our installation of Archivesspace had very similar performance problems. The logs were full of Java heap stack and out of memory errors. Solr logs were will of Sever errors and the application started crashing. At first, a restart would fix it but eventually, it would reach a slow down state very quickly after a restart. Lyrasis sys admin pointed me to this ticket and this plugin: <br><br><a href="https://archivesspace.atlassian.net/browse/ANW-137">https://archivesspace.atlassian.net/browse/ANW-137</a><br><br><a href="https://github.com/lyrasis/events-deduper">https://github.com/lyrasis/events-deduper</a><br><br></div>I recommend running the following query on your DB: <br><pre><code>mysql> SELECT
id,
archival_object_id,
event_id,
role_id,
COUNT(*) as duplicates
FROM `event_link_rlshp`
GROUP BY archival_object_id, event_id, role_id
HAVING duplicates > 1
ORDER BY duplicates DESC;
<br><br></code></pre><pre><code>If you have a high number of duplicates, I would try the plugin. <br><br></code></pre><pre><code>- Chelsea<br></code></pre></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><span style="color:rgb(128,128,128)"><em><span style="font-size:small">---------------</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small">Chelsea Lobdell</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small">Library Web Developer/ Swarthmore College</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small"><a href="mailto:clobdel1@swarthmore.edu" target="_blank">clobdel1@swarthmore.edu</a> / (610)690-6818</span></em></span></div></div></div></div>
<br><div class="gmail_quote">On Wed, Aug 2, 2017 at 1:23 PM, Mummey, Megan <span dir="ltr"><<a href="mailto:megan.mummey@uky.edu" target="_blank">megan.mummey@uky.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="#0563C1" vlink="#954F72" lang="EN-US">
<div class="m_-8553948311630874035WordSection1">
<p class="MsoNormal">Hi all,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">UK’s locally installed instance of ArchivesSpace has performance issues every couple of months, slowing down until eventually the application is fails. The fix is a full restart. Our programmer has indicated the failure is caused by “garbage
collecting”. Previously we’ve added RAM to our VM. We’re interested in finding out how other institutions with a similar sized SOLR index are running ArchivesSpace. And if they have/had similar problems.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Information on our system below:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.5in">
<u></u><span style="font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u>ArchivesSpace directory is about 26 GB. This includes two copies of the Solr index (the live version and a backup, at about 3 GB each) and 19 GB of log files. This is housed on a network share with terabytes of free space.<u></u><u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.5in">
<u></u><span style="font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u>The ArchivesSpace database is housed on the libwwwapps07 VM. The ibdata1 file for MySQL (used for all databases on the VM but primarily used by ArchivesSpace) is about 2.4 GB. The VM has about 35 GB free.<u></u><u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.5in">
<u></u><span style="font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u>ArchivesSpace is configured with the following settings:<u></u><u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.25in"><u></u> <u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.5in"> + ASPACE_JAVA_XMX="-Xmx6144m"<u></u><u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.25in;text-indent:.25in"> + AppConfig[:indexer_thread_<wbr>count] = 2<u></u><u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.25in;text-indent:.25in"><u></u> <u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.5in">
<u></u><span style="font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u>MySQL is configured with the following setting:<u></u><u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.5in"><u></u> <u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.5in">+ innodb_buffer_pool_size= 1600000000<u></u><u></u></p>
<p class="m_-8553948311630874035MsoPlainText"><u></u> <u></u></p>
<p class="m_-8553948311630874035MsoPlainText" style="margin-left:.5in">
<u></u><span style="font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u>VM has approximately 8 GB of RAM. The value of ASPACE_JAVA_XMX is lower than this to allow memory use by other processes, including MySQL (as listed above) and the web server.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt">Megan Mummey</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt">Collections Management Archivist</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt">Special Collections Research Center</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt">University of Kentucky Libraries</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt">Margaret I. King Library</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt">Lexington, KY 40506-0039</span><u></u><u></u></p>
<p class="MsoNormal"><a href="mailto:Megan.mummey@uky.edu" target="_blank"><span style="font-size:10.5pt;color:#0563c1">megan.mummey@uky.edu</span></a><span style="font-size:10.5pt">|<a href="tel:(859)%20257-6942" value="+18592576942" target="_blank">859.257.<wbr>6942</a></span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><br>
<br></blockquote></div><br></div>