<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi All,<br>
<br>
We have upgraded to 3.6.6 over the weekend and also run some
optimisation against the database but performance is still very poor.<br>
<br>
I have looked at RTx::RightMatrix and Everyone definately does not have
OwnTickets rights unless that is lying to me, which I doubt.<br>
I've used the tuning-primer.sh script to do some tuning and performance
has improved somewhat, as query builder now only take 300 seconds
average to load instead of 400, but it is still unusable which is
frustrating the users. It's going to take another 36 hours before I can
check how the optimisation is going.<br>
<br>
I couldn't get the MySQLTuner to run, but I'll take a look at the perl
this week if I get a chance.<br>
<br>
If anyone else has any ideas at all, I'm open to suggestions, including
witchcraft :)<br>
<br>
Richard<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:rt-users-request@lists.bestpractical.com">rt-users-request@lists.bestpractical.com</a> wrote:<br>
<blockquote
cite="mid:mailman.9.1205424008.31106.rt-users@lists.bestpractical.com"
type="cite">
<pre wrap="">Today's Topics:
1. Re: RT 3.6.4 poor query performance (Jesse Vincent)
2. Re: RT 3.6.4 poor query performance (Toby Darling)
----------------------------------------------------------------------
Message: 1
Date: Thu, 13 Mar 2008 11:45:53 -0400
From: Jesse Vincent <a class="moz-txt-link-rfc2396E" href="mailto:jesse@bestpractical.com"><jesse@bestpractical.com></a>
Subject: Re: [rt-users] RT 3.6.4 poor query performance
To: Richard Ellis <a class="moz-txt-link-rfc2396E" href="mailto:Richard.Ellis@Sun.COM"><Richard.Ellis@Sun.COM></a>
Cc: <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:23EB3BA2-27A3-4669-A127-560B3D834973@bestpractical.com"><23EB3BA2-27A3-4669-A127-560B3D834973@bestpractical.com></a>
Content-Type: text/plain; charset="us-ascii"
On Mar 13, 2008, at 8:46 AM, Richard Ellis wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi All,
We have recently updated our RT instance from 3.4.6 running on
Solaris 9
to a new server running Solaris 10 and 3.6.4.
</pre>
</blockquote>
<pre wrap=""><!---->
You probably want RT 3.6.6 if you're on MySQL. Ruz did some serious
query optimization. But my first guess is that you've granted
"Everybody" the right to OwnTickets somewhere.
</pre>
<blockquote type="cite">
<pre wrap="">Everything works perfectly and we have removed all of the
customisations
that we used to use for a virtually vanilla 3.6.4 install. However,
when
opening the Query Builder page, performance slows to a massive extent.
Average page load is under 1 second, but performing any action in
Query
Builder averages 400 seconds.
I thought it was the database so upgraded mysql from 5.0.34 to
5.0.51a,
but that made no difference. I then upgraded DBIx::SearchBuilder to
the
latest version and DBD::mysql but it is still as bad. Even upgraded
every single perl module to latest and restarted everything, but still
as bad.
mysqlcheck rt3 says everything is ok.
There are only 10,000 tickets so it shouldn't be a volume problem.
Running on perl 5.8.8.
Anyone any ideas?
Richard
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
<pre wrap=""><!---->
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : <a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/pipermail/rt-users/attachments/20080313/85609c29/attachment-0001.pgp">http://lists.bestpractical.com/pipermail/rt-users/attachments/20080313/85609c29/attachment-0001.pgp</a>
------------------------------
Message: 2
Date: Thu, 13 Mar 2008 15:53:24 +0000
From: Toby Darling <a class="moz-txt-link-rfc2396E" href="mailto:darling@ccdc.cam.ac.uk"><darling@ccdc.cam.ac.uk></a>
Subject: Re: [rt-users] RT 3.6.4 poor query performance
To: Richard Ellis <a class="moz-txt-link-rfc2396E" href="mailto:Richard.Ellis@Sun.COM"><Richard.Ellis@Sun.COM></a>, rt-users
<a class="moz-txt-link-rfc2396E" href="mailto:rt-users@lists.bestpractical.com"><rt-users@lists.bestpractical.com></a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:47D94DF4.7020802@ccdc.cam.ac.uk"><47D94DF4.7020802@ccdc.cam.ac.uk></a>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi Richard
</pre>
<blockquote type="cite">
<pre wrap="">That crashes out with a divide by zero error in the scripting, but it
looks really cool.
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 2M (Tables: 39)
[--] Data in InnoDB tables: 1015M (Tables: 20)
Use of uninitialized value in division (/) at ./mysqltuner.pl line 362 (#1)
Illegal division by zero at ./mysqltuner.pl line 362 (#2)
(F) You tried to divide a number by 0. Either something was wrong in
your logic, or you need to put a conditional in to guard against
meaningless input.
</pre>
</blockquote>
<pre wrap=""><!---->
That indicates something went wrong earlier in getting $physical_memory
(assuming you're using v0.8.6). Any error messages or warnings at the
start?. Try chucking some print statements in the os_setup function to
see where it's going wrong.
I should point out that I've nothing to do with the MySQLTuner project,
I've not even actually run it myself, just looked at the output with the
guys that look after the mysql/database.
Cheers
Toby
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<table border="0" cellpadding="0" cellspacing="0" width="519">
<tbody>
<tr valign="top">
<td height="121" width="98"><a href="http://www.sun.com"><img
moz-do-not-send="true" src="file://///home/re100941/6h_top.gif"
alt="Sun.com" border="0" height="92" width="98"></a></td>
<td style="font-family: Helvetica; font-size: 12px;" height="121"
width="249"><b> Richard Ellis </b><br>
Technical Developer, .Sun eBusiness <br>
<br>
<b>Sun Microsystems, Inc.</b><br>
Phone x(70) 24727/+44-1252-424 727<br>
Fax +44 1252 420410<br>
Email <a class="moz-txt-link-abbreviated"
href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a><br>
</td>
<td style="font-family: Helvetica; font-size: 12px;" width="172"><img
moz-do-not-send="true" src="file://///home/re100941/q01.gif"
alt="sun.com" height="118" width="172"></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>