MySQL Forums :: Performance :: How to troubleshoot slow response from MySQL


Advanced Search

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 7579 Jesper Petersen 04/12/2011 01:05PM
Re: How to troubleshoot slow response from MySQL 2436 Rick James 04/13/2011 07:35PM
Re: How to troubleshoot slow response from MySQL 3176 Jesper Petersen 04/18/2011 03:59AM
Re: How to troubleshoot slow response from MySQL 2628 Rick James 04/18/2011 07:38PM
Re: How to troubleshoot slow response from MySQL 2408 Jesper Petersen 04/21/2011 03:09PM


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.