Mysql performance - recommended indicies?

Running rt3.0.5, mysql 4.0.14. NOC is starting to see updates taking longer
than before (10 seconds sometimes).

I’m running with a mostly untweaked copy of my-large.cnf on a box with 1GB
RAM and 2 CPUs.

Are there some indices I can add to speed things up or settings in my.cnf
that would help?

matthew zeier | “Nothing in life is to be feared.
InteleNet Communications, Inc. | It is only to be understood.”
(949) 784-7904 | - Marie Curie

Running rt3.0.5, mysql 4.0.14. NOC is starting to see updates taking longer
than before (10 seconds sometimes).

It’s helpful to turn on mysql logging and slow query logging and see
which queries are taking a long time, assuming it’s database side lag
and not perl-side lag. Once you know which queries are killing you, it’s
much easier to tune.

It’s also worth making sure that if you’re running with Sendmail brand
sendmail, you’re doing background delivery, rather than actually waiting
for mail to be delivered before returning a page.

-j

I’m running with a mostly untweaked copy of my-large.cnf on a box with 1GB
RAM and 2 CPUs.

Are there some indices I can add to speed things up or settings in my.cnf
that would help?


matthew zeier | “Nothing in life is to be feared.
InteleNet Communications, Inc. | It is only to be understood.”
(949) 784-7904 | - Marie Curie


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Running rt3.0.5, mysql 4.0.14. NOC is starting to see updates taking
longer
than before (10 seconds sometimes).

It’s helpful to turn on mysql logging and slow query logging and see
which queries are taking a long time, assuming it’s database side lag
and not perl-side lag. Once you know which queries are killing you, it’s
much easier to tune.

It’s also worth making sure that if you’re running with Sendmail brand
sendmail, you’re doing background delivery, rather than actually waiting
for mail to be delivered before returning a page.

Restarted with --log-slow-queries and --log. System is running with
postfix.

I have my server hosted on ssl only https://rt.dept.oakland.edu

I setup my aliases as so:

help: “|/usr/local/rt3/bin/rt-mailgate --queue general --action
correspond --url https://rt.dept.oakland.edu/

however, it continues to fail… when trying to send to that
address… with the following error:

Oct 16 18:06:41 booboo sendmail[45226]: h9FKt8Bp042350:
to=“|/usr/local/rt3/bin/rt-mailgate --queue general --action corres
pond --url http://rt.dept.oakland.edu/”, ctladdr=help@secs.oakland.edu
(26/0), delay=1+01:11:33, xdelay=00:00:01, mailer=
prog, pri=5071012, dsn=4.0.0, stat=Deferred: prog mailer (/bin/sh)
exited with EX_TEMPFAIL

it was working perfectly when I originally set it up over plain http…

thanks for any help…

-jusitn

“JB” == Justin Burdine burdine@oakland.edu writes:

JB> help: “|/usr/local/rt3/bin/rt-mailgate --queue general --action
JB> correspond --url https://rt.dept.oakland.edu/

JB> however, it continues to fail… when trying to send to that
JB> address… with the following error:

can your perl LWP libraries access https urls? ie, when you run the
above command by hand and feed it an email message, what happens?

however, it continues to fail… when trying to send to that
address… with the following error:

Oct 16 18:06:41 booboo sendmail[45226]: h9FKt8Bp042350:
to=“|/usr/local/rt3/bin/rt-mailgate --queue general --action corres
pond --url http://rt.dept.oakland.edu/”, ctladdr=help@secs.oakland.edu
(26/0), delay=1+01:11:33, xdelay=00:00:01, mailer=
prog, pri=5071012, dsn=4.0.0, stat=Deferred: prog mailer (/bin/sh)
exited with EX_TEMPFAIL

it was working perfectly when I originally set it up over plain http…

thanks for any help…

There’s a perl module that rt-mailgate needs in order to speak SSL. I ran
into this problem, installed the module from CPAN, and things started
working again.

Unfortunately, I don’t remember where I found the answer, or which module
it was.

There’s a perl module that rt-mailgate needs in order to speak SSL. I ran
into this problem, installed the module from CPAN, and things started
working again.

Unfortunately, I don’t remember where I found the answer, or which module
it was.

You need the Perl module Crypt::SSLeay (or IO::Socket:SSL), you can find
more information in the RT draft manual on page 33.

/Peter

A restart of apache has done wonders for speed. Running apache 1.3.27 with
mod_perl .From: “matthew zeier” mrz@intelenet.net
To: rt-users@lists.fsck.com
Sent: Thursday, October 16, 2003 2:46 PM
Subject: [rt-users] mysql performance - recommended indicies?

Running rt3.0.5, mysql 4.0.14. NOC is starting to see updates taking
longer
than before (10 seconds sometimes).

I’m running with a mostly untweaked copy of my-large.cnf on a box with 1GB
RAM and 2 CPUs.

Are there some indices I can add to speed things up or settings in my.cnf
that would help?


matthew zeier | “Nothing in life is to be feared.
InteleNet Communications, Inc. | It is only to be understood.”
(949) 784-7904 | - Marie Curie


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

It’s also worth making sure that if you’re running with Sendmail brand
sendmail, you’re doing background delivery, rather than actually waiting

Can I use mailx instead od sendmail, since it by default put mails in the
background ? I am using Solaris 8, rt 3-0-5, perl 5.8.0, modperl1, apache 1.3.27

for mail to be delivered before returning a page.

-j

  • Asif