You are not logged in.
- Topics: Active | Unanswered
#1 2013-09-23 05:30:55
- Xi0N
- Member
- From: Bilbao - Spain
- Registered: 2007-11-29
- Posts: 832
- Website
[SOLVED] /var/lib/mysql/mysql-bin.XXXXX Eating a lot of space
Hi
I use mariadb for Icinga, and over a year, the files over at /var/lib/mysql/* became almost one GB each.
I'm looking for a way to reduce these files size. It the reason is Icinga keeping too long history records, cutting it to one whole year would be nice.\
What do you suggest me to do with these files?
Cheers.
Last edited by Xi0N (2013-09-23 10:35:56)
Offline
#2 2013-09-23 10:35:43
- Xi0N
- Member
- From: Bilbao - Spain
- Registered: 2007-11-29
- Posts: 832
- Website
Re: [SOLVED] /var/lib/mysql/mysql-bin.XXXXX Eating a lot of space
Fixed: http://forums.mysql.com/read.php?10,78659,78660
With your mysql client :
mysql -u root -p
then
mysql> flush logs;
will create a brand new mysql-bin.0000xy
mysql> purge binary logs to 'mysql-bin.0000xy';
will purge all your logs files before the last.
Offline