[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] Re: DB slow down.



Hi Ray

	A first step would be to check for database corruption.  Run mysqlcheck and see if if finds anything wrong...

--
Adam Field
Business Relationship Manager and Community Lead
EPrints Services




On 25 Feb 2015, at 10:34, CARRICK Ray wrote:

> Hi folks,
> 
> we have a problem with DB slow down. This is running on 3.2 - we plan to test on 3.3 to see if there's any difference but haven't done so yet. The problem occurs when importing and from putting tracing into the code seems to be happening with a commit.
> 
> - We have a QA setup which has about 6,500 eprints and a live server which has 650,000.
> 
> - An import which takes 2-3 mins on the QA server takes 25mins on the live.
> 
> - The time seems to be going on 'commit' - that's eprints commit (I haven't dug into it any further yet).
> 
> - On the QA server it takes fractional time but on the live server this takes about 1 min.
> 
> So if we have a main record plus, say, 25 associated documents, the time is approx 1min for the main record plus 1 min per document, hence abut 25 mins. The records we are loading typically have somewhere in the region of 10 to 40 associated documents. 
> 
> Has anyone come up against this before?
> Any thoughts on how to proceed?
> 
> Thanks,
> 
> Ray.
> 
> The University of Edinburgh is a charitable body, registered in
> Scotland, with registration number SC005336.
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
> *** EPrints developers Forum: http://forum.eprints.org/