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
Solved

IIS Limiting Connections to Mysql Database

Posted on 2010-09-20
6
583 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
  • 4
  • 2
6 Comments
 
LVL 59

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 59

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 59

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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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 59

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

829 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