Solved

IIS Limiting Connections to Mysql Database

Posted on 2010-09-20
6
589 Views
Last Modified: 2012-05-10
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
Comment
Question by:pburns02
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 33720513
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
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 33720646
Otherwise, you could just be hitting the limitations of how many TCP / application connections your particular hardware can handle.
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 33720722
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
Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

 

Accepted Solution

by:
pburns02 earned 0 total points
ID: 34034829
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
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 34039456
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
 

Author Closing Comment

by:pburns02
ID: 34075163
The problem was with physical limitations of the server not software configuration.
0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question