-
Title
FMS unable to connect to External MYSQL DB due to binary log files on MYSQL server taking up all -
Description
FMS unable to connect to External MYSQL DB due to binary log files on MYSQL server taking up all available space on DB partition
-
Cause
By default MYSQL DB creates multiple binary log files (each file is approx 1GB in size) causing the disk to run out of free space and hence preventing Database startup
-
Resolution
Purge existing binary files by following proper procedure to free up the space
To prevent creation of Binary log files, edit my.ini (Windows platform) or my.cnf (UNIX/Linux platform) and comment out all lines
- starting with log-bin=
-starting with binlog_format=
Save the file and restart Database
-
Additional Information
Please refer to MYSQL documentation and confirm with your DBA that above changes would not have any adverse effects in your environment prior to making those changes.