Mariadb bin log eat my disk space


#1

Hello, I create WPMu Subdomain with easy engine 3.0.5. in debian 7 VPS. After adding some subdomain, my disk space full.

100MB /var/log/mysql/mariadb-bin.000004
100MB /var/log/mysql/mariadb-bin.000011
100MB /var/log/mysql/mariadb-bin.000010
100MB /var/log/mysql/mariadb-bin.000008
100MB /var/log/mysql/mariadb-bin.000009
100MB /var/log/mysql/mariadb-bin.000007
100MB /var/log/mysql/mariadb-bin.000006
100MB /var/log/mysql/mariadb-bin.000005
815MB /var/log/mysql
817MB /var/log
1531MB /var
258MB /usr/lib
278MB /usr/share
159MB /usr/bin
752MB /usr
2447MB /

Any recommendations on how to fix this? Thank you


#2

Hi @geea,

Will you please check your disk space.You can use following command

df -h


#3
root@subnet:~# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/simfs       10G  8.0G  2.1G  80% /
none            256M  4.0K  256M   1% /dev
none             52M  168K   52M   1% /run
none            5.0M     0  5.0M   0% /run/lock
none            205M     0  205M   0% /run/shm
none            100M     0  100M   0% /run/user
root@subnet:~#

#4

@geea Are you using replication on this database?

If not replicating, there should be no real issue disabling bin-logging altogether. Do this by modifying the my.cnf file:

sudo pico /etc/mysql/my.cnf

Find the following line:

log_bin = /var/log/mysql/mysql-bin.log

Comment it out by adding # at the beginning of the line:

# log_bin = /var/log/mysql/mysql-bin.log

I believe you will also need to find and comment out the following lines:

expire_logs_days        = 10

…and…

max_binlog_size         = 100M

… to look like:

# expire_logs_days        = 10

…and…

# max_binlog_size         = 100M

Exit and save!

Restart the MySQL Server:

sudo service mysql restart

Might I also suggest:

  1. https://mariadb.com/kb/en/mariadb/show-binary-logs/
  2. http://www.youdidwhatwithtsql.com/purge-mysql-binary-logs/816/

#5

@bamajr thanks that fix the problem :smiley:


#6

Hi @geea

It’s been a long time, and we haven’t heard from you. It looks like your issue is resolved.

I am closing this support topic for now. Feel free to create a new support topic if you have any queries further. :slight_smile:


closed #7