Truncate mysql tables?

 
1
0
-1

Does open-audit have a built in way to reduce old mysql data to conserve disk space? If not, then any specific tables you'd recommend focusing on? I'd like to keep the past year worth of data and trash the rest.

Centos 7.4.1708 and mysql 5.7.15. Thanks.

 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Log retention periods are set in the Configuration. Look for entries like log_retain_level_x, this is the number of days for logs at that level. Also make sure your log_level is set to 5 (or lower), as higher numbers can bloat the logs unnecessarily unless you're troubleshooting.

      1. andguent

        Thanks for your response. On the web interface I found the edit config page. My log_level is at 5 and my log_style is syslog. I don't see any other config entries starting with the word log. If log_retain_level is a feature added in the last two years I probably don't have it. Any other suggestions before I trudge around sql? Thanks for your time.

      CommentAdd your comment...