Hi Faizal, Max_connections are the connections for the overall MySQLD server. Max_user_connections are the connections for the particular user ( i.e for an account ) of the MySQLD server.
Suresh Kuna MySQL DBA On Thu, Jan 7, 2010 at 11:00 AM, F.A.I.Z.A.L <sac.fai...@gmail.com> wrote: > Dear all > > I can see max_connection and max_user_connection set to default value. but > daily i can see 40 to 70 users connection to the database. how? when > max_user_connections=0. what is the different between these two > parameters.. > > max_connection=100 > max_user_connections=0 > > thanks in advance. > > Cheers > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > -- Thanks Suresh Kuna MySQL DBA