<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7655.8">
<TITLE>RE: [rt-users] Mysql queries slow</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<BR>
<BR>
<P><FONT SIZE=2>with no real mysql tweaking on RT 3.8.8 I get:<BR>
<BR>
mysql> select count(id) from Attachments;<BR>
+-----------+<BR>
| count(id) |<BR>
+-----------+<BR>
| 41636 |<BR>
+-----------+<BR>
1 row in set (0.62 sec)<BR>
<BR>
while significantly less that yours, .62 seconds isn't too shabby...<BR>
<BR>
-----Original Message-----<BR>
From: rt-users-bounces@lists.bestpractical.com on behalf of William Graboyes<BR>
Sent: Wed 7/21/2010 8:19 PM<BR>
To: rt-users<BR>
Subject: [rt-users] Mysql queries slow<BR>
<BR>
Hi List,<BR>
<BR>
As an example of what I am talking about the query `select count(id) from<BR>
Attachments;` The returned result is 174039, but it takes 39.1549 seconds<BR>
to return that simple query. The Transactions table returns 343259 in .4358<BR>
seconds. Does anyone have some optimization tips beyond what is already on<BR>
the wiki.<BR>
<BR>
After a little more of my own tweaking I have the Attachments query down to<BR>
24.9559 seconds.<BR>
<BR>
Has anyone successfully integrated RT3 with memcached? Would I be better<BR>
off moving the mysql server to it's own server?<BR>
<BR>
Running version:<BR>
RT 3.8.7<BR>
MySQL 5.0.67<BR>
<BR>
Total tickets as of this writing:<BR>
7282<BR>
<BR>
Total time on RT:<BR>
1yr 3m<BR>
<BR>
Thanks in advance for any help that can be provided.<BR>
<BR>
<BR>
Thanks,<BR>
Bill<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>