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

[EP-tech] Re: DB slow down.

Hmm - are all the actions (action field in the table) related to indexing?  I'm certainly no expert on the intricacies of it all, but I do know that, for instance, the IRUS plugin uses the event queue to record when it was unable to contact the main IRUS servers to report a download, so it can attempt to do so at a later date.
I'll leave it to Adam or someone with a more in-depth knowledge of eprints events to advise as to whether you could simply clear the event queue, or whether that would cause you subsequent problems...


-----Original Message-----
From: Ian Stuart [mailto:Ian.Stuart at ed.ac.uk]
Sent: 26 February 2015 08:27
To: eprints-tech at ecs.soton.ac.uk
Subject: [EP-tech] Re: DB slow down.

On 25/02/15 17:25, Alan.Stiles wrote:
> My first thought is "is your indexer running?" as our event_queue table currently has 4 items in it - 4 rows.  These get removed as the indexer processes the items.
> What is the oldest date in your table?  And can you do a count of the statuses in the table?

We don't.... but then, we don't need to index anything as we have no text-searching (and why waste clock-cycles creating full-text searching we won't use)


Ian Stuart.
Developer: ORI, RJ-Broker, and OpenDepot.org Bibliographics and Multimedia Service Delivery team, EDINA, The University of Edinburgh.


This email was sent via the University of Edinburgh.

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/
-- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). The Open University is authorised and regulated by the Financial Conduct Authority.