Clean/reduce size of database

  • Resolved Matt Scheidler

    (@matt6303)


    8 months ago

    CleanTalk did an excellent job blocking hundreds of thousands of attempts against a single site over a multiple-day period.

    I have since blocked the IP ranges on the server, and now the CleanTalk activity is back to normal levels.

    During this period of time, the “wp_cleantalk_no_cookie_data” table in the database grew significantly. Now that I’ve resolved the root issue, is there a way that I can safely reduce the size of this table?

    Thank you for your help.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support SergeM

    (@serge00)

    Hello @matt6303,

    I’m transferring your question to the programmer staff.

    Please, wait up to 5 business days.

    Plugin Support katereji

    (@katereji)

    Hello.

    Thank you for waiting.

    To resolve this please change the ‘Set cookies’ option to ‘On’ in the Anti-Spam plugin settings.

    Thread Starter Matt Scheidler

    (@matt6303)

    Katereji, thank you for the reply.

    This setting had been on “Auto” and I have changed it to “On”.

    That will prevent this from occurring in the future, but my question remains – is there a way to safely remove the massive amount of rows that were stored in the “wp_cleantalk_no_cookie_data” table in the database?

    Plugin Support katereji

    (@katereji)

    Not sure, I’ll ask our developers. Write you back asap.

    Plugin Support SergeM

    (@serge00)

    Hello @matt6303,

    Yes, you can clear the table “wp_cleantalk_no_cookie_data” manually. Please, take note that the table itself should be there for the plugin to work properly, just clear its content.

    Did it help you?

    Thread Starter Matt Scheidler

    (@matt6303)

    Serge, thank you. I found that the wp_cleantalk_no_cookie_data table is empty, without me doing anything extra. I suppose that the table cleared on its own when I made the settings change in WordPress?

    Regardless, the overall size of the site is now back to expected levels because this massive database table has been cleared. Thank you for your help.

    Plugin Support SergeM

    (@serge00)

    Yes, you are correct. Thank you for your confirmation.

    If you don’t mind, please leave your review of your experience using the CleanTalk plugin:
    https://www.ads-software.com/support/plugin/cleantalk-spam-protect/reviews

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Clean/reduce size of database’ is closed to new replies.