Bill Earl wrote:
>> * What happens when/if you connect to mysql via some other method
>> (like a PHP or Perl script)? If you get the same long pause, then
>> it's probably something internal to mysqld. If the script can
>> connect instantly, it's probably in the mysql client program or in
>> ssh.
>
>
>
> I've since found a third internal machine (also a SuSE machine, btw,
> but 9.0) exhibiting the same behavior that started this morning. This
> machine has apache running and an app that connects to mysql on that
> machine, and the web performance is speedy. However, just logging in
> by ssh is slow (as it is on all the machines).
What kind of app is running, PHP, Perl, Java, etc? What's different
about how it connects to your mysql machine? Does your web app use a
hostname or an IP to find your mysql server?
Others ideas about checking DNS sound relevant, but if your web app uses
a domain name to connect to mysql, then that wouldn't be true.
I should say : I know MySQL OK, but I'm a total dunce when it comes to
network connections and such, so I'm probably not much help from here on
out. All I can offer is general trouble-shooting ideas... But, I'll
keep reading to see how it goes.
alex
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)