Purge Mysql/MariaDB Log Files

Discussion in 'Server Operation' started by chri.s, May 25, 2017.

  1. chri.s

    chri.s New Member

    Hi Guys,

    another topic: I have a Master-Master MariaDB Cluster while one host is fine (second one) the first one has a mysql/mariadb log file size of around 80% of overall capable disk space under /var/log/mysql. This could be reasoned in the heavy transactions on old-live to new-live database.

    Now i am wondering how to purge these huge data amount in the right way without disturbing cluster sync and killing mysql-server?
    Can i delete these logs out of mysql? With which command or do i need to set a special time for "autoclean"?

    Thank you in Advance!
     
  2. ruliezz

    ruliezz Member HowtoForge Supporter

    if you have logfile what eats 80% of your total disk space, I would definitely check that logfile and see what is going wrong. Because this is not normal. Or do you mean something else. Your message is not so clear to me :D
     
  3. chri.s

    chri.s New Member

    Hi ruliezz,
    as it seems it is solved. Was a problem with database master:master replication import...:)

    Thank you!
     
  4. chri.s

    chri.s New Member

    ....by the way, how can i mark it as solved?
     

Share This Page