Solved

IIS Limiting Connections to Mysql Database

Posted on 2010-09-20
6
575 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Accepted Solution

by:
pburns02 earned 0 total points
Comment Utility
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
Comment Utility
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
Comment Utility
The problem was with physical limitations of the server not software configuration.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Lync server 2013 Backup Service Error ID 4049 – After File Share Migration
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now