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