linux_faq:rsyslog_mysql_loganalyzer_shrink

select count(*) from syslog where ReceivedAt > (curdate() - 3 months)

if it seems what you want to delete just replace select count with delete

Enter your comment. Wiki syntax is allowed:
T C H​ P M
 
  • linux_faq/rsyslog_mysql_loganalyzer_shrink.txt
  • Last modified: 2019/06/08 18:11
  • by admin