My RT with #500000

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all

This is only report email.

On Czech On Line RT is #500000 ticket’s. We are use RT 2.0.15 with COL
patch on 3 FreeBSD machines.

rt.vol.cz
apache
sendmail

rtdb.hide.vol.cz
mysql repli master

replirtdb.hide.vol.cz
mysql repli slave

Have nice day :slight_smile:


malyl
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (FreeBSD)
Comment: Made with pgp4pine 1.76

iD8DBQFCXTnxsB/XvLG2RNIRArRmAJ0fFgWGPfblayfk/NVhU4y/ySCpXQCg5aSD
PD3sRJgTHj63h3s5fa9wRuU=
=ADjy
-----END PGP SIGNATURE-----

Man… talk about buggy software ;-)On Wed, Apr 13, 2005 at 05:25:29PM +0200, Lukas Maly wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all

This is only report email.

On Czech On Line RT is #500000 ticket’s. We are use RT 2.0.15 with COL
patch on 3 FreeBSD machines.

rt.vol.cz
apache
sendmail

rtdb.hide.vol.cz
mysql repli master

replirtdb.hide.vol.cz
mysql repli slave

Have nice day :slight_smile:


malyl
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (FreeBSD)
Comment: Made with pgp4pine 1.76

iD8DBQFCXTnxsB/XvLG2RNIRArRmAJ0fFgWGPfblayfk/NVhU4y/ySCpXQCg5aSD
PD3sRJgTHj63h3s5fa9wRuU=
=ADjy
-----END PGP SIGNATURE-----


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

 www.suave.net - Anthony Ball - ant@suave.net
    OSB - http://rivendell.suave.net/Beer

Sects, Sects, Sects! Is that ALL you monks ever think about?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

++ 13/04/05 17:25 +0200 - Lukas Maly:

On Czech On Line RT is #500000 ticket’s. We are use RT 2.0.15 with COL
patch on 3 FreeBSD machines.

What exactly is the “COL patch”? URL or other information?


Rejo Zenger rejo@rz.xs4all.nl - http://rejo.zenger.nl - PGP 0x75FC50F3
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFCXZU9Ha9Q5nX8UPMRAk5JAKDfUX6aA4kVBoXrRTugs8SONgAo8ACfYTgv
SFr34U60mpDY3JMIjig2EaE=
=RLpa
-----END PGP SIGNATURE-----

Date: Wed, 13 Apr 2005 23:55:09 +0200
From: Rejo Zenger subs-rt.users.bestpractical.com@rz.xs4all.nl
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] My RT with #500000

++ 13/04/05 17:25 +0200 - Lukas Maly:

On Czech On Line RT is #500000 ticket’s. We are use RT 2.0.15 with COL
patch on 3 FreeBSD machines.

What exactly is the “COL patch”? URL or other information?

This is patch which contain code for Czech On Line, integration with COL
IS.

malyl

Lukas Maly wrote:>On Wed, 13 Apr 2005, Rejo Zenger wrote:

Date: Wed, 13 Apr 2005 23:55:09 +0200
From: Rejo Zenger subs-rt.users.bestpractical.com@rz.xs4all.nl
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] My RT with #500000

++ 13/04/05 17:25 +0200 - Lukas Maly:

On Czech On Line RT is #500000 ticket’s. We are use RT 2.0.15 with COL
patch on 3 FreeBSD machines.

What exactly is the “COL patch”? URL or other information?

This is patch which contain code for Czech On Line, integration with COL
IS.

Do you keep all 500k tickets in the database?

Rainer

Do you keep all 500k tickets in the database?

Rainer

No :frowning: Every month i run archive script, which get 1 years old tickets
from db (Table Attachments is too big) and make static html.

malyl

Arh. I remember we when hit 500k tickets, oh so long ago. :slight_smile:

select count() from tickets
COUNT(
)
1068891
1 row selected

select max(id) from tickets
MAX(ID)
1331311
1 row selected

Regards,
Matt.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-
bounces@lists.bestpractical.com] On Behalf Of Lukas Maly
Sent: Thursday, April 14, 2005 4:26 PM
To: Rainer Duffner
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] My RT with #500000

Do you keep all 500k tickets in the database?

Rainer

No :frowning: Every month i run archive script, which get 1 years old tickets
from db (Table Attachments is too big) and make static html.

malyl


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact
training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

This email and any files transmitted with it are confidential and intended solely for the
use of the individual or entity to whom they are addressed. Please notify the sender
immediately by email if you have received this email by mistake and delete this email
from your system. Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for the presence of
viruses. The organisation accepts no liability for any damage caused by any virus
transmitted by this email.

Arh. I remember we when hit 500k tickets, oh so long ago. :slight_smile:

Which DB, Pg, or MySQL? And RT Version? (Yup, veeery curious)

My biggest RT right now is 3.0.10, hitting the 21k ‘landmark’ very small
indeed…

No :frowning: Every month i run archive script, which get 1 years old tickets
from db (Table Attachments is too big) and make static html.

malyl

Interesting, publicly available script? Or soemthing you wrote internally?

No :frowning: Every month i run archive script, which get 1 years old tickets
from db (Table Attachments is too big) and make static html.

malyl

Interesting, publicly available script? Or soemthing you wrote internally?

Yes script is publicly available. But you musi make small change. But
RT::Col isn’t public.

malyl

rt-archive.pl (15.2 KB)

Oracle 9i and RT 3.2.2 (hoping to update to 3.4.x soon)

-----Original Message-----
From: Michael Loftis [mailto:mloftis@wgops.com]
Sent: Thursday, April 14, 2005 7:22 PM
To: Matthew Watson; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] My RT with #500000

Arh. I remember we when hit 500k tickets, oh so long ago. :slight_smile:

Which DB, Pg, or MySQL? And RT Version? (Yup, veeery curious)

My biggest RT right now is 3.0.10, hitting the 21k ‘landmark’ very
small
indeed…

This email and any files transmitted with it are confidential and intended solely for the
use of the individual or entity to whom they are addressed. Please notify the sender
immediately by email if you have received this email by mistake and delete this email
from your system. Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for the presence of
viruses. The organisation accepts no liability for any damage caused by any virus
transmitted by this email.

Oracle 9i and RT 3.2.2 (hoping to update to 3.4.x soon)

Wow, interesting, 9i on Linux I assume? Last time I’d tried Oracle on
Linux was quite a while ago, possibly back in the first i releases, it was
a real ahem…experience :slight_smile: I know it’s gotten better, I haven’t installed
it for production recently but had a 9i and a 10i testing system setup.
Seemed a lot better.

I’d like to be able to use Oracle for a number of internal applications
where I’m working… MySQLs lack of anything resembling PL/SQL and real
JOINs as well as triggers is starting to get old. Not my choice though, I
just run things, not develop them :slight_smile:

Anyway, thanks for letting me pick your brain a bit.

We’re running 3.0.10, and I’m considering going to 3.4.x here soon as well.
I’ve got a hardware upgrade on deck for the RT platform (part of splitting
it’s services out) so it’d be a good time to just chew it all off at once.

Thanks again,

Michael Loftis

Oracle 9i and RT 3.2.2 (hoping to update to 3.4.x soon)

Wow, interesting, 9i on Linux I assume?

Narh on a Sun box, cant remember exactly what it is.

I’d like to be able to use Oracle for a number of internal
applications
where I’m working… MySQLs lack of anything resembling PL/SQL and
real
JOINs as well as triggers is starting to get old. Not my choice
though, I
just run things, not develop them :slight_smile:

Yeh, found oracle a lot easier to tune for those trickier queries, we
used to run RT 2.0.11 ( from memory ) on mysql 4 and found some things
that we just could get to use the indexes.

Regards,
Matt.

This email and any files transmitted with it are confidential and intended solely for the
use of the individual or entity to whom they are addressed. Please notify the sender
immediately by email if you have received this email by mistake and delete this email
from your system. Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for the presence of
viruses. The organisation accepts no liability for any damage caused by any virus
transmitted by this email.

Hello!On Thu, 2005-04-14 at 02:57, Matthew Watson wrote:

Arh. I remember we when hit 500k tickets, oh so long ago. :slight_smile:

select count() from tickets
COUNT(
)

1068891
1 row selected

select max(id) from tickets
MAX(ID)

1331311
1 row selected

Out of curiosity … what’s this return?

select count(*) from transactions;

I’d also love to hear about what you’ve done to optimize RT for Oracle
(and vice versa). We’re looking hard at RT and want to address some
concerns we see (or at least thought we saw) with scaling to 300000+
tickets.

Thanks!

–j
Jim Meyer, Geek at Large purp@acm.org

select count() from transactions
COUNT(
)
2907917
1 row selected

Optimising… we pulled a few things out of the UI (such as other tickets
by a user on the display ticket page).
Quite a few new index and I believe our dba had to tweak some oracle
settings to get the correct indexes to be used, not exactly sure what
that was though I’m afraid.

We also threw a reasonably amount of hardware at the problem. Our
testing showed that on the dual AMD Opteron systems we use as a front
end, when you start getting more than 5-10 simultaneous (which is quite
a lot in this type of environment) performance started to drop of
rapidly. The mason front end (and the perl API) seem quite heavy. So
currently we have 2 dual AMD Opterons running the web/email gateways and
our Sun/Oracle server as the data store (this also does other things).
Seems to be running quite smoothly, haven’t had any complaints about
"lockups" since moving to RT3, something which happened quite often when
we ran mysql4/rt2, this I think is largely due to oracles better ability
to handle large/crazy queries.

Regards,
Matt.

-----Original Message-----
From: Jim Meyer [mailto:purp@acm.org]
Sent: Tuesday, April 19, 2005 2:08 AM
To: Matthew Watson
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] My RT with #500000

Hello!

Arh. I remember we when hit 500k tickets, oh so long ago. :slight_smile:

select count() from tickets
COUNT(
)

1068891
1 row selected

select max(id) from tickets
MAX(ID)

1331311
1 row selected

Out of curiosity … what’s this return?

select count(*) from transactions;

I’d also love to hear about what you’ve done to optimize RT for Oracle
(and vice versa). We’re looking hard at RT and want to address some
concerns we see (or at least thought we saw) with scaling to 300000+
tickets.

Thanks!

–j

Jim Meyer, Geek at Large
purp@acm.org

This email and any files transmitted with it are confidential and intended solely for the
use of the individual or entity to whom they are addressed. Please notify the sender
immediately by email if you have received this email by mistake and delete this email
from your system. Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for the presence of
viruses. The organisation accepts no liability for any damage caused by any virus
transmitted by this email.