<html><head><base href="x-msg://711/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I'd heard of this before and thought I'd removed them. Just checked on live and they're still there.<div><br></div><div>However removing them seems to have made no difference. Still taking 20+seconds for a ticket with 130 comments/replies (+ other status changes etc).</div><div><br></div><div>Cheers,</div><div><br></div><div>Justin<br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><br>-------------------------------------------------<br>Justin Hayes<br>OpenBet Support Manager<br><a href="mailto:justin.hayes@openbet.com">justin.hayes@openbet.com</a></span>
</div>
<br><div><div>On 1 Jul 2010, at 11:51, Raed El-Hames wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div lang="EN-GB" link="blue" vlink="purple" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div class="Section1" style="page: Section1; "><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">Justin,<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">Do you use Transaction custom fields, if you do n’t ; try and comment out lines 70,71,72 from html/Ticket/Elements/ShowTransaction<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">% if ( $Transaction->CustomFieldValues->Count ) {<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "> <& /Elements/ShowCustomFields, Object => $Transaction &><o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">% }<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">See if that improves things for you.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">Some of our monitoring tickets can have up to 500 updates, such tickets use to take up to 20s to load, once I commented out the above lines, load time is now down to less than 5 seconds.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">Regards;<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">Roy<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="border-top-style: none; border-right-style: none; border-bottom-style: none; border-width: initial; border-color: initial; border-left-style: solid; border-left-color: blue; border-left-width: 1.5pt; padding-top: 0cm; padding-right: 0cm; padding-bottom: 0cm; padding-left: 4pt; "><div><div style="border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-top-style: solid; border-top-color: rgb(181, 196, 223); border-top-width: 1pt; padding-top: 3pt; padding-right: 0cm; padding-bottom: 0cm; padding-left: 0cm; "><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif; ">From:</span></b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif; "><span class="Apple-converted-space"> </span><a href="mailto:rt-users-bounces@lists.bestpractical.com" style="color: blue; text-decoration: underline; ">rt-users-bounces@lists.bestpractical.com</a><span class="Apple-converted-space"> </span>[mailto:rt-users-bounces@lists.bestpractical.com]<span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Justin Hayes<br><b>Sent:</b><span class="Apple-converted-space"> </span>01 July 2010 11:39<br><b>To:</b><span class="Apple-converted-space"> </span>Kenneth Crocker<br><b>Cc:</b><span class="Apple-converted-space"> </span><a href="mailto:rt-users@lists.bestpractical.com" style="color: blue; text-decoration: underline; ">rt-users@lists.bestpractical.com</a><br><b>Subject:</b><span class="Apple-converted-space"> </span>Re: [rt-users] Slow Ticket History 3.8.8<o:p></o:p></span></div></div></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p> </o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">We do Kenneth, but most tickets don't have many file attachments, so I assume that's not an issue?<o:p></o:p></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p> </o:p></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">Cheers,<o:p></o:p></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p> </o:p></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">Justin<o:p></o:p></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: black; "><br><span class="apple-style-span">-------------------------------------------------</span><br><span class="apple-style-span">Justin Hayes</span><br><span class="apple-style-span">OpenBet Support Manager</span><br><span class="apple-style-span"><a href="mailto:justin.hayes@openbet.com" style="color: blue; text-decoration: underline; ">justin.hayes@openbet.com</a></span></span><o:p></o:p></div></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p> </o:p></div><div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">On 29 Jun 2010, at 17:54, Kenneth Crocker wrote:<o:p></o:p></div></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><br><br><o:p></o:p></div><p class="MsoNormal" style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 12pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">Justin,<br><br>I didn't see this mentioned and may have missed it, but are you displaying attachements inline? That might cut back on the I/O for History. Just a thought.<br><br>Kenn<br>LBNL<o:p></o:p></p><div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">On Tue, Jun 29, 2010 at 8:04 AM, Justin Hayes <<a href="mailto:justin.hayes@openbet.com" style="color: blue; text-decoration: underline; ">justin.hayes@openbet.com</a>> wrote:<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">As a test we've just created a long ticket in an empty RT DB and it's very fast. So does look to be DB related - contrary to our earlier investigations.<br><br>I guess it must still access the DB resultset during the ticket rendering (which isn't how we thought it would work).<br><br>Time to tune the hell out of mysql then.......<o:p></o:p></div><div><p class="MsoNormal" style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 12pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><br>Justin<br><br>-------------------------------------------------<br>Justin Hayes<br>OpenBet Support Manager<br><a href="mailto:justin.hayes@openbet.com" style="color: blue; text-decoration: underline; ">justin.hayes@openbet.com</a><o:p></o:p></p></div><div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">On 29 Jun 2010, at 15:53, Justin Hayes wrote:<br><br>> Seem to be quite a few things to look at Jason. Need to figure out what they all mean first.<br>><br>> Justin<br>><br>> -------- General Statistics --------------------------------------------------<br>> [--] Skipped version check for MySQLTuner script<br>> [OK] Currently running supported MySQL version 5.1.37-1ubuntu5.4-log<br>> [OK] Operating on 64-bit architecture<br>><br>> -------- Storage Engine Statistics -------------------------------------------<br>> [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster<br>> [--] Data in MyISAM tables: 611M (Tables: 8)<br>> [--] Data in InnoDB tables: 10G (Tables: 20)<br>> [!!] Total fragmented tables: 21<br>><br>> -------- Performance Metrics -------------------------------------------------<br>> [--] Up for: 19d 19h 32m 37s (110M q [64.266 qps], 222K conn, TX: 637B, RX: 39B)<br>> [--] Reads / Writes: 98% / 2%<br>> [--] Total buffers: 602.0M global + 134.8M per thread (150 max threads)<br>> [!!] Maximum possible memory usage: 20.3G (262% of installed RAM)<br>> [OK] Slow queries: 0% (229K/110M)<br>> [!!] Highest connection usage: 100% (151/150)<br>> [OK] Key buffer size / total MyISAM indexes: 512.0M/6.7M<br>> [OK] Key buffer hit rate: 100.0% (84M cached / 7K reads)<br>> [OK] Query cache efficiency: 71.4% (76M cached / 107M selects)<br>> [!!] Query cache prunes per day: 661360<br>> [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2M sorts)<br>> [!!] Joins performed without indexes: 112714<br>> [!!] Temporary tables created on disk: 33% (968K on disk / 2M total)<br>> [OK] Thread cache hit rate: 99% (1K created / 222K connections)<br>> [OK] Table cache hit rate: 36% (318 open / 880 opened)<br>> [OK] Open file limit used: 14% (166/1K)<br>> [OK] Table locks acquired immediately: 99% (39M immediate / 39M locks)<br>> [!!] InnoDB data size / buffer pool: 10.1G/8.0M<br>><br>> -------- Recommendations -----------------------------------------------------<br>> General recommendations:<br>> Run OPTIMIZE TABLE to defragment tables for better performance<br>> Reduce your overall MySQL memory footprint for system stability<br>> Reduce or eliminate persistent connections to reduce connection usage<br>> Adjust your join queries to always utilize indexes<br>> When making adjustments, make tmp_table_size/max_heap_table_size equal<br>> Reduce your SELECT DISTINCT queries without LIMIT clauses<br>> Variables to adjust:<br>> *** MySQL's maximum memory usage is dangerously high ***<br>> *** Add RAM before increasing MySQL buffer variables ***<br>> max_connections (> 150)<br>> wait_timeout (< 28800)<br>> interactive_timeout (< 28800)<br>> query_cache_size (> 16M)<br>> join_buffer_size (> 2.0M, or always use indexes with joins)<br>> tmp_table_size (> 128M)<br>> max_heap_table_size (> 64M)<br>> innodb_buffer_pool_size (>= 10G)<br>><br>><br>> -------------------------------------------------<br>> Justin Hayes<br>> OpenBet Support Manager<br>><span class="Apple-converted-space"> </span><a href="mailto:justin.hayes@openbet.com" style="color: blue; text-decoration: underline; ">justin.hayes@openbet.com</a><br>><br>> On 29 Jun 2010, at 15:22, Jason Doran wrote:<br>><br>>> Hi,<br>>> If you are using mysqld have a look at "<a href="http://mysqltuner.pl/" target="_blank" style="color: blue; text-decoration: underline; ">mysqltuner.pl</a>" perl script (google)<br>>> This has fixed quickly many performance issues on both RT and other<br>>> web-based software we use. I run this every few weeks and apply suggested<br>>> changes and then simply restart mysqld when things are quite.<br>>><br>>> Regards,<br>>> Jason Doran<br>>> Computer Centre<br>>> NUI, Maynooth<br>>><br>>> On 29 Jun 2010, at 14:09, Justin Hayes wrote:<br>>><br>>>> Hi everyone,<br>>>><br>>>> I've raised this before, but we've had another look at it and still can't see how to improve things.<br>>>><br>>>> We put a lot of comments/replies in our tickets. Often there can be 50-100 entries in a ticket, mostly plain text. Loading such a ticket can take 10-20secs.<br>>>><br>>>> We don't have any slow queries - all the time seems to be in the code rendering the history of the ticket.<br>>>> We've had a go at stripping functions out of ShowHistory, ShowTransaction and ShowTransactionAttachmments but not had much success.<br>>>><br>>>> FWIW our RT runs on quad 3ghz Xeons with 8gb of ram.<br>>>><br>>>> I'd like to try and determine if we're just slow, or if this is just how long RT takes. Maybe perl is just slow.<br>>>><br>>>> Can anyone shed any light on how long it takes them to render long tickets in their systems? If you look at the page source it gives you a value e.g.<br>>>><br>>>> <span>Time to display: 24.996907</span><br>>>><br>>>> Can anyone share some numbers from theirs for longer tickets? It would be really appreciated.<br>>>><br>>>><br>>>> Thanks,<br>>>><br>>>> Justin<br>>>><br>>>> -------------------------------------------------<br>>>> Justin Hayes<br>>>> OpenBet Support Manager<br>>>><span class="Apple-converted-space"> </span><a href="mailto:justin.hayes@openbet.com" style="color: blue; text-decoration: underline; ">justin.hayes@openbet.com</a><br>>>><br>>>><br>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>>>> Buy a copy at<span class="Apple-converted-space"> </span><a href="http://rtbook.bestpractical.com/" target="_blank" style="color: blue; text-decoration: underline; ">http://rtbook.bestpractical.com</a><br>>><br>><br>><br>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>> Buy a copy at<span class="Apple-converted-space"> </span><a href="http://rtbook.bestpractical.com/" target="_blank" style="color: blue; text-decoration: underline; ">http://rtbook.bestpractical.com</a><br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>Buy a copy at<span class="Apple-converted-space"> </span><a href="http://rtbook.bestpractical.com/" target="_blank" style="color: blue; text-decoration: underline; ">http://rtbook.bestpractical.com</a><o:p></o:p></div></div></div></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>Buy a copy at<span class="Apple-converted-space"> </span><a href="http://rtbook.bestpractical.com" style="color: blue; text-decoration: underline; ">http://rtbook.bestpractical.com</a><o:p></o:p></div></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p> </o:p></div></div></div></div></div></span></blockquote></div><br></div></body></html>