Huge Database table “cerber_files”

  • Resolved stafca

    (@stafca)


    4 years, 6 months ago

    Hello,

    I am using WP-Cerber free version plugin now sinds beginning 2020 on a fresh installed wordpress site.
    Every month I do a Site Integrity Full Scan. The load is about 20,000 rows per scan in the DB table “wp_cerber_files”.
    Each Scan the table is growing (up to 80,000 rows and more).
    The maintenance tasks (hourly 1, hourly 2 and daily) are performing.
    It seems this table is never optimized.

    I did the following:
    * empty the table manually
    * perform a Repair Cerber’s Tables

    Nothing helps.

    By doing scans, the table is still growing.

    It seems there is a fault in the plugin.

    I am looking forward to a solution.

    Best regards,
    Staf

    Installed plugin version: WP Cerber Security, Antispam & Malware Scan 8.6.3

    System info:
    Web Server Apache
    PHP version 7.4.6
    Server API fpm-fcgi
    Server platform Linux
    Memory limit 256M
    Default PHP timezone UTC
    Disabled PHP functions symlink
    WordPress version 5.4.1
    WordPress locale nl_NL
    WordPress options DB table sbz6_options
    MySQLi YES
    MySQL Native Driver (mysqlnd) YES
    PHP allow_url_fopen Disabled
    PHP allow_url_include Disabled
    Persistent object cache Not detected

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author gioni

    (@gioni)

    Hi! That table is maintained in a fully automatic mode. Try to run this SQL statement:

    SELECT DISTINCT scan_id FROM wp_cerber_files

    You have to see no more than 5 rows.

    Plugin Author gioni

    (@gioni)

    How’s it going?

    Thread Starter stafca

    (@stafca)

    Hi Gioni,

    Thank you for your reply and apologies for the late reply.
    I ran the SQL statement, and see 5 rows then.
    But when I go back to the table, I see 74021 rows now.
    Table size 36,6 MIB.

    In my feeling this is not OK. My database is growing to much.

    Thank you for your review.

    Best Regards,
    Staf

    Plugin Author gioni

    (@gioni)

    Your table is OK. You need to exclude it from a backup. That’s all.

    Mine is 26 Mo. It is the biggest size in my database among all plugins. How is this possible ?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Huge Database table “cerber_files”’ is closed to new replies.