Huge files being created

[ComputrGrl]

I recently had a problem with my OS Commerce store -- I exceeded my disk space quota at my host because 'my-username-bin.001, my-username-bin.002, my-username-bin.003, my-username-bin.004', etc. files were being created by my OS Commerce store in my SQL directory ....... they are huge files and I am wondering if I can delete them?

 

Has anyone else had these problems or files?

[Guest]

Hi,

 

What are in the files?

 

Are you sure these are not saved files by the server?

[ComputrGrl]

the file contains tons of the same requested information, see below for a short example of the same repeated lines of code found in the files:

 

3.23.58-log

 

insert into whos_online --- then a bunch of code and characters

insert into sessions values --- then a bunch of code and characters

update sessions set expiry --- then a bunch of code and characters

delete from whos_online where time_last_click

[Guest]

Is it from the log on the server?

 

If so, contact your host company and ask them to stop duplicating the log files.

[ComputrGrl]

I don't think this is a log file from the server, it is generated my OS Commerce, do you have them on your site?

 

Thanks

[bluepony]

Those files are MYSQL binary update logs. They are used for crash recovery (point in time recovery).

 

They aren't on by default, someone had to enable them for them to show up. For more info: http://www.mysql.com/doc/en/Binary_log.html

 

To safely remove them you can issue a MYSQL command like:

PURGE MASTER LOGS TO 'my-username-bin.004';