Data file kpg_stop_sp_reg_stats overloading server resources

  • Resolved kmapst

    (@kmapst)


    10 years, 4 months ago

    I received the below email from my hosting company and the problematic query relates to a data file for Stop Spammers Spam Control kpg_stop_sp_reg_stats . Do you know what may be causing this issue?

    Thanks, in advance, for the help.

    The MySQL database on your WordPress hosting account caused an overload of shared resources for the server on which it resides.

    Due to the serious, immediate nature of this problem, it became necessary to disable access to the database, until such time as it could be safely reinstated without further negative impact.

    As we are unable to troubleshoot custom scripting, we are unable to provide a specific solution to you. However the following information was provided by our administrators:

    Example problematic query excerpt and available info:
    ### UPDATE b3002540439825.wp_589kgvd4n3_options
    ### WHERE
    ### @1=9817
    ### @2=’kpg_stop_sp_reg_stats’
    ### @3=’a:195:{s:6:”badips”;a:2:{s:13:”61.160.212.57″;s:19:”2016/01/23 23:01:07″;s:15:”178.158.102.208″;s:19:”2016/01/24 00:03:51″;}s:7:”goodips”;a:1:{s:14:”76.213.148.176″;s:19:”2016/01/24 17:13:49″;}s:4:”hist”;a:26:{s:19:”2016/01/24 16:23:25″;a:6:{i:0;s:14:”76.213.148.176″;i:1;s:0:””;i:2;s:21:”forms_page_gf_entries”;i:3;s:24:”/wp-admin/admin-ajax.php”;i:4;s:25:”Good Cache:76.213.148.176″;i:5;s:0:””;}s:19:”2016/01/24 16:25:25″;a:6:{i:0;s:14:”76.213.148.176″;i:1;s:0:””;i:2;s:21:”forms_page_gf_entries”;i:3;s:24:”/wp-admin/admin-ajax.php”;i:4;s:25:”Good Cache:76.213.148.176″;i:5;s:0:””;}s:19:”2016/01/24 16:27:25″;a:6:{i:0;s:14:”76.213.148.176″;i:1;s:0:””;i:2;s:21:”forms_page_gf_entries”;i:3;s:24:”/wp-admin/admin-ajax.php”;i:4;s:25:”Good Cache:76.213.148.176″;i:5;s:0:””;}s:19:”2016/01/24 16:29:28″;a:6:{i:0;s:14:”76.213.148.176″;i:1;s:0:””;i:2;s:21:”forms_pag

    https://ww.wp.xz.cn/plugins/stop-spammer-registrations-plugin/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Keith P. Graham

    (@kpgraham)

    10 years, 4 months ago

    Your site is being hammered by spammers. The stats collection is updated in options every time you get hit by a spammer. You can try unloading Stop Spammers so you get less database activity, but spammers are the problem.

    You can also reduce the log file size so that the size of the data is much lower. It should be 25 by default. On the log reports page set it to 10.

    Consider using a htaccess file to block known spam sites. The htaccess file will kill spammers before they hit wordpress.

    Better yet, change to a host that specializes in WordPress and can help prevent spammers from hitting your site.

    I would immediately set up CloudFlare for your site. CloudFlare will cache you pages and block known spammers – and its free.

    Keith

    Thread Starter kmapst

    (@kmapst)

    10 years, 4 months ago

    Keith,

    Thanks for the quick response. I am using GoDaddy’s WordPress hosting and it doesn’t work with CloudFlare, unfortunately. The website has a forum section so it’s a big target for spammers.

    Thank you again,
    Kristin

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

The topic ‘Data file kpg_stop_sp_reg_stats overloading server resources’ is closed to new replies.

Tags