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: > h

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.

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_conn

Re: Are there any difference between max_connection and max_user_connection?

he 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 on

Re: Are there any difference between max_connection and max_user_connection?

n 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. som

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 valu

Re: Are there any difference between max_connection and max_user_connection?

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 > > thank

Are there any difference between max_connection and max_user_connection?

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

Re: difference between max_connection and max_user_connection

At 10:13 +0800 10/19/05, ⧠àÆ wrote: Are there any difference between max_connection and max_user_connection? thanks! The difference is explained here: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL

difference between max_connection and max_user_connection

Are there any difference between max_connection and max_user_connection? thanks! _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

suggestion to max_connection

ed as "connection count", which is limited under "max_connection" imagine that so many connection idling, and no more connection can be taken so, my idea is to add setting like this: max_connection(idle+running): 400 max_connection_running(not idle): 50 i wonder if possible to make

max_connection

how do i change these settings like max_connection and stuff on a windows mysql server? i keep on getting this error after a while thanks