[Plugin: Better WP Security] wp_bwps_log file is bloating MySQL database (480MB Size!)

  • mrunal_patel

    (@mrunal_patel)


    11 years, 7 months ago

    I’ve two problems
    1. Despite clearing the log-files of BWP security from my dashboard, they still remain in the MySQL database, so mysql database is like 500+MB.
    2. How do I stop the Better WordPress security from creating log files in future?

    Elaboration
    I’ve about 700 posts and 3000 comments on my site.
    Yet mysql database was 529MB!
    So whenever I wanted to take backup, the various backup plugins simply won’t work and give errors like

    “Database error MySQL server has gone away for query”

    or

    “Cannot allocate sufficient memory”

    So, I manually checked the mysql database to find out how did it became 500+MB?
    and then I came to know that
    “wp_bwps_log” column had 480MB size!

    Then, I went to
    Wordpress dashboard> Better WP Security >”Logs” tab.
    I clicked the blue botton to remove the old datalogs.
    But yet, the “wp_bwps_log” column remained 480MB in size. (Ya I reloaded the page, cleared the cache but “wp_bwps_log” column still had 480MB)
    so, I manually give command in phpmyadmin, to empty this “wp_bwps_log”
    When I emptied it, the sql size reduced to barely 47MB.
    And now I’m again able to take backups of my site using various plug-ins.

    However, the “wp_bwps_log” still continues to grow in size every minute.
    so please tell me how do I shut down this logging process?

    http://wordpress.org/extend/plugins/better-wp-security/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Bit51 (part of the iThemes family)

    (@bit51)

    11 years, 7 months ago

    Are you saying clear logs didn’t erase the tables or was the mysql overhead the reason for the 480MB? In the case of the former I can look at and fix that. For the latter it’s a little trickier. Myisam tables need to be optimized to get rid of the overhead of deleted table rows. There unfortunately isn’t much I can do about that.

    Here’s another thought. What if I added an option that would clear out older entries/ Perhaps the user could specify the number of days? I’ve been hesitant to do this so far as security logs can be pretty important and, until your case, I hadn’t seen any logs that large (my own largest site which gets 1000 – 2000 uniques a day has a BWPS log of about 30MB after running since March). I’m definitely willing to work on this I just want to make sure any solution I implement will work for ya’ll.

    Thread Starter mrunal_patel

    (@mrunal_patel)

    11 years, 7 months ago

    @bit51

    Are you saying clear logs didn’t erase the tables

    Yes. That’s the problem, I checked it one more time. Even if I clear the logs through dashboard, they still show in the sql file under phpmyadmin. So I’ve to manually empty the table every once in a while.

    I hadn’t seen any logs that large (my own largest site which gets 1000 – 2000 uniques a day has a BWPS log of about 30MB after running since March)

    Well earlier I had blogspot, and then I moved to self hosted wordpress.
    While most of the posts got successfully imported, some articles couldn’t get imported. So plenty of 404s on my site. To fix them, I would have to manually write those articles again – which is too tiresome and boring, so I keep the site as it is. That’s how I got 480MB log file. 🙁

    But yes, I confirm the bug that

    shyguytwo

    (@shyguytwo)

    11 years, 4 months ago

    Obviously nothing has happened as I have the same problem. My BWPS-Log is growing to several 100 megabytes within a few days. Maybe a problem with HyperCache?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: Better WP Security] wp_bwps_log file is bloating MySQL database (480MB Size!)’ is closed to new replies.

Tags