You are not logged in.
- Topics: Active | Unanswered
#1 2013-04-03 08:48:05
- Xi0N
- Member
- From: Bilbao - Spain
- Registered: 2007-11-29
- Posts: 832
- Website
Mysql's binlogs eating up a lot of drive space
I just noticed the root partition being filled up, having like 3 or 4 1gb-each files that are supposed to be mysql binaly log files.....
How can I tell mysql to stop using those/downsize them/purge them?
Is it safe or will it affect the apps using mysql?
Offline
#2 2013-04-03 12:53:09
- Barthalion
- Forum Fellow
- From: Poland
- Registered: 2010-02-26
- Posts: 111
Re: Mysql's binlogs eating up a lot of drive space
Offline
#3 2013-04-03 20:17:27
- briest
- Member
- From: Katowice, PL
- Registered: 2006-05-04
- Posts: 468
Re: Mysql's binlogs eating up a lot of drive space
Xi0N wrote:
How can I tell mysql to stop using those/downsize them/purge them?
Is it safe or will it affect the apps using mysql?
Binary logs are needed for replication and/or point-in-time recovery. Other than that, mysql server and tools work perfectly without them, so you may turn logging off -- just comment out log-bin in my.cnf.
Offline