size database
bertboerland@ww... - April 7, 2006 - 10:44
| Project: | Bad Behavior |
| Version: | 4.6.x-1.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | dpangier |
| Status: | closed |
Jump to:
Description
The size of the badbehavior_log.MYD keeps growing on my system:
-rw-rw---- 1 mysql mysql 28715212 Apr 7 11:45 bad_behavior_log.MYDIs there an easy way to limit this growth (if not, should it be configurable)?
What would the sql syntax be if I would like to clean this table by hand?
#1
The setting in "settings>bad behavior>Logging Duration" controls the number of days that the logs are held for, decrease this number to a figure appropriate for the spam volumes you are receiving.
Note "Verbose logging" logs every page access for diagnostic reasons, this may seriously effect your log table size.
The logging data can be safely cleared at any point with a sql command of the form "delete from bad_behavior_log;".
#2
thanks