DominaDollI recently switched hosting back to my old domain, where my old MySQL and wordpress installation are. Everything is there, so that's good. But I am experiencing sporadic 500 errors (most of the time my site is down). I have contacted my provider and they said:
"Our database error logs show that one of your websites is causing your account to reach its maximum CGI connections.
These errors can either be caused by a bad plugin or module, or a large amount of traffic coming to your site.
Here is the latest database error log from your site:
==== START ====
Nov 26 16:02:09 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Query querytime=21 query=SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND
Nov 26 10:49:30 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=53 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:29 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=52 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:28 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=51 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:27 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=50 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:26 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=49 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:25 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=48 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:24 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=47 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:23 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=46 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:22 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=45 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:21 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=44 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:20 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=43 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:19 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=42 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:18 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=41 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:17 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=40 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:16 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=39 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:15 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=38 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:14 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=37 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:13 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=36 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 10:49:12 <udb19.user.info> monitormysql: kill dbusername=u70681722 hosttype=cgi querytype=Killed querytime=35 query=SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
Nov 26 00:25:55 <cgi17.local2.info> php: mysql connection failed for dbuser=u70681722 uid=2455933 uri=- db=10.8.12.19:3306 pass='6dd9fd' (Lost connection to MySQL server during query)
==== END ===="
I looked at my bandwidth and am only using 10% and also my traffic seems to be very small from my stats, but I assume those are only the people who actually make it on to my site when it is up.
I deactivated all my plug-ins and it looked like it was working better, then I posted a new post and it went up, but a few minutes later I got the 500 error again. Is this a hosting problem or wordpress problem?
Any ideas? I hope to get this issue resolved as my site has been down for a week.
Thank you in advance for your help.
Domina
