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
The rt-users Archives
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: