Interesting limitation of MySQL on Windows

I am simply amazed by this. These are servers M$ touts are off-the-shelf 
production quality servers!!!

http://dev.mysql.com/doc/mysql/en/Windows_vs_Unix.html

[...]
Limited number of ports
    Windows systems have about 4,000 ports available for client connections, 
and after a connection on a port closes, it takes two to four minutes before 
the port can be reused. In situations where clients connect to and disconnect 
from the server at a high rate, it is possible for all available ports to be 
used up before closed ports become available again. If this happens, the 
MySQL server will appear to have become unresponsive even though it is 
running. Note that ports may be used by other applications running on the 
machine as well, in which case the number of ports available to MySQL is 
lower. 
[...]

[Ofcourse, MS KB has registry fixes for this ;) ]

Products affected

 (http://support.microsoft.com/default.aspx?scid=kb;en-us;196271#appliesto)

    * Microsoft Windows Server 2003, Web Edition
    * Microsoft Windows Server 2003, Standard Edition
    * Microsoft Windows Server 2003, Enterprise Edition
    * Microsoft Windows XP Home Edition
    * Microsoft Windows XP Professional
    * Microsoft Windows XP Media Center Edition
    * Microsoft Windows XP Tablet PC Edition
    * Microsoft Windows 2000 Server
    * Microsoft Windows 2000 Advanced Server
    * Microsoft Windows 2000 Professional
    * Microsoft Windows NT Workstation 4.0
    * Microsoft Windows NT Server, Enterprise Edition 4.0
    * Microsoft Windows NT Server 4.0


-- 
Sandip Bhattacharya
sandip (at) puroga.com
Puroga Technologies Pvt. Ltd.
Work: http://www.puroga.com        Home: http://www.sandipb.net

GPG: 51A4 6C57 4BC6 8C82 6A65 AE78 B1A1 2280 A129 0FF3