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]
