How to pinpoint the problem on mysql


#1

hello,

i have a problem. i am using themify framework on a debian vps. and after upgrading to wordpress 4.8, interesting problem occured. whenever i work on a draft page for a certain feature, mysql is crashing. and all sites in vps goes down with it.

I need to pinpoint problem. what steps would you suggest to pinpoint why this problem occur and source of it?


#2

hi @auludag

It is strange that wp core update caused this issue. This might be because of any custom code or configuration. Check following logs for getting more details about what caused mysql crash,

tail -f /var/log/mysql.log tail -f /var/log/syslog

also check the site’s error log under tail -f /var/log/nginx/example.com.error.log

Hope this would give some information to debug this issue.


#3

thanks for reaching out @antopjoseph. tail -f /var/log/mysql.log gives empty. i checked out mysql logs and saw zero bytes.

and after a little digging, i think i found the culprit. there are some misconfiguration on UFW firewall and CDN config I guess.


#4