Gigantic Database

  • andrewcharon

    (@andrewcharon)


    11 years, 1 month ago

    I’ve been evaluating WordPress for security purposes on a site that gets a significant amount of traffic. Six months after implementation, the result is a 1 GB+ database of logs of every single activity that happened on the site, which was unanticipated.

    The fix is to disable logging, which is easy, but I’m still left with a 1 GB+ database with info that we don’t need. Is there a simple way of cleaning up that database within the functionality of WordFence (not within DB)?

    Thank you!

    Andrew

    https://ww.wp.xz.cn/plugins/wordfence/

Viewing 4 replies - 1 through 4 (of 4 total)
  • WFSupport

    (@wfsupport)

    11 years, 1 month ago

    What tables are filling up?

    tim

    Thread Starter andrewcharon

    (@andrewcharon)

    11 years, 1 month ago

    The largest tables are:
    wp_wfHits
    wp_wfLeechers

    These are significant but a bit smaller:
    wp_wfScanners
    wp_wfStatus

    Thread Starter andrewcharon

    (@andrewcharon)

    11 years, 1 month ago

    Within your plug-in, is there a way to minimize/customize quantity of data going into table wp_wfHits and wp_wfLeechers?

    davefezz

    (@davefezz)

    10 years, 12 months ago

    Hi there,
    any update on this – as since enabling wordfence my database grows and grows.
    I remove transients and revisions but the database continues to grow.
    I am considering WP-Optimize for this.
    Any advice is appreciated.
    Regards,
    Davef

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

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