Membership Plugin and Hostgator

After attempting to install the membership plugin and receiving an error in the wpmudev dashboard I started getting server disconnection errors. Then I got an email from HostGator saying they had to disable the script in the sub-folder where it was running, as it was to test the plugin. Another person did the same thing with another demo site with the same result. I then got another email telling me that they have placed a restriction on my username from MySQL. I have deleted the plugin from the server and I am still trying to get the restrictions lifted.

After talking to them they pointed me in the direction of their php limits below. But after reading them they don't seem to bad. I have also seen people have similar issues, any idea on what the problem is?

safe mode = Off (cannot adjust)
memory_limit = 256M (MAXIMUM)
max_execution_time = 30 (MAXIMUM in seconds)
max_input_time = 60 (MAXIMUM in seconds)
post_max_size = 64M (MAXIMUM)
upload_max_filesize = 64M (MAXIMUM)
enable_dl = Off (cannot adjust)

  • robert

    Hi @Patrick

    Thank you for your response, as far as the 30 sec max setting what would be a more suitable amount of time? I ask because I still need to maintain a shard account for these testing sites and a few clients that don't need much at all, and if I look to go to another hosting company I want to do my due diligence and ensure the limits they provide are good enough. I am already looking at VPS solutions with HG and others but with HG still not responding to the ticket and my username still under restriction I don't see staying with them for the VPS. The last time you send me some great articles for WP hosting, the only thing is that I need a managed hosting solution that is not just for WP, as we are looking to expand beyond. If you have any further recommendations they are always welcomed.
    The only thing I can find in the error log is the following:

    [02-Feb-2015 22:54:03 UTC] WordPress database error Lost connection to MySQL server during query for query SELECT * FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_name = 'wp_membership_news' and column_name='id' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, membership_news_install, membership_newsstreamcreatetables

  • robert

    According to HG:
    Unfortunately, we were forced to disable the script "/home2/visionk1/public_html/syntechfl.com/demosites/rmunoz/wp-admin/index.php" as it was causing high loading issues on the server. Due to this affecting all of the other accounts on the system, we had to take immediate action for the health of the server.

    Below were the active processes, MySQL queries, and incoming site requests at the time of suspension:
    Running Processes:
    visionk1 1529 1.6 0.1 355120 60300 ? SN 18:08 0:00 /opt/php54/bin/php-cgi /home2/visionk1/public_html/syntechfl.com/demosites/rmunoz/wp-admin/index.php
    visionk1 26435 0.4 0.1 354332 59628 ? SN 18:06 0:00 /opt/php54/bin/php-cgi /home2/visionk1/public_html/syntechfl.com/demosites/rmunoz/wp-admin/admin.php
    visionk1 32231 1.0 0.1 355116 60296 ? SN 18:08 0:00 /opt/php54/bin/php-cgi /home2/visionk1/public_html/syntechfl.com/demosites/rmunoz/wp-admin/index.php

    Running Queries:
    *************************** 1. row ***************************
    USER: visionk1_wrdp7
    DB: visionk1_wrdp7
    STATE: checking permissions
    TIME: 13
    COMMAND: Query
    INFO: SELECT * FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_name = 'wp_membership_rules' and column_name='id' LIMIT 1
    *************************** 2. row ***************************
    USER: visionk1_wrdp7
    DB: visionk1_wrdp7
    STATE: checking permissions
    TIME: 43
    COMMAND: Query
    INFO: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_name = 'wp_m_subscriptions_levels' and column_name= 'level_period_unit' LIMIT 1
    *************************** 3. row ***************************
    USER: visionk1_wrdp7
    DB: visionk1_wrdp7
    STATE: checking permissions
    TIME: 71
    COMMAND: Query
    INFO: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_name = 'wp_m_subscriptions_levels' and column_name= 'level_period_unit' LIMIT 1
    *************************** 4. row ***************************
    USER: visionk1_wrdp7
    DB: visionk1_wrdp7
    STATE: checking permissions
    TIME: 77
    COMMAND: Killed
    INFO: SELECT * FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_name = 'wp_membership_relationships' and column_name='id' LIMIT 1

    Open connections

    Current Site Requests:
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/admin-ajax.php
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/admin-ajax.php
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/admin.php?page=membership&action
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/admin.php?page=membership&action

    CPU_TIME:881 table_rows_read:128422 SELECTS:1485 ROWS_UPDATED:20882 ROWS_FETCHED:14226 BUSY_TIME:37260 ONNECTED_TIME:38773 BYTES_SENT:15649572 BYTES_RECEIVED:14418581 WAIT_TIME:36379

    Top table row reads:
    DB_USER: visionk1_wrdp6 -- TOTAL_CONNECTIONS: 16 -- CONNECTED_TIME: 212 -- CPU_TIME: 2 -- TABLE_ROW_READS: 127537 -- SELECT_COMMANDS: 1364 -- UPDATE_COMMANDS: -- BUSY_TIME: 2 -- BYTES_SENT: 15353543 -- BYTES_RECEIVED: 14407108 -- WAIT_TIME (IO): 0
    DB_USER: visionk1_wrdp5 -- TOTAL_CONNECTIONS: 3 -- CONNECTED_TIME: 10 -- CPU_TIME: 0 -- TABLE_ROW_READS: 885 -- SELECT_COMMANDS: 85 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 296029 -- BYTES_RECEIVED: 8133 -- WAIT_TIME (IO): 0
    DB_USER: visionk1_wrdp9 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 18002 -- CPU_TIME: 392 -- TABLE_ROW_READS: 0 -- SELECT_COMMANDS: 16 -- UPDATE_COMMANDS: -- BUSY_TIME: 17388 -- BYTES_SENT: 0 -- BYTES_RECEIVED: 2105 -- WAIT_TIME (IO): 16996
    DB_USER: visionk1_wrdp7 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 20549 -- CPU_TIME: 487 -- TABLE_ROW_READS: 0 -- SELECT_COMMANDS: 20 -- UPDATE_COMMANDS: -- BUSY_TIME: 19870 -- BYTES_SENT: 0 -- BYTES_RECEIVED: 2599 -- WAIT_TIME (IO): 19383

    Top WAIT (IO) TIME:
    DB_USER: visionk1_wrdp7 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 20549 -- CPU_TIME: 487 -- TABLE_ROW_READS: 0 -- SELECT_COMMANDS: 20 -- UPDATE_COMMANDS: -- BUSY_TIME: 19870 -- BYTES_SENT: 0 -- BYTES_RECEIVED: 2599 -- WAIT_TIME (IO): 19383
    DB_USER: visionk1_wrdp9 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 18002 -- CPU_TIME: 392 -- TABLE_ROW_READS: 0 -- SELECT_COMMANDS: 16 -- UPDATE_COMMANDS: -- BUSY_TIME: 17388 -- BYTES_SENT: 0 -- BYTES_RECEIVED: 2105 -- WAIT_TIME (IO): 16996
    DB_USER: visionk1_wrdp6 -- TOTAL_CONNECTIONS: 16 -- CONNECTED_TIME: 212 -- CPU_TIME: 2 -- TABLE_ROW_READS: 127537 -- SELECT_COMMANDS: 1364 -- UPDATE_COMMANDS: -- BUSY_TIME: 2 -- BYTES_SENT: 15353543 -- BYTES_RECEIVED: 14407108 -- WAIT_TIME (IO): 0
    DB_USER: visionk1_wrdp5 -- TOTAL_CONNECTIONS: 3 -- CONNECTED_TIME: 10 -- CPU_TIME: 0 -- TABLE_ROW_READS: 885 -- SELECT_COMMANDS: 85 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 296029 -- BYTES_RECEIVED: 8133 -- WAIT_TIME (IO): 0

    visionk1 31248 9.0 0.3 396672 101812 ? SN 17:48 0:01 /opt/php54/bin/php-cgi /home2/visionk1/public_html/bonappeteats.com/wp-admin/admin-ajax.php
    visionk1 32292 30.2 0.2 384376 89760 ? DN 17:48 0:01 /opt/php54/bin/php-cgi /home2/visionk1/public_html/bonappeteats.com/wp-admin/admin-ajax.php

    Mon Feb 2 17:48:30 CST 2015
    Running Processes:
    visionk1 31248 8.6 0.3 396672 101812 ? SN 17:48 0:01 /opt/php54/bin/php-cgi /home2/visionk1/public_html/bonappeteats.com/wp-admin/admin-ajax.php
    visionk1 32292 24.4 0.2 384376 89760 ? DN 17:48 0:01 /opt/php54/bin/php-cgi /home2/visionk1/public_html/bonappeteats.com/wp-admin/admin-ajax.php

    Running Queries:
    *************************** 1. row ***************************
    USER: visionk1_wrdp6
    DB: visionk1_wrdp6
    STATE:
    TIME: 0
    COMMAND: Sleep
    INFO: NULL
    *************************** 2. row ***************************
    USER: visionk1_wrdp6
    DB: visionk1_wrdp6
    STATE:
    TIME: 4
    COMMAND: Sleep
    INFO: NULL

    Open connections

    Current Site Requests:
    50.87.146.103 bonappeteats.visionserver.info /wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=0&c
    50.87.146.103 bonappeteats.visionserver.info /wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=0&c
    50.87.146.103 bonappeteats.visionserver.info /wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=1&c
    50.87.146.103 bonappeteats.visionserver.info /wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=1&c
    50.87.146.103 bonappeteats.visionserver.info /wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=1&c
    50.87.146.103 bonappeteats.visionserver.info /wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=1&c
    50.87.146.103 bonappeteats.visionserver.info /wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=1&c
    50.87.146.103 bonappeteats.visionserver.info /wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=1&c
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/admin-ajax.php
    73.49.106.31 syntechfl.visionserver.info /demosites/rmunoz/wp-admin/admin-ajax.php

    Reference: ui
    Server: gator3008.hostgator.com
    Srv. Type: cpanel
    Created: Wed Oct 16 15:36:33 2013
    Acct Type: Shared
    Plan: Baby Croc
    User: visionk1
    U. Domain: visionserver.info
    Email: visionk13@gmail.com
    IP: 50.87.146.103 (shared)

    Doc Root: /home2/visionk1/public_html
    Shell: /usr/local/cpanel/bin/jailshell

    CPU Usage: 33.2% (warning)

    Wait time hit 36379 > 2000
    Cpu Time hit 881 > 450

    Current load: 17:48:30 up 36 days, 8:28, 2 users, load average: 0.02, 0.00, 0.00

  • Michelle Shull

    Hi, Robert!

    On a dedicated server, you shouldn't have to worry about these settings, you'll be able to tweak them yourself, so as long as you've got the hardware you need, you should be fine.

    As for a host, I know of a couple of options.
    1. Digital Ocean - this is fantastic if you're fairly tech-savvy. It's inexpensive, and you can see/control everything. Setting up for the first time can be tricky, but they have excellent support docs that will walk you through pretty much any hosting situation from WordPress to Joomla to whatever you can imagine.
    2. In terms of a less intensive setup, I've worked with a few general hosts, including Bluehost, LunarPages, and GoDaddy. They all had their pros and cons - as hosting is wont to do - so the best plan is to go in knowing what you want and what you need.

    A. Sufficient memory. If your site is active, with lots of simultaneous traffic, you'll need memory to make sure everything loads on time.
    B. A powerful processor. Make sure your host uses modern equipment. Ask about what hardware they use, and Google it to see how old it is.

    I think HostGator shut you down (they disabled your admin dashboard) because of CPU usage. You were using 32% of your server's total CPU, which would have throttled the performance of any other sites hosted on the same box. It seems like you're running some pretty robust plugins (WordFence seems to use a lot of CPU resources when it scans, especially), so it makes sense that you've rapidly outgrown your shared environment, even while you're still in test mode.

    Good luck finding a new host! Ask as many questions as you need when you're shopping around, so you find a host you can stick with.

    Take care!

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.