Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

IIS Limiting Connections to Mysql Database

Server OS: Windows Server 2008 R2
Dual Core 4 GB RAM
IIS 7.5, Joomla

When pressure testing from 1 IP address it seems as if IIS stops incoming connections from the IP address we're testing with. My questions is where do I allow the IP address to come in without a problem?
0
pburns02
Asked:
pburns02
  • 4
  • 2
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
pburns02,

Just for clarity, you have this listed as "limiting connections to MySQL", so please advise if my understanding below is incorrect:

From reading the question, it would appear to me that you are indicating that you are load testing your application (i.e., generating multiple simultaneous requests) and at a certain number of requests, no more requests are allowed.  IIS has settings for limiting the number of concurrent requests and so if you are seeing the same exact number this fails at every time that is probably what you are running into.

In IIS 6, this seeing was under Web Sites Properties | Performance | Web site connections and you have a radio button to either allow "Unlimited" or "Connections limited to" with a combo box where you could set the max number of connections.

You additionally, could set this restriction on a given web-site, so even if the server is set to unlimited connections, you may want to check that the site you are load testing hasn't been limited down.

I think I have a system I can check on configuration for IIS 7.5, so will let you know if different.

Kevin
0
 
Kevin CrossChief Technology OfficerCommented:
Otherwise, you could just be hitting the limitations of how many TCP / application connections your particular hardware can handle.
0
 
Kevin CrossChief Technology OfficerCommented:
By the way, for IIS 7.5, you would click on web-site and then under Manage | Configure > Limits...
"Limit number of connections" will either be unchecked for unlimited or checked with a specific number of connections in the text box.  You can also use Manage | Advanced Settings...set the Maximum Concurrent Connections value.  If set to unlimited, you will see a very large number already defaulted here.  You may note at the bottom of that screen [maxConnections] is the short form and that is the spelling of the parameter you can configure via your applications web.config if it is ASP.NET; therefore, you may want to check there also.

Here is a helpful link I found also:
http://www.dotnetscraps.com/dotnetscraps/post/Did-you-know-Set-Connection-Limits-in-IIS-7-75.aspx

Other thoughts, going back to the MySQL note in the question is you may be hitting the limits on MySQL connections which you would need to edit the MySQL ini (configuration) to allow more than the default.

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_connections

Kevin
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
pburns02Author Commented:
This was actually physical limitation to our server. The server would get flooded with requests and couldn't process them fast enough. We enabled Caching on the application pool and this solved the problem.
0
 
Kevin CrossChief Technology OfficerCommented:
Glad you figured it out.  That is what I thought -- http:#a33720646
Sometimes it is good to just analyze what is actually happening with your particular application and not just what is a good configuration.  Sounds like you have a good handle on it now.

Best regards,

Kevin
0
 
pburns02Author Commented:
The problem was with physical limitations of the server not software configuration.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now