[CentOS] Web pages time out after server rebuild

nate centos at linuxpowered.net
Wed Jan 21 17:32:01 UTC 2009


Rob Kampen wrote:

> How do I get some extra log info to track this down?

Have you tried to run 'show full processlist' on mysql while
the query is running? It should show all active queries, what
they are doing and how long they have been running for.

Also enable slow query logging and logging when not using
indexes, add to /etc/my.cnf and restart mysql:

example:
log-slow-queries        = /var/lib/mysql_logs/slowqueries.log
log-queries-not-using-indexes
long_query_time = 3

nate



More information about the CentOS mailing list