Love the Plug-In and all has been running well, now HostGator has shut us down with the following reason:
"This message is to advise you of a temporary block placed on your database. The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved." and "Reviewing the logs on your site I'm seeing a large number of errors being logged similar to the following ::
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17260 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17261 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17262 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17263 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17265 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17266 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17267 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17268 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17269 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17270 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17271 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17272 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
These are MySQL queries for your WP Autoresponder plugin. Reviewing the MySQL queries that this plugin is executing shows that it is executing a large number of queries even just when viewing the subscribers list. It appears to be building a distinct list of all the emails for each page, then executing another query to pull each specific email addresse's information. While these queries are returning rather quickly, which is surprising due to the high number of queries it is executing, it is hitting our limits for the number of rows that are read during these queries. Especially when sending your mailing list out it appears."
Love the Plug-In and all has been running well, now HostGator has shut us down with the following reason: "This message is to advise you of a temporary block placed on your database. The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved." and "Reviewing the logs on your site I'm seeing a large number of errors being logged similar to the following ::
[11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17260 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17261 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17262 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17263 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17265 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17266 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17267 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17268 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17269 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17270 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17271 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process [11-Jul-2013 18:25:55] WordPress database error MySQL server has gone away for query SELECT nid from wp_2wpr_subscribers where id=17272 made by do_action_ref_array, call_user_func_array, _wpr_postseries_process
These are MySQL queries for your WP Autoresponder plugin. Reviewing the MySQL queries that this plugin is executing shows that it is executing a large number of queries even just when viewing the subscribers list. It appears to be building a distinct list of all the emails for each page, then executing another query to pull each specific email addresse's information. While these queries are returning rather quickly, which is surprising due to the high number of queries it is executing, it is hitting our limits for the number of rows that are read during these queries. Especially when sending your mailing list out it appears."