homepage Welcome to WebmasterWorld Guest from 54.211.73.232
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
mysqld .bin files
glimbeek



 
Msg#: 4083444 posted 1:21 pm on Feb 19, 2010 (gmt 0)

The .bin files on my server are getting to large and they crash my mysql server at times.

This is obviously not something I want happening.

Now I can create a cronjob that removes the bin files at set intervals OR I can disable bin "logging" all together.

Before I do either of those two, I was wondering what use is a .bin file and what effect will the above two option have?

Can I remove .bin files whenever I feel like it? What do I miss/what happens if I disable .bin logging completely?

 

Demaestro

WebmasterWorld Senior Member demaestro us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4083444 posted 3:21 pm on Feb 19, 2010 (gmt 0)

Well I can't speak to the consequences of not having the bin logging but you can delete them without losing data.

If you issue these commands at certain intervals you can get rid of them, or as you mentioned you can turn of bin logging.

mysql> flush logs;

mysql> reset master;

You can view the contents of the bin files by using mysqlbinlog and piping the output to a txt file

sudo mysqlbinlog /var/lib/mysql/mysqld-bin.000001 > log.txt

mack

WebmasterWorld Administrator mack us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4083444 posted 4:34 pm on Feb 19, 2010 (gmt 0)

are .bin files not in some way related to replication? I have had issues in the past with very large bin files and removed them with no issue.

Mack.

Demaestro

WebmasterWorld Senior Member demaestro us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4083444 posted 6:07 pm on Feb 19, 2010 (gmt 0)

I am going by memory here but I think that the bin files also have a log of transactions but I may be wrong on that.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved