[rt-users] Indicies to add to RT3

[Aaron Turner]

First, let me say I haven't tweeked my RT indexes at all (v2 or v3).  I
haven't even once looked into it.  I however have had very good luck 
using MySQL's EXPLAIN command to tune the indexes for other DB's.  
You'll also want to read the MySQL docs on the subject:

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Query_Speed

What I do is tail the mysqld.log file and find out which queries are
taking a long time, and then run them through EXPLAIN and then tweak the
indexes accordingly.  When you do your part and assuming the queries are
well written you can get a really nice boost.  Note that logical OR's 
are performance killers with MySQL since they're completely
non-optimized, you're far better off using:
AND [NOT] IN (really long list of primary keys)

Wether RT uses OR's or not I have no clue, but figured I'd point that
out.

Hope that helps.

On Wed, Aug 06, 2003 at 12:45:28PM -0700, Matt Simonsen wrote:
> On Tue, 2003-08-05 at 13:52, Matt Simonsen wrote:
> > I'm hoping some people will share the indexes they've added to make
> > their install of RT3 run faster.
> 
> Hmmm. No response.
> 
> So, either:
> 
> #1: This is a dumb/bad question. If so, please somebody at least tell me
> why. I don't think this is the case, there's a few posts about indexes
> for RT2, many saying for better speed in RT3 to optimize indexes. There
> are, unfortunately, very few follow-up responses from from list members
> saying what they did to fix the problem or posts from helpers on exactly
> what they've done to tune their systems. I think both would be helpful.
> 
> #2. There are no other indexes other than the one I've mentioned which
> would be helpful, thus no answers.
> 
> #3: People don't want to share? I'd hate to believe this is the case.
> Not when Jesse has so freely given his work to the community.
> 
> #4: People don't think their indexes are helpful for others and don't
> want to pollute the list. I believe they would be -- there's a lot of
> people using RT, probably most of them searching the archives and on
> this list. I'd suspect many would like better performance and would have
> a need for the indexes others have created.
> 
> Really, if you have indexes that greatly helped system performace,
> please at least email them to me off list -- I'd be happy to verify that
> it helps and compile a list to be posted to the list.
> 
> Matt
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 244 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030806/33a88b0d/attachment.sig>