Recommendd mysql indices?

Are there suggested table indices other than what RT installs by default,
that I may want to use? The NOC guys are telling me that it’s getting
"slower".

Thanks.

  • mz

matthew zeier - “In mathematics you don’t understand things. You just
get used to them.” - Johann von Neumann

Are there suggested table indices other than what RT installs by default,
that I may want to use? The NOC guys are telling me that it’s getting
"slower".

Thanks.

Thats interesting because I have just started getting some similar
reports from our helpdesk guys, (on occasion and still vary rare) … I
have so far just put it down to someone doing a long nasty complicated
search … but if there are any suggestions on this, would be keen to
hear them.

TIA

Simon.

Are there suggested table indices other than what RT installs
by default,
that I may want to use? The NOC guys are telling me that it’s getting
"slower".

Thanks.

Thats interesting because I have just started getting some similar
reports from our helpdesk guys, (on occasion and still vary rare) … I
have so far just put it down to someone doing a long nasty complicated
search … but if there are any suggestions on this, would be keen to
hear them.

TIA

You are most likely correct there, i’m getting major slow downs (rt locked
up for minutes)
due mainly to locking issues with mysql. mysql locks on the table level,
which is
apparently faster, but can cause alot of issues. I’ve done a few quick tests
and I’m currently of the opinion that pgsql is probably better for RT2 with
a large
database.

Regards,
Mat.

Hi there,

I’m running RT 2.0.7 and want to know if it’s possible to search for tickets based on the “Worked” field (minutes worked) using the standard Web UI (or if it’s in a later release).

Thanks,

Derek…