Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

IIS + MySQL

  
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Next:  Different Stylesheet Behavior IIS 5.1 & 6.0  
Author Message
lellosplendor

External


Since: May 26, 2005
Posts: 3



(Msg. 1) Posted: Fri Jul 01, 2005 3:55 am
Post subject: IIS + MySQL
Archived from groups: microsoft>public>inetserver>iis (more info?)
Hello all!

I've developed a web site that makes more than 3 millions page views per
month. It uses ASP pages in all the site except for the forum that is
made in PHP (phpbb).
I'm running Windows 2000 SP4 + IIS on a dedicated machine.

All the web site uses MySQL databases that are stored into another
machine in the same LAN (I cannot access to that server: it's not mine).

I have no problems (DLLHOST always ok, CPU occupation is normal, general
performances are good) except for the following issue: sometimes the
MySQL server seems to answer very slowly to the queries made by the web
site. When this happens, sometimes my IIS server goes crazy because it
receives no (or slow) answer from the MySQL server that is on the other
machine in the same network.

Reducing timeout values in IIS could be helpful?
What are your best suggestion in order to solve my problem?

Thanks in advance!

 >> Stay informed about: IIS + MySQL 
Back to top
Login to vote
noway

External


Since: Oct 08, 2004
Posts: 28



(Msg. 2) Posted: Fri Jul 01, 2005 3:38 pm
Post subject: Re: IIS + MySQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
> I have no problems (DLLHOST always ok, CPU occupation is normal, general
> performances are good) except for the following issue: sometimes the
> MySQL server seems to answer very slowly to the queries made by the web
> site. When this happens, sometimes my IIS server goes crazy because it
> receives no (or slow) answer from the MySQL server that is on the other
> machine in the same network.

What do you mean exactly by IIS going "crazy"? If possible set a timeout on
the MySQL connection then handle the error in code...

- SG

 >> Stay informed about: IIS + MySQL 
Back to top
Login to vote
user1772

External


Since: Jun 10, 2004
Posts: 1807



(Msg. 3) Posted: Sat Jul 02, 2005 3:55 pm
Post subject: Re: IIS + MySQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Fri, 01 Jul 2005 07:17:28 GMT, lellosplendor <SPAMOUT RemoveThis @SPAMOUT.XX>
wrote:

>I've developed a web site that makes more than 3 millions page views per
>month. It uses ASP pages in all the site except for the forum that is
>made in PHP (phpbb).
>I'm running Windows 2000 SP4 + IIS on a dedicated machine.
>
>All the web site uses MySQL databases that are stored into another
>machine in the same LAN (I cannot access to that server: it's not mine).
>
>I have no problems (DLLHOST always ok, CPU occupation is normal, general
>performances are good) except for the following issue: sometimes the
>MySQL server seems to answer very slowly to the queries made by the web
>site. When this happens, sometimes my IIS server goes crazy because it
>receives no (or slow) answer from the MySQL server that is on the other
>machine in the same network.
>
>Reducing timeout values in IIS could be helpful?
>What are your best suggestion in order to solve my problem?

Solve the latency issue. It could be network related, database
related, code related, or even a result of something else on either
machine. IIS doesn't care what database you use or where, it serves
HTTP requests. The rest is your code, and your network.

Jeff
 >> Stay informed about: IIS + MySQL 
Back to top
Login to vote
user1580

External


Since: Apr 03, 2004
Posts: 367



(Msg. 4) Posted: Sun Jul 03, 2005 6:55 am
Post subject: Re: IIS + MySQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"lellosplendor" <SPAMOUT.RemoveThis@SPAMOUT.XX> wrote in message
news:c66xe.98057$75.4456468@news4.tin.it...
> Hello all!
>
> I've developed a web site that makes more than 3 millions page views per
> month. It uses ASP pages in all the site except for the forum that is
> made in PHP (phpbb).
> I'm running Windows 2000 SP4 + IIS on a dedicated machine.
>
> All the web site uses MySQL databases that are stored into another
> machine in the same LAN (I cannot access to that server: it's not mine).
>
> I have no problems (DLLHOST always ok, CPU occupation is normal, general
> performances are good) except for the following issue: sometimes the
> MySQL server seems to answer very slowly to the queries made by the web
> site. When this happens, sometimes my IIS server goes crazy because it
> receives no (or slow) answer from the MySQL server that is on the other
> machine in the same network.
>
> Reducing timeout values in IIS could be helpful?
> What are your best suggestion in order to solve my problem?

If MySQL has deadlocks or db locks you could create a longer queu at IIS but
that does not solve the problem. The default settings for IIS concerning the
Queue are really OK.
You could set the HTTP timeout to a low value, say 10 seconds instead of 900
(or what it was). Still, a low connection timeout does not help your users,
it only helps IIS.

--
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm


> Thanks in advance!
 >> Stay informed about: IIS + MySQL 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
IIS and mySQL - I've got some server space from easily.co.uk which includes a mySQL database. I'm currently designing a site which I want to test locally using IIS, but during testing I still want it to access the mySQL database which is held on easily's server. I've....

ASP.NET n MySQL - Does asp.net n mysql works well? I am creating an active server running on IIS, may I ask is it a good choice to choose mysql to build my database. I choose mysql because its free. Are there any disadvantages or problems if I use asp.net and mysql. ..

Canīt connect to mysql - Iīve installed IIS, php4.3.3, mysql4.0.18, phpmyadmin2.5.3 and also mysql administrator on Win XP pro. The system works fine with php. No problems there. But, when I try to connect to mysql I get the following messages: #2003 - Can't connect to MySQL..

Problem with php and mysql - I have WinXP and installed the IIS. Tried to install php 4.3? something but it doesnīt work at all. IIS works but not php. Whatīs wrong? Iīve also tried to install mysql but it doesnīt work at all and thatīs quite alright I suppose due to the errors with...

PHP/MySQL Problem - Hi guys, I'm using IIS on Vista Ultimate. I installed PHP just fine but I can't get MySQL to work with it, I keep getting the same error: ....call to undefined function mysql_connect() Here is what I've done to no avail: in php.ini: extension_dir =....
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]