# Clean up binary log files

**URL:** <https://forums.percona.com/t/clean-up-binary-log-files/2011>\
**Category:** Other MySQL® Questions\
**Created:** [March 7, 2013, 2:46am UTC](https://forums.percona.com/t/clean-up-binary-log-files/2011 "2013-03-07T02:46:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![systemali](https://avatars.discourse-cdn.com/v4/letter/s/b9bd4f/32.png) [@systemali](https://forums.percona.com/u/systemali)\
**Post date:** [March 7, 2013, 2:46am UTC](https://forums.percona.com/t/clean-up-binary-log-files/2011/1 "2013-03-07T02:46:55Z")

</div>

Hello Every one,

I have a my binary log files being logged at ‘/var/lib/mysql/’ and it is occupying almost ‘110 GB’ of web space.

I need to know, Can i go ahead and clear this off ? Or

What is the right way to clear this and will it have any impact on the server ?

I read on the internet, It does help in performance enhancements, But i need a second view.

Secondly,when i run the command :- “show variables like ‘%home%’”

mysql\> show variables like ‘%home%’;±--------------------------±------+| Variable\_name | Value |±--------------------------±------+| innodb\_data\_home\_dir | || innodb\_log\_group\_home\_dir | ./ |±--------------------------±------+2 rows in set (0.00 sec)

I do not see the location for the binary file mentioned in there :(, What does this mean ?

Can any one on board address both my queries ?

Thank you,

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [March 7, 2013, 6:22am UTC](https://forums.percona.com/t/clean-up-binary-log-files/2011/2 "2013-03-07T06:22:57Z")

</div>

see [http://dev.mysql.com/doc/refman/5.5/en/log-file-maintenance](http://dev.mysql.com/doc/refman/5.5/en/log-file-maintenance). html

---

<div class="post-metadata">

**Author:** ![systemali](https://avatars.discourse-cdn.com/v4/letter/s/b9bd4f/32.png) [@systemali](https://forums.percona.com/u/systemali)\
**Post date:** [March 7, 2013, 9:50pm UTC](https://forums.percona.com/t/clean-up-binary-log-files/2011/3 "2013-03-07T21:50:53Z")

</div>

gmouse,

Thank you for the link, But i am still confused ☹

With regards to logs, This is what i have in my my.cnf file :

log-bin=newcrmdb1-bin#binlog\_do\_db=crmdbbinlog\_do\_db=newcrmdbbinlog-ignore-db=mysql,test#log-slave-updatesinnodb\_flush\_log\_at\_trx\_commit=0sync\_binlog=0back\_log = 75innodb\_log\_file\_size = 1G#log-slow-queries = /var/log/mysql-slow-query.log

The files in my /var/lib/mysql folder are all by the name of “newcrmdb1-bin”

I am not sure what to do, Please advice !!

Thank you once again.

---

<div class="post-metadata">

**Author:** ![Champion1](https://avatars.discourse-cdn.com/v4/letter/c/dec6dc/32.png) [@Champion1](https://forums.percona.com/u/Champion1)\
**Post date:** [April 7, 2016, 12:50am UTC](https://forums.percona.com/t/clean-up-binary-log-files/2011/4 "2016-04-07T00:50:30Z")

</div>

=== [URL][15 Best Solitaire Apps for Android and iOS](http://www.solitairechamp.info/%5B/URL%5D) ===

---

<div class="post-metadata">

**Author:** ![Timur\_Solodovnikov](https://avatars.discourse-cdn.com/v4/letter/t/9dc877/32.png) [@Timur\_Solodovnikov](https://forums.percona.com/u/Timur_Solodovnikov)\
**Post date:** [April 19, 2016, 4:27am UTC](https://forums.percona.com/t/clean-up-binary-log-files/2011/5 "2016-04-19T04:27:26Z")

</div>

> [@Champion1;44030](#):
>
> == [www.solitairechamp.biz](http://www.solitairechamp.biz/) ==

Better not to do that way.

Please try to rotate logs by command below:  
set global expire\_log\_days=10;  
flush logs;