[Plugin: Better WP Security] wp_bwps_log file is bloating MySQL database (480MB Size!)
-
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?https://www.ads-software.com/extend/plugins/better-wp-security/
- The topic ‘[Plugin: Better WP Security] wp_bwps_log file is bloating MySQL database (480MB Size!)’ is closed to new replies.