hi suresh every 1 min nealy 40 to 80 users will hit the database. so, if i increase query_cache_size it will avoid physical i/o and buffer missing?
Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Thu, Jan 7, 2010 at 1:23 PM, Suresh Kuna <sureshkumar...@gmail.com>wrote: > 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 >
