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-boun...@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
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
