XF 1.5 Cron locking up MYSQL server?

[Andy Larkins]

Ive had to restart my MYSQL server last Monday morning and again this morning.

If there a way I can pinpoint what CRON ran when?

Are there logs I can look at that may point to whats up?

 

[Andy Larkins]

Just looked, there is nothing from Feb 29 or Mar 7 in Server Error log

 

[Mike]

What makes you think it's cron related? What do you mean by "locking" up? Have you looked at MySQL process list while the issue happens?

 

[Andy Larkins]

Fair question. I'll wait again. I was making an assumption that something was running on a Monday morning.

My remedy was I stopped the MYSQL server and restarted same and the site came back alive.

 

[Mike]

At the least, I'd recommend connecting to MySQL and running a "SHOW FULL PROCESSLIST;" query when you have the problem. (We'd need the full output from that -- bear in mind it may be quite long.)

 

[Andy Larkins]

Thanks - I'll get that next time.