EPrints Technical Mailing List Archive
See the EPrints wiki for instructions on how to join this mailing list and related information.
Message: #03985
< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First
[EP-tech] Re: DB slow down.
- To: eprints-tech@ecs.soton.ac.uk
- Subject: [EP-tech] Re: DB slow down.
- From: Ian Stuart <Ian.Stuart@ed.ac.uk>
- Date: Thu, 26 Feb 2015 08:26:44 +0000
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.
- References:
- [EP-tech] DB slow down.
- From: CARRICK Ray <rcarric2@exseed.ed.ac.uk>
- [EP-tech] Re: DB slow down.
- From: "Field A.N." <af05v@ecs.soton.ac.uk>
- [EP-tech] Re: DB slow down.
- From: CARRICK Ray <rcarric2@exseed.ed.ac.uk>
- [EP-tech] Re: DB slow down.
- From: "Alan.Stiles" <alan.stiles@open.ac.uk>
- [EP-tech] DB slow down.
- Prev by Date: [EP-tech] OAI2 missing setSpec
- Next by Date: [EP-tech] Re: DB slow down.
- Previous by thread: [EP-tech] Re: DB slow down.
- Next by thread: [EP-tech] Re: DB slow down.
- Index(es):