ISPConfig 3/mySQL Logs not rotated

Discussion in 'General' started by reason8, Sep 20, 2016.

  1. reason8

    reason8 Member

    Hello and good evening.
    I am running ISPConfig 3 on openSUSE 13.1.
    My root partition is filling up with mySQL logs.
    Does ISPConfig rotate the mysql logs?
    If not, what is the best way to rotate these logs?
     
  2. florian030

    florian030 Well-Known Member HowtoForge Supporter

    Ispconfig does not rotate the logs. You can use logrotae or disable some of the mysql-logs
     
  3. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    Do you mean mysql binlog files? If so try 'PURGE BINARY LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 7 DAY);' and then look into config options to keep that cleaned up (expire_logs_days), or schedule a cronjob to do that.

    In either case (syslog or binlog) you can look at moving /var/ off the root partition if you have a better place for it to live.
     

Share This Page