MySQL Kill Script?

  • Judith

    (@istudio)


    14 years, 11 months ago

    I have a site on HostGator that gets quite a bit of traffic. Twice in the last month the database stopped connecting because the site, according to HG, “has hit our MySQL kill script”. Beyond that comment they cannot tell me anything else, or worse yet what to do about it.

    Deactivated all plugins and switched to 2011 theme to rule out those issues — still no connection.

    HG is being unusually not cooperative — all they advised is deactivate plugins and use the default theme to trouble-shoot — which I had done /before/ asking for support.

    Can anyone enlighten me as to what can cause this and what I need to do? I really have no clue what to think of this…

    Thank you in advance!

Viewing 1 replies (of 1 total)
  • WPMuse

    (@wpmuse)

    14 years, 11 months ago

    This the latest from HostGator:

    “We are showing a history of this occurring daily, multiple times, for a long time. (I post only once a week and this is happening daily?)

    The MySQL kill script will kill any running SQL processes that have not completed after 30 seconds. This is a very long time for a SQL process to run, and does indicate an issue with the site(s) using the database in question.”

    ]# for kill in $(awk -F”[” ‘{print $2}’ <(awk -F”]” ‘{print $1}’ <(tail <(grep $(basename $(pwd)) /var/log/mysql_queries.log)))); do date -R -d@$kill; done

    Comments anyone?

    Any ideas?

Viewing 1 replies (of 1 total)

The topic ‘MySQL Kill Script?’ is closed to new replies.

Tags