hi Suresh thanks. max_connection=100(default). so, it won't allow user more than 100?
and one more clarification. i am facing performance issue in mysqld. some time mysqld consuming 100% cpu. so what i have to do now? and the below parameters are in default values. if i increase the value. it will help performance? query_cache_size = 0 key_buffer_size = 8m sort_buffer_size = 2m innodb_buffer_pool_size = 8m read_buffer = 2M write_buffer = 2M thanks in advance.. Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Thu, Jan 7, 2010 at 11:27 AM, Suresh Kuna <sureshkumar...@gmail.com>wrote: > 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 >