Big Database

  • Resolved Bookutus

    (@bookutus)


    11 months, 1 week ago

    In Database, table xxxx_options is getting bigger and bigger.
    There are 10 Thousand Entries like “aiowps_captcha_string_info_xxxxxxxx” and “aiowps_captcha_string_info_time_xxxxxxxx”

    How can I delete them and prevent from growing further?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    11 months, 1 week ago

    Hi @bookutus,

    It is due to the Maths captcha enabled WP security > Brute force > Captcha settings. There is a daily cron job that removes this data. It might be some issue running the daily cornjob.

    Can you please install the WP Crontrol plugin?

    Tools > Cron events have aiowps_daily_cron_event Run now should run that cronob and delete of last 24 hrs old records.

    https://snipboard.io/cQZl9F.jpg

    Regards

    Thread Starter Bookutus

    (@bookutus)

    11 months, 1 week ago

    Thanks. And those that are older than 24 hours?

    We have 9 Million Entrys/Rows….

    • This reply was modified 11 months, 1 week ago by Bookutus.
    Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    11 months, 1 week ago

    Hi @bookutus,

    It should delete older than 24 hrs mean all before 24 hrs should be deleted.

    Here, you have a large number of records, so it’s better to remove them with DB access using phpMyAdmin and a SQL query.

    Regards

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

The topic ‘Big Database’ is closed to new replies.