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 sureshkumar...@gmail.comwrote:

Re: Are there any difference between max_connection and max_user_connection?

: 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

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:

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

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: 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 sac.fai...@gmail.com wrote: Dear all

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

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

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

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