AEM Forms disk space issue for turnkey installation or using MYSQL DB in same server



We might have got in a situation where there server on AEM Forms JEE is installed got into disk space issue. The space issue does not always seems to be of crx repository or tar size. It happens with DB side as well as DB takes backups incase to restore.

For turnkey installation or using MYSQL DB in same server with AEM Forms, you can follow below steps to check if the space issue is caused by DB or not.

1) Go to MYSQL directory--> data folder.

2) Check if there is any 'mysql-bin.number' file(s) generated. If yes, check what is the size of these files. Sometimes these files occupy 10-20 gb's of data. These are the database binary logs which DB takes incase to restore the DB to prior state.

3). If this data is not required for restoration or you have 7 days worth of binary logs, it is likely that you can delete the past 4-6 days worth of binary logs for space . But it needed to be removed from the server with script.

4) You need to login to MYSQL command line via admin. For that, run mysql -u root -p in MYSQL--> bin folder. enter mysql schema password. For turnkey, it will be either password or adobe.

5) Once logged in, run the purge command: PURGE BINARY LOGS TO 'mysql-bin.010'. This will delete all the bin-data files prior to 010. 10 is just a number for reference.