Solved

Slow windows 2003 connection to mysql

Posted on 2006-11-06
7
242 Views
Last Modified: 2010-03-18
I have php as a web server on a IIS windows 2003 web edition on one machine and a mysql database installed on another win xp pro machine.
Ever since I have upgraded to my web server win 2003 I have a very slow connection between my website and the mysql machine.

Please help.
What should I check?
I don't know if this is the right place to post this.
0
Comment
Question by:eyal_barouk
[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
  • 3
7 Comments
 
LVL 48

Expert Comment

by:Jay_Jay70
ID: 17884818
have you looked at perfmon and done some recording of whats causing the slowness
0
 

Author Comment

by:eyal_barouk
ID: 17887620
I am not really sure where to look.
0
 
LVL 48

Expert Comment

by:Jay_Jay70
ID: 17887749
probably the NIC counters would be your best bet to see if its a traffic issue
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:eyal_barouk
ID: 17887872
Thanks Jay_Jay70,
Can you please direct me to where I can set the NIC counters?
Sorry but I am more a programmer than I am a technician.
0
 
LVL 48

Accepted Solution

by:
Jay_Jay70 earned 500 total points
ID: 17894781
no need for apologies at all and this is just a small option

start - run - perfmon

under system monitor right click and add counter -

under performance object choose Network Interface

this will show you in real time whats going on - may help but may not as well
0
 

Author Comment

by:eyal_barouk
ID: 17896733
Firstly I got the problem solved by the the EE MYSQL TC:
http://www.experts-exchange.com/Databases/Mysql/Q_22051436.html

Secondly, I have learned a new thing which I'm sure I will refer to in the future, so here are the points.

Thanks again.
0
 
LVL 48

Expert Comment

by:Jay_Jay70
ID: 17897191
Excellent, glad you fixed it!
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
An article on effective troubleshooting
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

729 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