[rt-devel] Bencemark

[Iqbal, Asif]

Hi Jesse and all

Is there a benchmark on how well rt3 w/ apache+mod_perl + mysql 4 ( same
versions as requested in the the rt3 installation doc ) will do with 500
users using it at the same time and the database already have 150 thousands
tickets. Some rule of thumb will do if there is no exact mesurement

Thanks

--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1
- - Internal Use Only - Disclose and Distribute only to Qwest Employees and
authorized persons working for Qwest. Disclosure outside of Qwest is
prohibited without authorization.



> -----Original Message-----
> From: Jesse Vincent [mailto:jesse at bestpractical.com] 
> Sent: Thursday, June 26, 2003 2:41 PM
> To: John Stoffel
> Cc: Harald Wagener; Audley, Christopher; rt-devel at lists.fsck.com
> Subject: Re: [rt-devel] Users::WhoHaveRight and Sybase and 
> Sudden MySQL slowness
> 
> 
> 
> 
> 
> On Thu, Jun 26, 2003 at 02:37:38PM -0400, John Stoffel wrote:
> > 
> > Harald> This seems to help me with my MySQL slowness very 
> much. Query 
> > Harald> time is down to sub second values again.
> > 
> > Harald> One problem with my setup might be that I upgraded 
> from RT 2 
> > Harald> with an old version of the import tool (about 6 to 8 weeks
> > Harald> ago) and some db weirdness might come from that. Is 
> > Harald> CachedGroupMembers supposed to have around 40,000 rows with 
> > Harald> only 4700 tickets, 200 requestors without special 
> rights and 
> > Harald> less than 10 privileged users?
> > 
> > To me, it sounds like this cache is never expiring old 
> data, which is 
> > what a cache should do!  Or the design of the ACL stuff isn't done 
> > right here...
> 
> Nope. This Cache is Caching recursive group membership, which 
> would otherwise hurt REALLY badly (O(n) SQL queries just as 
> bad as the current query per acl question)
> 
> > 
> > Ok, I'll shutup and sit back and watch the discussion again, 
> > interesting stuff though!
> > 
> > John
> > 
> 
> -- 
> http://www.bestpractical.com/rt  -- Trouble Ticketing. Free. 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com 
> http://lists.fsck.com/mailman/listinfo/rt-> devel
>