[ https://issues.apache.org/jira/browse/CLOUDSTACK-5860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhinandan Prateek updated CLOUDSTACK-5860: ------------------------------------------- Priority: Major (was: Critical) > Bin-logs are not deleted even after the expire_logs_days interval. > ------------------------------------------------------------------ > > Key: CLOUDSTACK-5860 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5860 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: Management Server > Affects Versions: 4.3.0 > Reporter: Kiran Koneti > Assignee: Damodar Reddy T > Fix For: 4.3.0 > > > In the /etc/my.cnf file added two parameters expire_logs_days=1 > max_binlog_size=150M ,which means that the bin-logs which are rotated should > be deleted after one day and the log should be rotated only after the max > size is exceeded.the logs are not rotated until it has reached the limit but > the previous logs which are rotated are not deleted. > The below are the file details in the "/var/lib/mysql" > ls -ltr > total 172628 > drwx------. 2 mysql mysql 4096 Oct 23 18:11 test > drwx------. 2 mysql mysql 4096 Oct 23 18:11 mysql > drwx------. 2 mysql mysql 4096 Nov 18 17:32 kiran > drwx------. 2 mysql mysql 4096 Nov 18 17:32 swathi > -rw-rw----. 1 mysql mysql 39105494 Jan 10 16:20 mysql-bin.000036 > -rw-rw----. 1 mysql mysql 125 Jan 10 16:28 mysql-bin.000037 > -rw-rw----. 1 mysql mysql 57 Jan 10 16:32 mysql-bin.index > srwxrwxrwx. 1 mysql mysql 0 Jan 10 16:32 mysql.sock > -rw-rw----. 1 mysql mysql 156 Jan 10 16:32 mysqld-relay-bin.000015 > -rw-rw----. 1 mysql mysql 52 Jan 10 16:32 mysqld-relay-bin.index > drwx------. 2 mysql mysql 4096 Jan 10 16:37 cloudbridge > drwx------. 2 mysql mysql 4096 Jan 10 16:38 cloud_usage > drwx------. 2 mysql mysql 12288 Jan 10 16:38 cloud > -rw-rw----. 1 mysql mysql 5242880 Jan 13 12:14 ib_logfile1 > -rw-rw----. 1 mysql mysql 1160427 Jan 13 16:09 mysql-bin.000038 > -rw-rw----. 1 mysql mysql 35651584 Jan 13 16:09 ibdata1 > -rw-rw----. 1 mysql mysql 90288777 Jan 13 16:09 mysqld-relay-bin.000016 > -rw-rw----. 1 mysql mysql 76 Jan 13 16:09 master.info > -rw-rw----. 1 mysql mysql 5242880 Jan 13 16:09 ib_logfile0 > -rw-rw----. 1 mysql mysql 63 Jan 13 16:09 relay-log.info > Here we can clearly see the " mysql-bin.000036" and "mysql-bin.000037" > which were rotated on 10th Jan is not removed till 13th Jan. -- This message was sent by Atlassian JIRA (v6.1.5#6160)