Re: [rt-users] Shrink CGM Table option?

2008-07-30 Thread Curtis Bruneau
I just tried the mentioned patch, it works much nicer, it uses around 165-220mb. Curtis. Ruslan Zakirov wrote: Try attached patch. On Tue, Jul 29, 2008 at 5:50 PM, Curtis Bruneau [EMAIL PROTECTED] wrote: Is there any way to get etc/upgrade/shrink_cgm_table.pl to do it's thing in

[rt-users] Shrink CGM Table option?

2008-07-29 Thread Curtis Bruneau
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

Re: [rt-users] Shrink CGM Table option?

2008-07-29 Thread Ruslan Zakirov
Try attached patch. On Tue, Jul 29, 2008 at 5:50 PM, Curtis Bruneau [EMAIL PROTECTED] 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