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
