MySQL Forums
Forum List  »  Performance

How to troubleshoot slow response from MySQL
Posted by: Jesper Petersen
Date: April 12, 2011 01:05PM

Hello

I have a MySQL server (v5.1.44-community) running on a Windows Server 2003 server with 4GB memory. The server is a dedicated MySQL server running nothing else than the SQL server.

Recently the server has become very slow in respoding to new TCP connections.

I've been capturing the network traffic between one of our webservers and the SQL server. After the web server has created the TCP connection with the SQL server more than 10 seconds pass before the SQL server responds with its "hello".
After that the web server can log in and do its query. The login procedure and the query is executed within a few milliseconds, so that is not an issue.

Do you have any good ideas as to why the SQL server is so long to respond to a new connection or how I can troubleshoot it? The server is not under any heavy load at all; CPU is always below 5%.

I have very little experience with SQL servers in general.

The server has not been updated in any way (drivers, etc.) - only Windows security updates.

Let me know if you need any other information.

Best regards
Jesper



Edited 2 time(s). Last edit at 04/12/2011 02:03PM by Jesper Petersen.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to troubleshoot slow response from MySQL
7697
April 12, 2011 01:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.