Clean up binary log files

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,

see html


Thank you for the link, But i am still confused :frowning:

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.

=== ===

Better not to do that way.

Please try to rotate logs by command below:
set global expire_log_days=10;
flush logs;