Skip to content
  • How to start learning Linux
  • Labtech Implementation Stuff
  • Clogged
  • Active Directory DNS Troubleshooting
  • Some Roulette  Strat from Reddit
  • Mystery steel processing and testing
  • Croissants and Rose Lychee Cream
  • Mac and Cheese
  • DFS Replication: Requirements and Configuration
  • Services.msc not opening in Windows 11/10
  • Microsoft AD LDAP (2008): Importing Your Certificate .pfx File into the AD DS Personal Store
  • Powershell How to get all groups that a user is a member of?
  • Home Energy Saving Tips
  • Changing NTFS Security Permissions using PowerShell
  • VALORANT’S 128-TICK SERVERS

Merserver

Its a website

  • Uncategorized
  • IT
  • Unreal Engine
  • GameDev
  • Interesting Stuff
  • Food
  • Web Design
  • Kubernetes
  • Music
  • Linux
  • Auto
  • Fishing
  • Gaming
  • Magic the Gathering
  • Toggle search form

Clearing out binlogs mysql

Posted on January 8, 2021 By samadmin

If the binlogs are growing too large, you can trim them and set them up to auto-trim

Run these commands

PURGE BINARY LOGS BEFORE (NOW() – INTERVAL 90 DAY);
SET GLOBAL expire_logs_days=90;

and then add “expire_logs_days=90” to the [mysqld] section of my.ini

Now the logs will not be kept longer than 90 days.

Uncategorized

Post navigation

Previous Post: Clearing Cookies etc. From Using CMD
Next Post: Compact/Shrink a Bloated VHDX (Hyper-V VM Drive) in Powershell

Related Posts

Enable Smart Search in eclinicalworks Uncategorized
Editing Macros in Dragon Uncategorized
Disabling “Other Suggestions” in Outlook 2016 Uncategorized
Office 365 errors out when converting to shared email Uncategorized
e911 Test Call Script Uncategorized
How to Edit Your Hosts File in Windows 10 Uncategorized

Copyright © 2025 Merserver.

Powered by PressBook Masonry Dark