Are there any difference between max_connection and

--00151757098876eab5047c8c61a0
Content-Type: text/plain; charset=ISO-8859-1

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

--00151757098876eab5047c8c61a0--

Re: Are there any difference between max_connection and

--000e0cd32f968b42ce047c8cbd0f
Content-Type: text/plain; charset=ISO-8859-1

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

--000e0cd32f968b42ce047c8cbd0f--

Re: Are there any difference between max_connection and

--0016364ed7d069e492047c8d7efd
Content-Type: text/plain; charset=ISO-8859-1

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
>

--0016364ed7d069e492047c8d7efd--

Re: Are there any difference between max_connection and

--00504502b010b4854b047c8e5d62
Content-Type: text/plain; charset=ISO-8859-1

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

--00504502b010b4854b047c8e5d62--

Re: Are there any difference between max_connection and

--0016e64c34c0c3e85a047c906f93
Content-Type: text/plain; charset=ISO-8859-1

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
>

--0016e64c34c0c3e85a047c906f93--

Re: Are there any difference between max_connection and max_user_connection?

--part8648-boundary-338856453-2008220976
Content-Transfer-Encoding: base64
Content-Type: text/plain; charset="Windows-1252"

SWYgdGhlIHF1ZXJpZXMgYXJlIGlkZW50aWNhbCB0aGVuIFllcy4gSWYgbm90 IGl0IHdpbGwgZGVn
cmFkZSB0aGUgcXVlcnkgcGVyZm9ybWFuY2UuDQoNClNlbnQgZnJvbSBCbGFj a0JlcnJ5riBvbiBB
aXJ0ZWwNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206ICJG LkEuSS5aLkEuTCIg
PHNhYy5mYWl6YWxAZ21haWwuY29tPg0KRGF0ZTogVGh1LCA3IEphbiAyMDEw IDE1OjUxOjE5IA0K
VG86IFN1cmVzaCBLdW5hPHN1cmVzaGt1bWFyaWx1QGdtYWlsLmNvbT4NCkNj OiA8bXlzcWxAbGlz
dHMubXlzcWwuY29tPg0KU3ViamVjdDogUmU6IEFyZSB0aGVyZSBhbnkgZGlm ZmVyZW5jZSBiZXR3
ZWVuIG1heF9jb25uZWN0aW9uIGFuZCANCgltYXhfdXNlcl9jb25uZWN0aW9u Pw0KDQpoaSBzdXJl
c2gNCg0KZXZlcnkgMSBtaW4gbmVhbHkgNDAgdG8gODAgdXNlcnMgd2lsbCBo aXQgdGhlIGRhdGFi
YXNlLiBzbywgaWYgaSBpbmNyZWFzZQ0KcXVlcnlfY2FjaGVfc2l6ZSBpdCB3 aWxsIGF2b2lkIHBo
eXNpY2FsIGkvbyBhbmQgYnVmZmVyIG1pc3Npbmc/DQoNCg0KQ2hlZXJzDQpG YWl6YWwgUw0KR1NN
IDogOTg0MDExODY3Mw0KQmxvZzogaHR0cDovL29yYWRiYXByby5ibG9nc3Bv dC5jb20NCg0KDQpP
biBUaHUsIEphbiA3LCAyMDEwIGF0IDE6MjMgUE0sIFN1cmVzaCBLdW5hIDxz dXJlc2hrdW1hcmls
dUBnbWFpbC5jb20+d3JvdGU6DQoNCj4gWWVzIGl0IHdvbid0IGFsbG93IGV4 Y2VwdCAxIGNvbm5l
Y3Rpb24gZm9yIHJvb3QgdXNlci4NCj4gV2UgaGF2ZSB0byBtb25pdG9yIHRo ZSBNeVNRTEQgc2Vy
dmVyIGFuZCB0aGUgcXVlcmllcyBydW5ubmluZyBhdCB0aGF0IHRpbWUuDQo+ IEFzIG9mIG5vdywg
aW5jcmVhc2UgdGhlIGtleV9idWZmZXJfc2l6ZSB0byA2NCBvciAxMjggbWIg YWNjb3JkaW5nIHRv
IHlvdXINCj4gaW5kZXhlcyBjcmVhdGVkIGFuZCBwaHlzaWNhbCBtZW1vcnkg YXZhaWxhYmxlLg0K
PiBhbmQgcXVlcnlfY2FjaGVfc2l6ZSBpcyBwdXJlbHkgZGVwZW5kcyBvbiB0 aGUgcXVlcmllcyB0
aGF0IHlvdXIgYXBwbGljYXRpb24NCj4gaGl0cyB0aGUgZGF0YWJhc2UuDQo+ DQo+DQo+DQo+DQo+
IE9uIFRodSwgSmFuIDcsIDIwMTAgYXQgMTI6MjAgUE0sIEYuQS5JLlouQS5M IDxzYWMuZmFpemFs
QGdtYWlsLmNvbT4gd3JvdGU6DQo+DQo+PiBoaSBTdXJlc2gNCj4+DQo+PiB0 aGFua3MuIG1heF9j
b25uZWN0aW9uPTEwMChkZWZhdWx0KS4gc28sIGl0IHdvbid0IGFsbG93IHVz ZXIgbW9yZSB0aGFu
DQo+PiAxMDA/DQo+Pg0KPj4gYW5kIG9uZSBtb3JlIGNsYXJpZmljYXRpb24u IGkgYW0gZmFjaW5n
IHBlcmZvcm1hbmNlIGlzc3VlIGluIG15c3FsZC4gc29tZQ0KPj4gdGltZSBt eXNxbGQgY29uc3Vt
aW5nIDEwMCUgY3B1LiBzbyB3aGF0IGkgaGF2ZSAgdG8gZG8gbm93Pw0KPj4N Cj4+IGFuZCB0aGUg
YmVsb3cgcGFyYW1ldGVycyBhcmUgaW4gZGVmYXVsdCB2YWx1ZXMuIGlmIGkg aW5jcmVhc2UgdGhl
IHZhbHVlLg0KPj4gaXQgd2lsbCBoZWxwIHBlcmZvcm1hbmNlPw0KPj4NCj4+ IHF1ZXJ5X2NhY2hl
X3NpemUgPSAwDQo+PiBrZXlfYnVmZmVyX3NpemUgPSA4bQ0KPj4gc29ydF9i dWZmZXJfc2l6ZSA9
IDJtDQo+PiBpbm5vZGJfYnVmZmVyX3Bvb2xfc2l6ZSA9IDhtDQo+Pg0KPj4g cmVhZF9idWZmZXIg
PSAyTQ0KPj4gd3JpdGVfYnVmZmVyID0gMk0NCj4+DQo+Pg0KPj4gdGhhbmtz IGluIGFkdmFuY2Uu
Lg0KPj4NCj4+IENoZWVycw0KPj4gRmFpemFsIFMNCj4+IEdTTSA6IDk4NDAx MTg2NzMNCj4+IEJs
b2c6IGh0dHA6Ly9vcmFkYmFwcm8uYmxvZ3Nwb3QuY29tDQo+Pg0KPj4NCj4+ IE9uIFRodSwgSmFu
IDcsIDIwMTAgYXQgMTE6MjcgQU0sIFN1cmVzaCBLdW5hIDxzdXJlc2hrdW1h cmlsdUBnbWFpbC5j
b20+d3JvdGU6DQo+Pg0KPj4+IEhpIEZhaXphbCwNCj4+PiBNYXhfY29ubmVj dGlvbnMgYXJlIHRo
ZSBjb25uZWN0aW9ucyBmb3IgdGhlIG92ZXJhbGwgTXlTUUxEIHNlcnZlci4N Cj4+PiBNYXhfdXNl
cl9jb25uZWN0aW9ucyBhcmUgdGhlIGNvbm5lY3Rpb25zIGZvciB0aGUgcGFy dGljdWxhciB1c2Vy
ICggaS5lDQo+Pj4gZm9yIGFuIGFjY291bnQgKSBvZiB0aGUgTXlTUUxEIHNl cnZlci4NCj4+Pg0K
Pj4+IFN1cmVzaCBLdW5hDQo+Pj4gTXlTUUwgREJBDQo+Pj4NCj4+PiBPbiBU aHUsIEphbiA3LCAy
MDEwIGF0IDExOjAwIEFNLCBGLkEuSS5aLkEuTCA8c2FjLmZhaXphbEBnbWFp bC5jb20+d3JvdGU6
DQo+Pj4NCj4+Pj4gRGVhciBhbGwNCj4+Pj4NCj4+Pj4gSSBjYW4gc2VlIG1h eF9jb25uZWN0aW9u
IGFuZCBtYXhfdXNlcl9jb25uZWN0aW9uIHNldCB0byBkZWZhdWx0IHZhbHVl Lg0KPj4+PiBidXQN
Cj4+Pj4gZGFpbHkgaSBjYW4gc2VlIDQwIHRvIDcwIHVzZXJzIGNvbm5lY3Rp b24gdG8gdGhlIGRh
dGFiYXNlLiBob3c/IHdoZW4NCj4+Pj4gbWF4X3VzZXJfY29ubmVjdGlvbnM9 MC4gd2hhdCBpcyB0
aGUgZGlmZmVyZW50IGJldHdlZW4gdGhlc2UgdHdvDQo+Pj4+IHBhcmFtZXRl cnMuLg0KPj4+Pg0K
Pj4+PiBtYXhfY29ubmVjdGlvbj0xMDANCj4+Pj4gbWF4X3VzZXJfY29ubmVj dGlvbnM9MA0KPj4+
Pg0KPj4+PiB0aGFua3MgaW4gYWR2YW5jZS4NCj4+Pj4NCj4+Pj4gQ2hlZXJz DQo+Pj4+IEZhaXph
bCBTDQo+Pj4+IEdTTSA6IDk4NDAxMTg2NzMNCj4+Pj4gQmxvZzogaHR0cDov L29yYWRiYXByby5i
bG9nc3BvdC5jb20NCj4+Pj4NCj4+Pg0KPj4+DQo+Pj4NCj4+PiAtLQ0KPj4+ IFRoYW5rcw0KPj4+
IFN1cmVzaCBLdW5hDQo+Pj4gTXlTUUwgREJBDQo+Pj4NCj4+DQo+Pg0KPg0K Pg0KPiAtLQ0KPiBU
aGFua3MNCj4gU3VyZXNoIEt1bmENCj4gTXlTUUwgREJBDQo+DQoNCg==

--part8648-boundary-338856453-2008220976--

Re: Are there any difference between max_connection and

--0015175709884d30de047c9128f3
Content-Type: text/plain; charset=ISO-8859-1

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

--0015175709884d30de047c9128f3--

Re: Are there any difference between max_connection and

--00504502b2230ed1a8047c915844
Content-Type: text/plain; charset=ISO-8859-1

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

--00504502b2230ed1a8047c915844--