Re: Are there any difference between max_connection and max_user_connection?

[Suresh Kuna]

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.faizal@stripped> 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