SQL to delete an entire store?

dormando dormando at rydia.net
Thu Mar 20 23:38:57 UTC 2008

Sounds scary.

We should probably cook up an interface for doing bulk deletes/re
replicates/checks via the tracker, somewhat safely.

Yes, on some level I believe it would work if you selected the fids into
file_to_delete. It could still take a while, but you could also add a
few extra delete jobs.

I'd be paranoid enough to stop the trackers while doing the bulk load
into file_to_delete... Not sure offhand if doing a delete through a
tracker ensures you're not doing anything awful if a fid is locked by
another process.


Clinton Goudie-Nice wrote:
> I'm looking for some quick sql to delete the entire list of files in my
> mogile store. Can I just do a select into files_to_delete from file?
> In my bulk testing, I often fill up the store with garbage, and I'd
> rather tear it down this way than have to issue all the delete commands
> through the tracker; through the tracker it just takes too long.
> Thanks!
> Clint
> Twelve Horses <http://web.twelvehorses.com/> 	Mobile
> <http://web.twelvehorses.com/info_center/whitepaper/> 	Social
> <http://web.twelvehorses.com/solutions/blogging_for_business/> 	Web
> <http://web.twelvehorses.com/solutions/website_design/> 	Email
> <http://web.twelvehorses.com/technology/>
> *Clinton Goudie-Nice*
> Architect / Senior Software Engineer
> cgoudie at twelvehorses.com <mailto:cgoudie at twelvehorses.com>
> Phone: 	+1.801.571.2665 ext 3264
> Mobile: 	+1.801.915.0629
> Fax: 	+1.801.571.2669
> LinkedIn: 	http://www.linkedin.com/in/cgoudie
> *Twelve Horses*
> 13961 Minuteman Drive
> Suite 125
> Draper, UT 84020
> *www.twelvehorses.com <http://www.twelvehorses.com>*

More information about the mogilefs mailing list