[rt-users] Mysql queries slow

[Foggi, Nicola]

with no real mysql tweaking on RT 3.8.8 I get:

mysql> select count(id) from Attachments;
+-----------+
| count(id) |
+-----------+
|     41636 | 
+-----------+
1 row in set (0.62 sec)

while significantly less that yours, .62 seconds isn't too shabby... 

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com on behalf of William Graboyes
Sent: Wed 7/21/2010 8:19 PM
To: rt-users
Subject: [rt-users] Mysql queries slow
 
Hi List,

As an example of what I  am talking about the query `select count(id) from
Attachments;`  The returned result is 174039, but it takes 39.1549 seconds
to return that simple query.  The Transactions table returns 343259 in .4358
seconds.  Does anyone have some optimization tips beyond what is already on
the wiki.

After a little more of my own tweaking I have the Attachments query down to
24.9559 seconds.

Has anyone successfully integrated RT3 with memcached?  Would I be better
off moving the mysql server to it's own server?

Running version:
RT 3.8.7
MySQL 5.0.67

Total tickets as of this writing:
7282

Total time on RT:
1yr 3m

Thanks in advance for any help that can be provided.


Thanks,
Bill

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100721/37b6e908/attachment.htm>