Re: How to reduce mantis_bug_file_table size?

Thanks Roland !


2013/9/13 Roland Becker <[email protected]>

> http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
>
> http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-mysql
>
> > Jorge Fonseca <[email protected]> hat am 13. September 2013 um 22:12
> > geschrieben:
> >
> >
> > Hi All,
> >
> > Good afternoon !!!
> >
> > I have a big mantis database where *mantis_bug_file_table *reaches 4GB
> > (around 3400 records).
> > I am migrating attachments to DISK, in order to improve performance and
> > avoid bugs with database size.
> >
> > After:
> >  - use admin/Move Attachments to Disk functionality.
> >
> > Even files were moved correctly, the file *mantis_bug_file_table *remains
> > its original size.
> >
> >
> > So, i try to delete some project in a test environment:
> >  - Even projects were deleted correctly, the file
> > *mantis_bug_file_table *remains
> > its original size.
> >
> > ------------
> >
> > I searched for something to "purge" deleted records but with no success.
> > *Please, let me know how i can reduce table/file size definitely? *
> >
> > ------------
> >
> > Regards,
> > Jorge.
> >
> ------------------------------------------------------------------------------
> > How ServiceNow helps IT people transform IT departments:
> > 1. Consolidate legacy IT systems to a single system of record for IT
> > 2. Standardize and globalize service processes across IT
> > 3. Implement zero-touch automation to replace manual, redundant tasks
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk_______________________________________________
> > mantisbt-help mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/mantisbt-help
>

------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk

_______________________________________________
mantisbt-help mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mantisbt-help