Create Attachments on the local filesystem
bugreport at peshkin.net
Wed Oct 22 13:08:45 UTC 2003
I very often need to attach files that cannot be compressed to less than
150MB to a bug. Regardless of how these are stored, the fact that we
cannot do this today is a problem. What we need is a solution that....
1) Permits attachments of sizes limited only by site policy.
2) Permits large attachments to have a retention date after which the
space can be recovered.
3) Does not store the entire attachment in memory while working with it.
4) I don't care if I cannot search the attachment contents if the
attachment is > 16MB. I never need to do that.
Implementing this is a completely seperate matter. Perhaps the right
thing to do is to ....
a) add a mechanism to permit large attachments to span many database
b) permit a retention policy to be used for large attachments (e.g.
Delete if obsolete > 6 months and size > 10MB and undownloaded > 6
months and bug unchanged > 6 months)
Does MySQL automatically recover space after deletions or does some
maintainance function have to be called?
More information about the developers