[rt-users] Re: CachedGroupMembers table size

[Ruslan Zakirov]

On 5/18/06, Alexey G Misyurenko <mag at caravan.ru> wrote:
> Ruslan Zakirov wrote:
> > Yep, it's normal. I have code branch where I experiment with ideas on
> > how to get rid of some useless groups.
> >
>
> Is any documents on the NET where I can read how to optimize  (compact)
> information on this tables or delete some information without risk?
You can use RTx::Shredder to delete tickets and other objects from RT.
I think you couldn't just delete those groups even with shredder as RT
now relies on them.

>
> I ask because we have I big speed degradation.
> $RT::Handle->BeginTransaction() from SetOwner from Ticket_Overlay.pm
> take about 200 second to run.
>
> DB & Apache allreade run on different servers.
>
>
>
> > On 5/18/06, Alexey G Misyurenko <mag at caravan.ru> wrote:
> >> Alexey G Misyurenko wrote:
> >> > Hello!
> >> >
> >> > Is it normal that CachedGroupMembers table contain about 4'500'000
> >> records?
> >> >
> >>
> >> Also is it normal that table Group & Principal contain 2'000'000 records
> >> (each one)?
> >>
> >> And is it normal that table Group containe record's
> >> where field Name is like 'User {digits}'?
> >>
> >>
> >> > rt:    3.4.4
> >> > about: 500'000 tickets
> >> > DB:    Oracle
> >> >
> >>
> >>
> >> --
> >> WBR,   Alexey G Misyurenko ( MAG-RIPE | MMAGG-RIPN )
> >> CTO of Caravan ISP            http://www.caravan.ru
> >> Phone: +7 495 3632252         Cell:  +7 495 5082794
> >> _______________________________________________
> >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >>
> >> Community help: http://wiki.bestpractical.com
> >> Commercial support: sales at bestpractical.com
> >>
> >>
> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> >> Buy a copy at http://rtbook.bestpractical.com
> >>
> >>
> >> We're hiring! Come hack Perl for Best Practical:
> >> http://bestpractical.com/about/jobs.html
> >>
> >
> >
>
>
> --
> WBR,   Alexey G Misyurenko ( MAG-RIPE | MMAGG-RIPN )
> CTO of Caravan ISP            http://www.caravan.ru
> Phone: +7 495 3632252         Cell:  +7 495 5082794
>


-- 
Best regards, Ruslan.