Bill Earl wrote:
> It seems to just be something with that initial connection, whether
> it's through ssh or mysql. Viewing the process list and top while
> logging in from another system doesn't show anything starting up or
> using a lot of cpu time.
>
> Does anyone have any suggestions on what to check? This started
> sometime overnight, and all the normal nighttime processes completed
> okay with no errors. They're on an internal network, not exposed to
> the Internet, so I don't suspect an intrusion.
* What changed overnight? Did someone update ssh, mysqld, mysql
client, change mysql config settings, etc? If this is a new
occurrence, then something must have changed. If you can figure
out what it was, you'll have your answer.
* 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.
* Can you monitor how many users are connected to the db server at
once? Maybe you have a limit there. (To see your limit, do "SHOW
VARIABLES LIKE 'max_connections'". It might be interesting to
just do "SHOW VARIABLES" and look for anything which seems odd.)
* Do you have any queries which lock the 'mysql' database or any of
its tables? If so, all other users would have to wait until the
lock is released to authenticate/connect.
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)