• ampersand

    (@ampersand)


    Hi! I run a moderately busy poliblog (1000-2000 hits a day), using WordPress. My server has recently kicked me off, saying that my blog was too much stress or traffic or something.

    Here’s the info I got from the server. I’m pretty computer-illiterate – can anyone tell me in plain English what’s going on? Have I got WordPress set wrong somehow? Did I go through a DoS attack? Or do I just need to find a better server?

    Many thanks!

    Hello,

    we suspended and moved your account to “Quantz” server because of the following reasons.

    Too many php processes and mysql connections caused Europa to hang.
    Here are the log files from Europa:

    Processes running while server had load issues:
    ————————————————————————————-
    freedo15 9616 0.0 0.1 14940 5728 ? S Feb24 0:01
    /usr/bin/php
    theenn2 29054 2.3 0.1 14556 7156 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29062 7.8 0.2 15128 7800 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29134 3.0 0.1 14408 7080 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29191 3.5 0.1 14420 7080 ? S 17:09 0:00
    /usr/bin/php
    root 29266 1.0 0.1 12796 4576 pts/2 S 17:09 0:00
    /usr/local/bin/php -q /etc/lunarscripts/menu/shell_runp
    theenn2 29289 15.5 0.1 14904 7500 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29301 8.0 0.1 14520 7068 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29325 15.0 0.1 14420 7076 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29466 2.2 0.1 14540 7152 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29534 11.0 0.2 15132 7748 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29537 12.3 0.2 15128 7748 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29542 3.3 0.1 14416 7080 ? S 17:09 0:00
    /usr/bin/php
    theenn2 29644 0.0 0.1 14424 7080 ? S 17:09 0:00
    /usr/bin/php
    ——————————————————————————–

    MYSQL log:
    ——————————————————————————–
    ———————————–+
    | 2073 | theenn2_amptoons | localhost | theenn2_MT | Query |
    4 | Copying to tmp table | SELECT alas_posts.*,
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas |
    | 2078 | theenn2_amptoons | localhost | theenn2_MT | Query |
    4 | Copying to tmp table | SELECT alas_posts.*,
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas |
    | 2079 | theenn2_amptoons | localhost | theenn2_MT | Query |
    2 | Copying to tmp table | SELECT alas_posts.*,
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas |
    | 2083 | theenn2_amptoons | localhost | theenn2_MT | Sleep | |
    | 2084 | theenn2_amptoons | localhost | theenn2_MT | Query |
    2 | Copying to tmp table | SELECT alas_posts.*,
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas |
    | 2607 | theenn2_amptoons | localhost | theenn2_MT
    Query | 6 | Copying to tmp table | SELECT alas_posts.*,
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas || 2608 | theenn2_amptoons | localhost | theenn2_MT |
    Query | 6 | Copying to tmp table | SELECT alas_posts.*,
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas || 2610 | theenn2_amptoons | localhost | theenn2_MT |
    Query | 5 | Copying to tmp table | SELECT alas_posts.*,
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas |
    | 2612 | theenn2_amptoons | localhost | theenn2_MT
    Query | 5 | Copying to tmp table | SELECT alas_posts.*,
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas |
    | 2613 | theenn2_amptoons | localhost | theenn2_MT
    Query | 3 | Copying to tmp table | SELECT alas_posts.*
    MAX(comment_date) AS max_comment_date FROM alas_comments,
    alas_posts WHERE alas |………….
    ——————————————————————————————

    Your account’s STATS before we suspended your account:

    theenn2 theennead.com
    Average cpu usage : 6.66%
    Average memory usage:1.63%
    Average Mysql Usgae : 0.6
    Top Process%CPU 72.0/usr/bin/php
    Top Process%CPU 63.0/usr/bin/php
    Top Process%CPU 50.0/usr/bin/php

    Hence we moved you to Quantz first to solve the issue of the degraded service on Europa and second as a courtesy in order to prevent any downtime on your site to allow you time to rectify the situation. Currently, your site is not suitable for a shared hosting environment.

Viewing 6 replies - 31 through 36 (of 36 total)
  • ampersand – if you have any difficulty, feel very free to email me.

    Thread Starter ampersand

    (@ampersand)

    I would have emailed you, but I couldn’t find your email address. ??

    I’m using the instructions for restoring the database found here and here. However, when I tell phpmyadmin to upload the database from my hard drive, I alwasy get this error:

    ‘Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 91’

    This happens even though the file size (27993 KB) doesn’t exceed the “maximum file size” stated by phpmyadmin (51,200 KB).

    Is there any alternative way of restoring all the old posts and comments from my previous server?

    S.K

    (@kichu)

    //I would have emailed you, but I couldn’t find your email address. :-)//
    @ampersand,

    Podz can be contacted thru this form as found on his website:-

    https://www.tamba2.org.uk/contact/scform.php

    Regards
    S.K

    S.K

    (@kichu)

    Sorry!

    Correction.

    This is it:

    tamba2 at gmail dot com

    Hurriedly,
    S.K

    Has this issue/or knowledge of what happened with Lunarpages been solved?

    Reason is I have two sites that are on Lunarpages (using wp) and are about to expire and If there are still Lunarpages issues then I will def, move to another host

    TIA

    l??k

    Make sure your host is running the latest version of MySQL 4.1x . I believe there were issues w.r.t. max_connections in some of the ealier releases.

    I encountered the problem when upgrading to phpMyAdmin version 2.7.0-pl1 on my test server. As soon as I examined a WordPress DB using this version of phpMyAdmin, for some reason threads associated with the WP database connection users started to be spawned by the bucketful. Even though there is supposed to be always one connection reserved for the root user, I couldn’t log on at the MySQL console with a “max_connections for user” error. A reboot of the server did not clear the connections – and none of my applications could connect to MySQL.

    I amended the max_connections value in the INNODB section from 0 to 800 (see below) and restarted MySQL – et voila! Everything back to normal

    I’ve finally got my reason to upgrade to 5 I think , lol.

    Relevant section from Mysql my.ini file:

    # Number of threads allowed inside the InnoDB kernel. The optimal value
    # depends highly on the application, hardware as well as the OS
    # scheduler properties. A too high value may lead to thread thrashing.
    innodb_thread_concurrency=10
    #The maximum number of active connections for a single user (0 = no limit).
    max_user_connections=0
    #note from Sokrates: changed above value to 800

Viewing 6 replies - 31 through 36 (of 36 total)
  • The topic ‘Kicked off server – can anyone tell me what’s happening?’ is closed to new replies.