Re: Are there any difference between max_connection and max_user_connection?
It should be identical select statements which will improve performance and not the updates. Go through the below url for more information about optimization and performance http://dev.mysql.com/doc/refman/5.0/en/optimizing-the-server.html On Thu, Jan 7, 2010 at 4:42 PM, F.A.I.Z.A.L wrote: > hi > > i can see many 'updates' is going every min. so is it good to increase this > query_cache_size ?.. > > what are the other action i can take to improve the performance of mysql > server > > environment > version : 5.0.22 > platform : redhat 5 > > > > Cheers > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > -- Thanks Suresh Kuna MySQL DBA
Re: Are there any difference between max_connection and max_user_connection?
hi i can see many 'updates' is going every min. so is it good to increase this query_cache_size ?.. what are the other action i can take to improve the performance of mysql server environment version : 5.0.22 platform : redhat 5 Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com
Re: Are there any difference between max_connection and max_user_connection?
If the queries are identical then Yes. If not it will degrade the query performance. Sent from BlackBerry® on Airtel -Original Message- From: "F.A.I.Z.A.L" Date: Thu, 7 Jan 2010 15:51:19 To: Suresh Kuna Cc: Subject: Re: Are there any difference between max_connection and max_user_connection? 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 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 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 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 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 >
Re: Are there any difference between max_connection and max_user_connection?
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 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 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 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 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 >
Re: Are there any difference between max_connection and max_user_connection?
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 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 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 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
Re: Are there any difference between max_connection and max_user_connection?
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 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 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 >
Re: Are there any difference between max_connection and max_user_connection?
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 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
