Re: Web pages time out after server rebuild

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]





Rob Kampen wrote:


nate wrote:
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

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
Have entered those into the my.cnf file, restarted mysqld and monitored the file - no entries forthcoming with the faulty page request. looking at show full processlist, I see the start of a new process, then almost immediately it goes to sleep and then just sits there....
Thanks for these items Nate - look useful for the future.
I think I need to look in the php direction....
Rob
------------------------------------------------------------------------

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
Found the issue - in the php we are doing a strtotime() call and we did not have the date.timezone setup, thus for every call to this function it was calling the error reporting code and dumping all the stack trace data, thus using up 30 seconds and timing out.
Thanks all for your comments and help
Rob
begin:vcard
fn:Rob Kampen
n:Kampen;Rob
email;internet:rob@xxxxxxxxxxxxxxxxx
tel;cell:407-341-3815
version:2.1
end:vcard

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux