<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
Is the version of MySQL the same on both VMs?<br>
Do they have the same default engine (e.g. myISAM or InnoDB)?<br>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> eprints-tech-bounces@ecs.soton.ac.uk <eprints-tech-bounces@ecs.soton.ac.uk> on behalf of Yuri <yurj@alfa.it><br>
<b>Sent:</b> 21 May 2018 09:55:59<br>
<b>To:</b> eprints-tech@ecs.soton.ac.uk<br>
<b>Subject:</b> Re: [EP-tech] Manage deposits page loads very slow</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Enable sql logging on mysql and write down the queries it does when
<br>
using Manage Deposits. Then disable logging and you can test directly <br>
the queries looking for mysql bottlenecks.<br>
<br>
Is the disk enough fast in the new vm? Is there any difference if you <br>
shut down the indexer? Did you migrate also the index database or the <br>
indexer is still running to reindex everything?<br>
<br>
Il 21/05/2018 10:26, Emilian Mitocariu ha scritto:<br>
> Hi,<br>
><br>
> I migrated an eprints instance from version 3.3.7 running on a VM with <br>
> ubuntu 10.04, 1GB RAM and 2 virtual CPUs to the latest eprints version <br>
> 3.3.15 on a VM with ubuntu 16.04, 2.5GB RAM and 2 virtual CPUs. I <br>
> followed the page documented on the eprints wiki for the migration.<br>
><br>
> There were no problems with loading pages on the old version, but on <br>
> the new server when a user visits the "Manage Deposits" page and has a <br>
> lot of deposits, it takes a while to load the page. For a user with <br>
> 885 deposits, it takes at least 30 seconds.<br>
><br>
> I compared the mysql configuration on both VMs and it is similar. <br>
> Also, the eprints indexer is running. During the day, apache and mysql <br>
> seems to use more RAM than it did on the old VM.<br>
><br>
> Does anyone know what could cause the slow page load or at least give <br>
> me some pointers where to look?<br>
><br>
><br>
> *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">
http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> *** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
> *** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
> *** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
<br>
*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">
http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
*** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
*** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</div>
</span></font></div>
</body>
</html>