On Mon, 2005-11-14 at 10:46 +1100, Brett Randall wrote: > Does anyone else have any ideas as to how I can utilise persistent > database connections to a MySQL server via DBI, in order to speed up > web queries, but without the 20 or so connections per virtual server > that sit there waiting for something to happen? Should I be doing this > differently?
The first thing you should do is run a reverse proxy, if you're not already doing it. Running without a reverse proxy means that people on a modem downloading images, CSS, Flash, etc. from your site are tying up database connections. A proxy can handle all the static stuff without touching mod_perl or your database. In my experience, this can reduce the number of database connections by an order of magnitude. - Perrin