[ensembl-dev] Variant effect predictor -- too many database connections

[Michael Yourshaw]

When running the variant effect predictor on a local database, I see that it establishes around 20,000 connections to the SQL server. Running multiple instances simultaneously will overwhelm the server causing a can’t-connect exception.

If I comment out this line, there are only 2 conections
	#$reg->set_disconnect_when_inactive();

I understand the purpose of that setting, but I wonder if the disconnects are not actually taking place, yet the program establishes a new connection for each query.

ॐ

Michael Yourshaw
UCLA Geffen School of Medicine
Department of Human Genetics, Nelson Lab
695 Charles E Young Drive S
Gonda 5554
Los Angeles CA 90095-8348 USA
myourshaw at ucla.edu
970.691.8299

This message is intended only for the use of the addressee and may contain information that is PRIVILEGED and CONFIDENTIAL, and/or may contain ATTORNEY WORK PRODUCT. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20110617/480dd802/attachment.html>