Skip to main content
Solved

MySQL creating a ton of .BIN files

  • January 18, 2020
  • 4 replies
  • 39 views

Forum|alt.badge.img+14

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.

Best answer by sdagley

@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.

4 replies

sdagley
Forum|alt.badge.img+25
  • Jamf Heroes
  • Answer
  • January 19, 2020

@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.


Forum|alt.badge.img+14
  • Author
  • Honored Contributor
  • January 19, 2020

@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.


Forum|alt.badge.img+1
  • New Contributor
  • August 29, 2021

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


sdagley
Forum|alt.badge.img+25
  • Jamf Heroes
  • August 30, 2021

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


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