List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:January 7 2010 7:53am
Subject:Re: Are there any difference between max_connection and
max_user_connection?
View as plain text  
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.faizal@stripped> 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 <sureshkumarilu@stripped>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.faizal@stripped>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

Thread
Are there any difference between max_connection and max_user_connection?F.A.I.Z.A.L7 Jan
  • Re: Are there any difference between max_connection and max_user_connection?Suresh Kuna7 Jan
    • Re: Are there any difference between max_connection and max_user_connection?F.A.I.Z.A.L7 Jan
      • Re: Are there any difference between max_connection and max_user_connection?Suresh Kuna7 Jan
        • Re: Are there any difference between max_connection and max_user_connection?F.A.I.Z.A.L7 Jan
          • Re: Are there any difference between max_connection and max_user_connection?sureshkumarilu7 Jan
Re: Are there any difference between max_connection and max_user_connection?F.A.I.Z.A.L7 Jan
  • Re: Are there any difference between max_connection and max_user_connection?Suresh Kuna7 Jan