MySQL creating a ton of .BIN files

[ooshnoo]

As shown in the attached pic, MySQL is creating a ton of what I believe are binary log files, and it's filling up the hard drive. Not sure how this got enabled, or how to stop it, so if anyone can advise, that would be great.

[sdagley · Accepted solution]

@ooshnoo That's the default behavior for MySQL 8. Refer to Configuring MySQL 8.0 for Jamf Pro and note the instructions for disabling logging in the "Setting the --log-bin Option for Replication or Point-in-Time Recovery" section.

[ooshnoo]

@sdagley Thanks dude. Just turned it off, so will see what happens! Don't even know how it was enabled, as this issue just started.

[LiamS]

Experiencing this issue now, is it safe to delete these files on bin logging is turned off?

[sdagley]

@LiamS If you've turned off the logging option and restarted MySQL you can delete the -bin.xxxxxx log files