MySQL slow

Andy Green andy at warmcat.com
Mon Aug 27 10:41:58 UTC 2007


Somebody in the thread at some point said:

>> I talking about a instantenous query on the Windows machine that takes 10
>> seconds or more on the Linux machine.

Is it an external network-based connection to the MySQL server or all on
localhost?  If it is an external network-based connection, the first
place to look would be DNS problems.  How do you specify the machine
name the server is on?

Is DNS working on both boxes?

tcpdump the connection while you do one of these slow lookups and see if
that gives a clue.

-Andy




More information about the users mailing list