Ensembl mirror inaccessbile under intensive MySQL requests

The background for this issue that our user found local ensembl mirror sometimes inaccessible, but after a few refresh the pages comes out again. I realized the problem was caused by the small default value of max_connections in MySQL server, and the fact the ensembl uses DBI instead of Apache::DBI in the perl.startup script.

In the latest CVS code of ensembl, perl.startup file still uses “DBI” module, soI believe it will have potential performance issues on other mirror sites.

Continue reading