On Friday, Aug 29, 2003, at 07:47 US/Eastern, Martin Marques wrote:
What do your mysql logs say?
They only show the startup and shutdown. (I'm looking at host.example.com.err in the "data" directory, which is all I can find in the way of a log. Should there be more? Can I change the settings to have it log more?)
Did you try to execute some small php script (just make a connection without a
query) from the web sites that have the problem? Look at the logs while you
do this.
Generally, when it goes down, I've been most interested in bringing my sites back up ASAP. :-( So I haven't tried any diagnostics while they're down, except for verifying that mysqld is running.
Assuming I can run a test connection script, which log should I be watching?
How's the load on the mysql server? Pings are OK between the servers?
It's all one box, so the load is the same for both machines. Pinging is, well, irrelevant. :-) I should have mentioned this.
Brief summary of my problem for those who missed the original:
El Jue 28 Ago 2003 20:29, Parker Morse escribió:Intermittently, the database connection function in PHP will fail for
two of those three sites. mysqld is still running on the server; however, if I restart mysqld, the sites resume working.
pjm
-- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
