0015801: DATABASE SIZE INCREASE DRAMATICALLY

ID	Project	Category	View Status	Date Submitted	Last Update
0015801	mantisbt	db mysql	public	2013-05-01 01:31	2013-05-27 16:40

Reporter	faris	Assigned To	dregad
Priority	urgent	Severity	major	Reproducibility	sometimes
Status	closed	Resolution	no change required
Product Version	1.2.12

Summary	0015801: DATABASE SIZE INCREASE DRAMATICALLY
Description	i am using mantis for last four year and recently i have upgraded to the latest release 1.2.12. My mantis is hosted on a third party domain freehostia where i have to purchase database size. currenlty i have purchased 220mb of database size where as my actual databasee size is 196mb. there is one table named mantis_bug_file_table, the size of this table is around 180mb. when i attach a file to any bug report db size increases from 196 mb to 319mb. this increase in size in not understandable. can you please help that why mantis is behaving like this for past three months.
Tags	No tags attached.

dregad 2013-05-01 05:09 developer ~0036751	This table stores the attachments (as BLOBs). How big is the file you're trying to attach ? If it's a small file, I have no idea what could cause MySQL to increase table size by such a large amount. Maybe you should seek help on MySQL support sites rather than here. To reduce DB size, you may want to consider storing the attachments to disk instead of in the DB (set $g_file_upload_method = DISK) then move your attachments

atrol 2013-05-15 09:29 developer ~0036862	faris, You did not provide any feedback; I am therefore resolving this issue as "no change required". Feel free to reopen the issue at a later time and provide the requested information.