[Gmod-help] bp_seqfeature_load.pl and mysql storage space used
Matthew Conte
mconte at umd.edu
Mon Aug 10 12:10:53 EDT 2009
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://brie4.cshl.edu/pipermail/gmod-help/attachments/20090810/1719e219/attachment.html>
More information about the Gmod-help
mailing list