Thanks Roland !
2013/9/13 Roland Becker <rol...@atrol.de>
> 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 <jcbfons...@gmail.com> 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
> > mantisbt-help@lists.sourceforge.net
> > 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
mantisbt-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mantisbt-help
