Michael, you hit the nail on the head. We added --skip-name-resolve and changed our connnection string to use the IP instead of FQDN and now things are working fine. It must have been something with our DNS/ISP since we changed nothing and that stuff is out of our control.
The other thing was captured from our PHP logs. Not sure what that's on about. We'll just have to monitor it and see if pattern develops. Thanks for your help. Cheers, Tripp --- Michael Stassen <[EMAIL PROTECTED]> wrote: > Tripp Bishop wrote: > > Hello all, > > > > Suddenly in the last hour or so the connection > speed > > between our webserver and database server has > > skyrocketed to the point that our site is no > longer > > usable! Just trying to connection via the mysql > client > > takes a long time. Once the connection is > established, > > however, queries seem to execute in a timely > fashion. > > As far as we can tell the network connection > between > > the two boxes is fine (at least testing by ping > OK) > > and again, once connected everything seems fine. > > It's hard to be sure without knowing more, but if > the network is working, and > mysql works fine once connected, it sounds like it > might be a DNS problem. > Often the solution is to list hosts by IP rather > than hostname in the mysql user > table, and run mysqld with --skip-name-resolve. See > > <http://dev.mysql.com/doc/refman/5.0/en/access-denied.html>, > about a third of > the way down, for some hints about DNS problems. > > > We've seen some errors in our logs that state: > Can't > > connect to local MySQL server through socket > > '/var/lib/mysql/mysql.sock'. Why would php > > mysql_connect be trying to connect to the local > MySQL > > Server? Our connection string should point it to > the > > db server. > > Which logs? Are you sure this is the same problem? > What is the connection > string? Do you capture error messages from mysql in > your php script? > > > We're using php 4.3.9 and MySQL 4.0.20. > > > > Thanks for any help, > > > > Tripp > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
