# max connection

**URL:** <https://forums.percona.com/t/max-connection/1290>\
**Category:** Other MySQL® Questions\
**Created:** [November 11, 2009, 4:23am UTC](https://forums.percona.com/t/max-connection/1290 "2009-11-11T04:23:19Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![tonpet](https://avatars.discourse-cdn.com/v4/letter/t/c68b51/32.png) [@tonpet](https://forums.percona.com/u/tonpet)\
**Post date:** [November 11, 2009, 4:23am UTC](https://forums.percona.com/t/max-connection/1290/1 "2009-11-11T04:23:19Z")

</div>

Hello,

I have mySQL server over OS: Linux, CPU: AMD Athlon™ XP 1800+, RAM: 768 MB, HDD: ST340014A / 7200 rpm.

How much is max value on max\_connection, because 100 is not enough.

regards,

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [November 11, 2009, 7:13am UTC](https://forums.percona.com/t/max-connection/1290/2 "2009-11-11T07:13:42Z")

</div>

Depends on the purpose. For a web application, 100 connections is more than you will ever need. For applications that keep an active connection it might not be enough.

---

<div class="post-metadata">

**Author:** ![tonpet](https://avatars.discourse-cdn.com/v4/letter/t/c68b51/32.png) [@tonpet](https://forums.percona.com/u/tonpet)\
**Post date:** [November 11, 2009, 7:44am UTC](https://forums.percona.com/t/max-connection/1290/3 "2009-11-11T07:44:24Z")

</div>

Hello,

web application, but 100 is not absolute enough.

regards,

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [November 11, 2009, 1:12pm UTC](https://forums.percona.com/t/max-connection/1290/4 "2009-11-11T13:12:35Z")

</div>

Then optimization should be your objective rather than increasing the max connections.

---

<div class="post-metadata">

**Author:** ![tonpet](https://avatars.discourse-cdn.com/v4/letter/t/c68b51/32.png) [@tonpet](https://forums.percona.com/u/tonpet)\
**Post date:** [November 12, 2009, 2:01am UTC](https://forums.percona.com/t/max-connection/1290/5 "2009-11-12T02:01:53Z")

</div>

Hello,

What have for optimization? I have only 1 insert in script.

Problem is that application that make http request make more from 100 in sec… cool:

Can someone to say me is possible to increase max\_connection with this parameters on server.

regards,

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [November 14, 2009, 6:18am UTC](https://forums.percona.com/t/max-connection/1290/6 "2009-11-14T06:18:44Z")

</div>

Yes you can easily increase that to more. But again, you don’t want that.

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [November 16, 2009, 5:59am UTC](https://forums.percona.com/t/max-connection/1290/7 "2009-11-16T05:59:33Z")

</div>

This will help you  
[URL][http://www.omh.cc/mycnf/[/URL]](http://www.omh.cc/mycnf/%5B/URL%5D)