[rt-users] RT3 is very slow (Tom?? Hur?n)

Thu Mar 18 08:07:07 EST 2004

Hi Tom,

we had the same problem a month ago. We have fixed it by tuning the perl
environment. we had switched from mod_perl to fastCGI. Open a lot of Fastcgi
Prozesses for the lot of users (we have 1 process for 50 users)

We had decreased the time for the steps down to < 2sek for a normal work
process

Our Environment:

6000 User
45000 Tickets
Dual Xeon 2400
2 GB RAM

APACHE 2
Perl 5.8.x
FastCGI
MySQL 4 (innodb)

Hope this helps you, btw. you can contact me directly, i will give you our
configuration

Message: 8
Date: Thu, 18 Mar 2004 09:56:51 +0100
From: Tom?? Hur?n <thuryn at aplis.cz>
Subject: [rt-users] RT3 is very slow
To: rt-users at lists.bestpractical.com
Message-ID: <200403180956.52029.thuryn at aplis.cz>
Content-Type: text/plain;  charset="iso-8859-2"

Hallo,
  we've a machine with RT3, about 300 tickets and 50 users and RT is very
slow. Ticket, that have meny attachemets and comments, is displaying 2:45
min
on dual PII 350 MHz. But overal system is very slow, not only big tickets.
  If I move RT3 on Duron 1,8 GHz, 1 GB RAM, the same ticket is displaying 45
sec. - it's no good result.

  Does everyone the same experience? Is it possible to speedup system,
because
this is unusable speed.

Thanks

--
Tomas Huryn

------------------------------

Message: 9
Date: Thu, 18 Mar 2004 11:24:58 +0100
From: Harald Wagener <hwagener at hamburg.fcb.com>
Subject: Re: [rt-users] RT3 is very slow
To: 'rt-users at lists.fsck.com' <rt-users at lists.fsck.com>
Message-ID: <81EF6644-78C6-11D8-B540-003065DC18B8 at hamburg.fcb.com>
Content-Type: text/plain; charset=WINDOWS-1252; format=flowed

Am 18.03.2004 um 09:56 schrieb Toma Hur}n:

> Hallo,
>   we've a machine with RT3, about 300 tickets and 50 users and RT is
> very
> slow. Ticket, that have meny attachemets and comments, is displaying
> 2:45 min
> on dual PII 350 MHz. But overal system is very slow, not only big
> tickets.
>   If I move RT3 on Duron 1,8 GHz, 1 GB RAM, the same ticket is
> displaying 45
> sec. - it's no good result.
>

You need to tell us which versions of rt, perl You use.
You need to tell us which database You use (and which version).

Then we can try helping You.

Recommmended is

RT 3.0.9 (latest)
perl 5.8.3 (latest)
MySQL 4.0.18 (latest) with innodb type tables

A lot of speed can be gained by tuning MySQL.

Regards,
     Harald

------------------------------

Message: 10
Date: Thu, 18 Mar 2004 12:05:28 +0100
From: Tom?? Hur?n <thuryn at aplis.cz>
Subject: Re: [rt-users] RT3 is very slow
To: rt-users at lists.bestpractical.com
Message-ID: <200403181205.28941.thuryn at aplis.cz>
Content-Type: text/plain;  charset="iso-8859-2"

OK, we have all versions described below, that is:

RT 3.0.9 (latest)
perl 5.8.3 (latest)
MySQL 4.0.18 (latest) with innodb type tables

Dne ht 18. bxezna 2004 11:24 Harald Wagener napsal(a):
> Am 18.03.2004 um 09:56 schrieb Toma9 Hur}n:
> > Hallo,
> >   we've a machine with RT3, about 300 tickets and 50 users and RT is
> > very
> > slow. Ticket, that have meny attachemets and comments, is displaying
> > 2:45 min
> > on dual PII 350 MHz. But overal system is very slow, not only big
> > tickets.
> >   If I move RT3 on Duron 1,8 GHz, 1 GB RAM, the same ticket is
> > displaying 45
> > sec. - it's no good result.
>
> You need to tell us which versions of rt, perl You use.
> You need to tell us which database You use (and which version).
>
> Then we can try helping You.
>
> Recommmended is
>
> RT 3.0.9 (latest)
> perl 5.8.3 (latest)
> MySQL 4.0.18 (latest) with innodb type tables
>
> A lot of speed can be gained by tuning MySQL.
>
>
> Regards,
>      Harald
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

--
Toma9 Hur}n

------------------------------

Message: 11
Date: Thu, 18 Mar 2004 12:24:37 +0100
From: Harald Wagener <hwagener at hamburg.fcb.com>
Subject: Re: [rt-users] RT3 is very slow
To: 'rt-users at lists.fsck.com' <rt-users at lists.fsck.com>
Message-ID: <D7245951-78CE-11D8-B540-003065DC18B8 at hamburg.fcb.com>
Content-Type: text/plain; charset=WINDOWS-1252; format=flowed

Am 18.03.2004 um 12:05 schrieb Toma Hur}n:

> OK, we have all versions described below, that is:
>
> RT 3.0.9 (latest)
> perl 5.8.3 (latest)
> MySQL 4.0.18 (latest) with innodb type tables
>

Did You tune the innodb settings for MySQL according to
http://www.innodb.com/ibman.php, especially
http://www.innodb.com/ibman.php#InnoDB.tuning ? That helped alot here -
in our experience, having 1 Gig of RAM in Your machine is a bit
pointless if the database does not use it...

Regards,
     Harald

------------------------------

Message: 12
Date: Thu, 18 Mar 2004 13:29:10 +0100
From: Tom?? Hur?n <thuryn at aplis.cz>
Subject: Re: [rt-users] RT3 is very slow
To: rt-users at lists.bestpractical.com
Message-ID: <200403181329.10134.thuryn at aplis.cz>
Content-Type: text/plain;  charset="iso-8859-2"

OK, but perl always is at 100 % CPU, not mysql. I understand that the
problem
can be in mysql, but the question is any tuning of database will lead to the
solution.

Dne ht 18. bxezna 2004 12:24 Harald Wagener napsal(a):
> Am 18.03.2004 um 12:05 schrieb Toma9 Hur}n:
> > OK, we have all versions described below, that is:
> >
> > RT 3.0.9 (latest)
> > perl 5.8.3 (latest)
> > MySQL 4.0.18 (latest) with innodb type tables
>
> Did You tune the innodb settings for MySQL according to
> http://www.innodb.com/ibman.php, especially
> http://www.innodb.com/ibman.php#InnoDB.tuning ? That helped alot here -
> in our experience, having 1 Gig of RAM in Your machine is a bit
> pointless if the database does not use it...
>
> Regards,
>      Harald
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

--
Toma9 Hur}n

------------------------------

_______________________________________________
rt-users mailing list
rt-users at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

End of rt-users Digest, Vol 5, Issue 66
***************************************