You are not logged in.

#1 2013-04-03 08:48:05

Xi0N
Member
From: Bilbao - Spain
Registered: 2007-11-29
Posts: 780
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
Developer
From: Poland
Registered: 2010-02-26
Posts: 109

Re: Mysql's binlogs eating up a lot of drive space


Arch Linux - rolling release distro, which users want to downgrade to the previous version

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

Board footer

Powered by FluxBB