# Community Edition max\_connections limit?

**URL:** <https://forums.percona.com/t/community-edition-max-connections-limit/779>\
**Category:** Other MySQL® Questions\
**Created:** [May 27, 2008, 1:14pm UTC](https://forums.percona.com/t/community-edition-max-connections-limit/779 "2008-05-27T13:14:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mindaugas](https://avatars.discourse-cdn.com/v4/letter/m/48db29/32.png) [@mindaugas](https://forums.percona.com/u/mindaugas)\
**Post date:** [May 27, 2008, 1:14pm UTC](https://forums.percona.com/t/community-edition-max-connections-limit/779/1 "2008-05-27T13:14:45Z")

</div>

Does MySQL Server community edition have a connection limit? Even something hidden, or can you specify any amount you like for “max\_connections” ?

---

<div class="post-metadata">

**Author:** ![mwallace](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@mwallace](https://forums.percona.com/u/mwallace)\
**Post date:** [May 27, 2008, 9:16pm UTC](https://forums.percona.com/t/community-edition-max-connections-limit/779/2 "2008-05-27T21:16:57Z")

</div>

[http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl](http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl) es.html  
[http://dev.mysql.com/doc/refman/5.0/en/too-many-connections](http://dev.mysql.com/doc/refman/5.0/en/too-many-connections). html

Login to your mysql instance and try the following:  
show status where variable\_name like “%onnection%”;  
show variables where variable\_name = “max\_connections”;

---

<div class="post-metadata">

**Author:** ![mindaugas](https://avatars.discourse-cdn.com/v4/letter/m/48db29/32.png) [@mindaugas](https://forums.percona.com/u/mindaugas)\
**Post date:** [May 28, 2008, 9:03am UTC](https://forums.percona.com/t/community-edition-max-connections-limit/779/3 "2008-05-28T09:03:52Z")

</div>

Thanks for the answer!

Sorry I wasn’t clear, I am the sys admin and that isn’t the issue. I remember reading something a while ago that there is a limit to the value you can set for max\_connections on community edition. IE, the build comes with a built in limit, so even if I set 2000, it only allows 1500 and ignores the limit or something.

Also, is there any info on how many conns Windows Server 2003 R2 SP2 can handle, if it is a dedicated MySQL server? Is it equivalent to \*nix? 500-1000?

Edit

Ok, I found out there is no limit except what the OS can handle. Basically we ran into one user that was opening about 20-30 connections and slowing down the server greatly. It was just one user with that many connections. The connections were simply sleeping though so I don’t understand how it could have brought the box down to a crawl like that. Unless it had something to do with threading. My boss wanted to to know if the community edition even supported a large number of max\_connections though, even though that is not the issue.