[Gmod-help] Re: [Gmod-gbrowse] bp_seqfeature_load.pl and mysql storage space used

[Josh Goodman]

You might want to check if you have binary logs enabled.

http://dev.mysql.com/doc/refman/5.1/en/binary-log.html

Josh

Matthew Conte wrote:
> Hello,
> 
> I'm running into some storage space issues after running
> bp_seqfeature_load.pl multiple times and I'm wondering if anyone has run
> into the problem I'm facing or could possible share some insight.
> 
> If I run the following command multiple times:
> bp_seqfeature_load.pl -c -f -d /database-name gff3-file/
> 
> My available disk space decreases by about the size of the gff3-file
> each time.
> 
> If I go into mysql and run:
> drop database /database-name;
> 
> /It only frees disk space by the amount of the gff3-file, even if I've
> run bp_seqfeature_load.pl multiple times.  In other words, if I have a
> 700MB gff3-file and run the bp_seqfeature_load.pl command three times,
> I've lost ~2.1GB of disk space and can only recover 700MB of it.
> 
> I figure this is a mysql setting that is creating some type of backup
> each time I run bp_seqfeature_load.pl, but I haven't been able to figure
> out what the setting is and/or how to turn it off.  Any help is appreciated.
> 
> Thanks,
> Matt
> 
> 
> ------------------------------------------------------------------------
> 
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
> trial. Simplify your report design, integration and deployment - and focus on 
> what you do best, core application coding. Discover what's new with 
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Gmod-gbrowse mailing list
> Gmod-gbrowse at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gmod-gbrowse