From: Martin Gainty Date: May 5 2009 1:03pm Subject: RE: Slow connecting to MySQL from Windows App List-Archive: http://lists.mysql.com/mysql/217400 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_83dc2192-1235-4c0b-9809-630f92f1d4d6_" --_83dc2192-1235-4c0b-9809-630f92f1d4d6_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable please follow my earlier suggestion and place=20 long_query_time=3DNumberOfSecs min_examined_row_limit=3DMinNumberOfRowsToExamine in my.cnf or my.ini start mysqld --log-slow-queries[=3Dfile_name] documentation available at=20 http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html Shalom Martin Gainty=20 ______________________________________________=20 Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note= de d=E9ni et de confidentialit=E9=20 This message is confidential. If you should not be the intended receiver=2C= then we ask politely to report. Each unauthorized forwarding or manufactur= ing of a copy is inadmissible. This message serves only for the exchange of= information and has no legal binding effect. Due to the easy manipulation = of emails we cannot take responsibility over the the contents. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng= er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter= leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l= ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin= dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w= ir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes= pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat= isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e= ou la copie de ceci est interdite. Ce message sert =E0 l'information seule= ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d= onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation= =2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni= . > Date: Tue=2C 5 May 2009 08:43:51 -0400 > From: groups@stripped > To: mysql@stripped > Subject: Slow connecting to MySQL from Windows App >=20 > Hi=2C >=20 > I am hoping someone here can help me. I have an Ubuntu 8.04 server that=20 > has worked FINE for months. The other day=2C the client rebooted it. They= =20 > shut it down properly and then later started it up again. (The server=20 > was not experiencing any problems when they did it=2C there were other=20 > reasons). Ever since then=2C when I try to connect to the MySQL server it= =20 > is running dead slow. As in 20-30 seconds to get a connect. >=20 > By the way=2C I just tried it with MySQL Administrator and it has problem= s=20 > connecting as well so it is not the connector. >=20 > The server is located internally on a gigabit network. >=20 > Any assistance would be greatly appreciated... >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped= om >=20 _________________________________________________________________ Hotmail=AE goes with you.=20 http://windowslive.com/Tutorial/Hotmail/Mobile?ocid=3DTXT_TAGLM_WL_HM_Tutor= ial_Mobile1_052009= --_83dc2192-1235-4c0b-9809-630f92f1d4d6_--