[Archivesspace_Users_Group] More ArchivesSpace performance analysis -- this time, the database

[Chris Fitzpatrick]

Hi Maureen,


This is excellent. Percona is one of the premier MySQL experts, so this is great feedback.


Also, I have a page describing some MySQL and application tuning suggestions.<http://archivesspace.github.io/archivesspace/user/tuning-archivesspace/>

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 ( http://mysqltuner.com/)<http://mysqltuner.com/> 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

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?


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?


best, chris.




Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/


________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Callahan, Maureen <maureen.callahan at yale.edu>
Sent: Wednesday, August 26, 2015 3:36 PM
To: 'archivesspace_users_group at lyralists.lyrasis.org'
Subject: [Archivesspace_Users_Group] More ArchivesSpace performance analysis -- this time, the database


Hi everyone,



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.



Best wishes,

Maureen



Maureen Callahan

Archivist, Metadata Specialist

Manuscripts & Archives

Yale University Library

maureen.callahan at yale.edu<mailto:maureen.callahan at yale.edu>

203.432.3627



Webpage: web.library.yale.edu/mssa

Collections: drs.library.yale.edu


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150826/90746c90/attachment.html>