On an AEM Forms installation, you may notice "mysql-bin.xxxxx" files are generated by MySQL database and take up considerable disk space:
This behavior is caused because Binary Logs are enabled on the MySQL database. This option is enabled in the "my.ini" configuration file used to initialize the MySQL database:
# Replication Master Server (default)
# binary logging is required for replication
# binary logging format - mixed recommended
You can safely purge those files using either of the following queries:
SHOW BINARY LOGS;
PURGE BINARY LOGS TO 'mysql-bin.xxxx'
(Replace xxxx in the PURGE command with the highest running number obtained from the SHOW BINARY LOGS; command).
PURGE BINARY LOGS BEFORE '2008-04-02 22:46:26';
(Replace '2008-04-02 22:46:26' with today's date to purge all files)
To avoid any further increase, you can either disable Binary Logs using:
SET sql_log_bin = 0;
Or set up a purge rotation:
SET GLOBAL expire_logs_days = 3;