Support » Plugin: Block Bad Bots and Stop Bad Bots Crawlers and Spiders and Anti Spam Protection » StopBadBot significantly slows down website

  • Resolved Michael

    (@michael8888)


    We tested on several sites with no other plugins enabled. StopBadBots always significantly slows down any kind of page. MySQL CPU load is extremely high whenever StopBadBots is enabled. The Query Monitor plugin identified several queries that are extremely slow and can take several seconds on large sites. This is one example:

    UPDATE wp_sbb_visitorslog
    SET human = ‘Human’…

    When we disabled the corresponding queries in the plugin’s functions.php StopBadBots is a bit faster but still too slow to be used on a large site.

    The problem seems to be that StopBadBots does a lot of unnecessary logging.

    Is this there a way to disable all logs?

Viewing 12 replies - 16 through 27 (of 27 total)
  • Plugin Author Bill Minozzi

    (@sminozzi)

    Always the same id (8388607) ?
    If yes, try to check the table. And fix it if necessary.
    You can do it with PHPmysql.

    Thread Starter Michael

    (@michael8888)

    Yes, always the same id. Should I delete the corresponding database entry?

    Plugin Author Bill Minozzi

    (@sminozzi)

    Probably this table have some issue.
    Try to Analise and fix it with phpMyAdmin or similar.

    Thread Starter Michael

    (@michael8888)

    I verified that the table is ok with mysqlcheck. The entry with the id 8388607 does indeed exist in the table and it is the only entry in that table.

    So it seems you have a bug in your plugin?

    Plugin Author Bill Minozzi

    (@sminozzi)

    The id should begin with number 1
    Try to remove this record and keep an eye on this table and database.

    Thread Starter Michael

    (@michael8888)

    I deleted the entry and StopBadBots immediately recreated the entry and the error persists. By the way, the url column contains “/feed/” Maybe that helps to find the bug.

    You can’t see the error message with Query Monitor?

    Plugin Author Bill Minozzi

    (@sminozzi)

    No error message here.
    Please, try in another site. (you told me you have many sites)
    Check if you have the last version of the plugin installed.
    Check also the WordPress version.
    Then, please, let me know.

    Thread Starter Michael

    (@michael8888)

    I tried it on another site. No plugins, standard WordPress theme. WordPress and plugin have the latest version. Error persists.

    I deleted the table and Query Monitor reports another error: Table does not exist. So you don’t even check if the table exists before you write into it.

    I also deleted all tables and then reinstalled the plugin. Error persists.

    My guess is that you don’t see the error because work with an upgraded installation. If you make a clean new install, you should be able to see the error.

    Plugin Author Bill Minozzi

    (@sminozzi)

    I just ran a test. Deleted the plugin and installed it again.
    The plugin created the table. No problems found.

    Every time the plugin is updated or activated, the plugin check for all the tables. Then, you can also deactivate and activate it again to run the test.

    It is not good idea to check for the table each time we will access it. That can overload the server.

    Early, you told me the table exist and is in good shape.Then, the plugin created it.

    Anyway, this plugin take around half minute more or less while is installing to create and fill out all the tables. Depends of the server speed. Maybe your PHP configuration don’t let the plugin complete the job and create and fill out all the tables. Check also for the script max execution time (max_execution_time directive).

    Check also our troubleshooting page:
    http://siterightaway.net/troubleshooting/

    The plugin is installed around almost 20.000 sites and nobody complain about this issue, only you.

    I think anything is wrong with your database server, MySql version/configuration or server/PHP configuration.

    Thread Starter Michael

    (@michael8888)

    I deleted the plugin now and then reinstalled. That worked on both servers with the error. Not sure why it didn’t work when I manually deleted the tables. The error is gone now. Really weird. I never had such case. Maybe something went wrong during an upgrade.

    Anyway, thanks a lot for your help!

    Plugin Author Bill Minozzi

    (@sminozzi)

    You are welcome.
    I’m glad hear it is working now.
    Happy new year!

    Thread Starter Michael

    (@michael8888)

    Thanks! Happy New Year!

Viewing 12 replies - 16 through 27 (of 27 total)
  • The topic ‘StopBadBot significantly slows down website’ is closed to new replies.