EPrints Technical Mailing List Archive
See the EPrints wiki for instructions on how to join this mailing list and related information.
Message: #05866
< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First
[EP-tech] Too many connections
- To: "eprints-tech@ecs.soton.ac.uk" <eprints-tech@ecs.soton.ac.uk>
- Subject: [EP-tech] Too many connections
- From: George Macgregor <george.macgregor@strath.ac.uk>
- Date: Mon, 15 Aug 2016 09:19:51 +0000
Hello colleagues. Occasionally our EPrints suffers the “too many connections” MySQL connection error. In the past when EPrints has suffered this error my assumption has been that there is a query hanging which then has a knock on effect on other queries
as they can’t write to a table. We currently have max_connections set to 300 (which seems like a lot) but I can observe from previous chatter on the list that some go up to 1000. I was therefore wondering what the community considered to be an appropriate
connection limit? Given all the traffic I can observe it is conceivable – however unlikely - that 300 is insufficient. Have others observed something similar?
Thanks in advance!
-- 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:
http://personal.strath.ac.uk/george.macgregor/ 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 |
- Prev by Date: [EP-tech] XSLT export: list/eprint vs dataobj/eprint output
- Next by Date: Re: [EP-tech] Too many connections
- Previous by thread: [EP-tech] XSLT export: list/eprint vs dataobj/eprint output
- Next by thread: Re: [EP-tech] Too many connections
- Index(es):