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:
I​ S N​ U N
 
  • linux_faq/rsyslog_mysql_loganalyzer_shrink.txt
  • Last modified: 2019/06/08 18:11
  • by admin