Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Boost 1
Level 1
manpreet_bhatia
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
manpreet_bhatia
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
manpreet_bhatia
Level 1

20-11-2018

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.

Replies

Avatar

Avatar
Boost 50
Employee
WASIL
Employee

Likes

50 likes

Total Posts

386 posts

Correct Reply

51 solutions
Top badges earned
Boost 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Boost 50
Employee
WASIL
Employee

Likes

50 likes

Total Posts

386 posts

Correct Reply

51 solutions
Top badges earned
Boost 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
WASIL
Employee

05-12-2018

Good one! also, there is a KB : "mysql-bin.xxxxx" files taking up Disk Space on AEM Forms

Cheers,

Wasil