Hello colleagues!

 

I am looking for some IRStats2 insights. We have recently shifted our MySQL DB to InnoDB from MyISAM. I am in the process of running the process_stats job for IRStats2 in order to reflect local changes but the job is taking an aeon – and significantly longer than it ever did under MyISAM.

 

I was informed that it would run more slowing with InnoDB but I had no idea it would be quite so bad. So far it has been running for the best part of a week, which has been impacting on end users (e.g. sporadic unavailability of EPrints, slow responses, etc.). It is so bad that I am almost tempted to kill the job, even though it has been running for the best part of a week.

 

Has a similar issue affected others and, if so, do you have any tips for speeding up the processing? Or do I simply need to take the hit?!

 

Cheers

George

--

George Macgregor

Information Services Directorate | University of Strathclyde

Curran Building | 101 St James Road

Glasgow G4 ONS

Tel: 0141 548 3496

Email: george.macgregor@strath.ac.uk

Web: https://purl.org/g3om4c

Twitter: @g3om4c

orcid.org/0000-0002-8482-3973
--

Ensure that your research outputs are eligible for submission in the next REF.  Authors' accepted manuscripts of journal articles and conference proceedings accepted after 01 April 2016 must be deposited in PURE as soon as possible after acceptance for publication – email openaccess@strath.ac.uk for further information or visit http://www.strath.ac.uk/openaccess.

 

--

The University of Strathclyde is a charitable body, registered in Scotland, with registration number SC015263