How Many MySQL Connections

anthroa · January 28th, 2007, 05:40 AM

I am finding that some users are racking up a large number of MySQL connections (40 - 90) and putting a large load on the system - some are just connected to an image or some to the slide show - then dissappear through time - in theory how many connections should an individual make at any one time and can this be regulated to minimise server load / MySQL load

Chuck S · January 28th, 2007, 10:08 AM

You can try fine tuning your mysql settings. You may need to contact your host. Ask them that the mysql or process drop time is. Looks to me if they are not disappearing then or dropping like they should when someone leaves viewing a photo etc

anthroa · January 29th, 2007, 12:32 AM

Chuck - thats what i think also but what should a well optimised site max out at 10, 20, 30 connections for a user ? what is a reasonable target so that the site provides a good service but doesn't get overloaded ?