[EP-tech] Re: DB slow down.

[Adam Field]

In theory, the indexer has morphed over the years into a general task queue, and so some of the things in it may not be text indexing.  I believe that the generation of thumbnails is handled this way.  Bazaar packages can use this to schedule the triggering of event plugins.

--
Adam


On 26 Feb 2015, at 09:16, Alan.Stiles <alan.stiles at open.ac.uk> wrote:

> 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...
> 
> Alan
> 
> -----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.
> 
> http://edina.ac.uk/
> 
> 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.
> 
> *** 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/