Shrink CGM Table option?

Is there any way to get etc/upgrade/shrink_cgm_table.pl to do it’s thing
in pieces? I believe we have many rows in the cgm table and it’s causing
perl to take up to 2gb of memory eventually causing oom to invoke
killing mysql or simply just crashing before it can.

Thanks for your time,
Curtis

Try attached patch.On Tue, Jul 29, 2008 at 5:50 PM, Curtis Bruneau curtisb@vianet.ca wrote:

Is there any way to get etc/upgrade/shrink_cgm_table.pl to do it’s thing
in pieces? I believe we have many rows in the cgm table and it’s causing
perl to take up to 2gb of memory eventually causing oom to invoke
killing mysql or simply just crashing before it can.

Thanks for your time,
Curtis


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

RT-3.8.0-less_memory_hungry_shrink_cgm_script.patch (830 Bytes)

I just tried the mentioned patch, it works much nicer, it uses around
165-220mb.

Curtis.

Ruslan Zakirov wrote: