Thown off server due to high server load! Help!

  • ampersand

    (@ampersand)


    21 years ago

    So here is what my server is telling me….

    amptoons.com on Server 99 was suspended for
    mySQL usage causing server loads > 50…

    | 34 | amptoon_barry | localhost | amptoon_wpress | Query | 92 | Copying to tmp table | SELECT * FROM alas_bas_visitors, alas_bas_refer, alas_bas_ua, alas_bas_os WHERE referer = referer_id |
    | 36 | amptoon_barry | localhost | amptoon_wpress | Query | 91 | Copying to tmp table | SELECT * FROM alas_bas_visitors, alas_bas_refer, alas_bas_ua, alas_bas_os WHERE referer = referer_id |
    | 37 | amptoon_barry | localhost | amptoon_wpress | Query | 91 | Copying to tmp table | SELECT * FROM alas_bas_visitors, alas_bas_refer, alas_bas_ua, alas_bas_os WHERE referer = referer_id |
    | 42 | amptoon_barry | localhost | amptoon_wpress | Query | 87 | Copying to tmp table | SELECT * FROM alas_bas_visitors, alas_bas_refer, alas_bas_ua, alas_bas_os WHERE referer = referer_id |

    If you are able to digest what is going on, there seems to be a copy of the entire tables of several databases to a temp tables. It is probably the repeated copying of these tables that are causing a huge drain of resources on our server.

    Do you have any reason as to why this is happening? [….]

    The loads are incredibly excessive. Basically you are using half of all the resources that the server is possibly capable of.

    Please do some research to find out if there might be a version issue, if there is a bug in the version you are using or if this behaviour is normal.

    This problem appears to have cropped up suddenly in the last day or two (a similar problem happened before, but they thought they had solved it). I haven’t made any changes to the blog (apart from new posts) in a month or so, not even fiddling with the design; nor is my traffic any higher than usual, as far as I know.

    I’m fairly desparate – my entire website is down! And I’m computer-illiterate, so I have no idea what to tell them!

    If anyone could make any suggestions, please let me know here!

    Also, do you think I should switch from TotalChoiceHosting to a server where the tech people will know more about WordPress?

    If you want to read the entire exchange between me and the server rep, follow this link.

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Michael Bishop

    (@miklb)

    21 years ago

    Perhaps since this happened to you two months ago, this thread http://wordpress.org/support/topic/26372 might refresh your memory.

    Moderator James Huff

    (@macmanx)

    21 years ago

    In short:

    1. Try disabling all plugins, one of them is probably causing the load.

    2. Try switching to the Default theme. There could be some stray code in your current theme causing a nasty loop.

    3. As a last resort, switch to a better hosting provider.

    Ajay

    (@ajay)

    21 years ago

    Faced problem 1 as macmanx posted above.

    http://wordpress.org/support/topic/34606

    Thread Starter ampersand

    (@ampersand)

    21 years ago

    Miklb,

    Two months ago, it turned out that the problem was being caused by a Movable Type installation (!) that was lying ignored on the server, from back before I switched to WordPress. We deleted all the MT related stuff, and that fixed the problem. (I didn’t post about this solution on the WP forums because it seemed such a wildly oddball problem that I didn’t think it would apply to anyone else).

    But since that MT stuff was entirely deleted, I thought this problem, despite its similarities, must be something new. I admit, though, I should have thought of going back to that old thread. My apologies for that.

    Michael Bishop

    (@miklb)

    21 years ago

    No apologies neccessary. Without knowing that you had an oddball solution to your first problem, you can understand how easy it would be to assume the two were possibly the same or similar. There was a lot of great info in that thread, so I would still use the processes listed.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Thown off server due to high server load! Help!’ is closed to new replies.