Yes it won't allow except 1 connection for root user. We have to monitor the MySQLD server and the queries runnning at that time. As of now, increase the key_buffer_size to 64 or 128 mb according to your indexes created and physical memory available. and query_cache_size is purely depends on the queries that your application hits the database.
On Thu, Jan 7, 2010 at 12:20 PM, F.A.I.Z.A.L <sac.fai...@gmail.com> wrote: > 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 >> > > -- Thanks Suresh Kuna MySQL DBA
