<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Lucida Sans";
panose-1:2 11 6 2 3 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Lucida Sans","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-ZA link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Hi
all,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Having
some (what seems like DB) issues when attaching files, or replying to a certain
transaction, and the associated queries, it takes about a minute and a half to
create a ticket with a 120 KB attachment, and when replying to a transaction,
fetching and inserting the correspondence into the wysiwyg editor can take up
to a minute. I have turned on slow query logging and also optimized as much as
possible, using settings from our heavier DB servers as well as using
MySQLTuner... But still, the problem persists, details:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>RT
3.8.6 on FreeBSD 7.1 VM (Had the same issue on a physical machine) running on a
hefty 64 bit host(Vista, VMware), 2G RAM, MySQL 5.1.3, Apache2, mod_perl2. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Relevant
httpd.conf :<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><VirtualHost
rt.office.local:80><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
ServerName rt.office.local<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
ServerAdmin #####@#####<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
DocumentRoot /usr/local/rt3/share/html/<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
AddDefaultCharset UTF-8<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
#PerlModule Apache::DBI<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
PerlModule Apache2::RequestRec<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
PerlModule HTML::Mason::ApacheHandler<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
PerlRequire /usr/local/rt3/bin/webmux.pl<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
Alias /NoAuth/images/ /usr/local/rt3/share/html/NoAuth/images/<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><Directory
/><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
SetHandler perl-script<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
PerlHandler RT::Mason<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
AuthName RADIUS<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
AuthType Basic<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
AuthXRadiusAddServer "#####" "#####"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
AuthXRadiusTimeout 5<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
AuthXRadiusRetries 4<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
Require valid-user<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
AuthBasicProvider xradius<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
</Directory><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'></VirtualHost><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><LocationMatch
"/NoAuth"><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
Satisfy Any<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>
Require valid-user<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'></LocationMatch><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>my.cnf:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>[mysqld]<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>max_allowed_packet=10MB<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>query_cache_size=32M<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>tmp_table_size=64M<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>max_heap_table_size=64M<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>thread_cache_size=4<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>innodb_buffer_pool_size=300M<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>log-slow-queries=/var/log/mysql_slow_queries.log<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>RT_SiteConfig:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($rtname,
'Alldata');<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($Organization,
"########");<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($Webpath,
"");<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($WebBaseURL,
"http://##########");<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($SendmailPath
, "/usr/sbin/sendmail");<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($SendmailArguments
, "-oi -t");<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($Timezone
, 'Europe/Amsterdam');<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($CorrespondAddress,
q{#####@#####} );<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($CommentAddress,
q{#####@#####});<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($OwnerEmail,
q{#####@#####});<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($WebExternalAuth
, 1);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($WebFallbackToInternalAuth
, 1);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($WebExternalAuthContinuous,
0);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($WebExternalAuto
, 1);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($AutoCreateFromExternalUserInfo,
1);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($MaxAttachmentSize
, 10000000);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#Set($MaxInlineBody,
0);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($DontSearchFileAttachments,
1); (Doesn’t look like this works...)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>Set($SuppressInlineTextFiles,
1);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>1;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>A
few lines from slow query log:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
DISTINCT main.* FROM Tickets main JOIN Transactions Transactions_1 ON (
Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2 ON (
Attachments_2.TransactionId = Transactions_1.id ) WHERE
(Transactions_1.ObjectType = 'RT::Ticket') AND (main.Status != 'deleted') AND (
( Attachments_2.Filename IS NULL AND Attachments_2.Content LIKE '%iPhone%'
) AND ( Attachments_2.Filename IS NULL AND Attachments_2.Content
LIKE '%IPHONE%' ) AND ( Attachments_2.Filename IS NULL AND
Attachments_2.Content LIKE '%iphone%' ) AND ( main.Status = 'open'
OR main.Status = 'new' OR main.Status = 'stalled' OR main.Status = 'resolved' )
) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ORDER BY
main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 19:56:32<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 38.581619 Lock_time: 0.000478 Rows_sent: 0
Rows_examined: 55108<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265914592;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND main.Content
!= '') AND (main.Parent = '68277') AND (main.ContentType = 'text/plain')
ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:39:57<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 39.655915 Lock_time: 0.000006 Rows_sent: 0
Rows_examined: 55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265927997;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:40:21<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 23.391029 Lock_time: 0.000006 Rows_sent: 0
Rows_examined: 55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265928021;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:40:33<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.936418 Lock_time: 0.000006 Rows_sent: 0
Rows_examined: 55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265928033;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:40:45<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.771741 Lock_time: 0.000006 Rows_sent: 0
Rows_examined: 55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265928045;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:40:57<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.982423 Lock_time: 0.000220 Rows_sent: 0
Rows_examined: 55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265928057;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:41:09<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 12.005457 Lock_time: 0.000007 Rows_sent: 0 Rows_examined:
55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265928069;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:41:21<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 12.057792 Lock_time: 0.000005 Rows_sent: 0
Rows_examined: 55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265928081;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:41:33<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.991430 Lock_time: 0.000006 Rows_sent: 0
Rows_examined: 55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265928093;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100211 23:41:45<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 12.007473 Lock_time: 0.000007 Rows_sent: 0
Rows_examined: 55113<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265928105;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68280') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:16:00<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 45.911922 Lock_time: 0.000005 Rows_sent: 1 Rows_examined:
55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944560;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:16:12<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.784373 Lock_time: 0.000005 Rows_sent: 1
Rows_examined: 55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944572;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:16:23<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 10.882671 Lock_time: 0.000165 Rows_sent: 1
Rows_examined: 55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944583;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:16:34<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 10.798826 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944594;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:16:45<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 10.834359 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944605;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:16:56<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.038873 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944616;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:17:07<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 10.916713 Lock_time: 0.000006 Rows_sent: 1 Rows_examined:
55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944627;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:17:18<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 10.637657 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944638;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 4:17:28<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 10.628150 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55118<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265944648;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68287') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:30:50<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 36.636542 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949050;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType = 'text/plain')
ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:31:08<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 17.914245 Lock_time: 0.000007 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949068;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:31:19<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.108912 Lock_time: 0.000007 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949079;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:31:30<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.019829 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949090;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:31:41<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.070368 Lock_time: 0.000166 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949101;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:31:53<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.139404 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949113;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:32:04<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.035979 Lock_time: 0.000007 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949124;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:32:15<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.301442 Lock_time: 0.000157 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949135;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 5:32:26<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 11.136719 Lock_time: 0.000150 Rows_sent: 1
Rows_examined: 55123<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265949146;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68292') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 9:52:37<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 58.189971 Lock_time: 0.000106 Rows_sent: 1 Rows_examined:
55129<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265964757;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68300') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 51.502213 Lock_time: 0.000869 Rows_sent: 1
Rows_examined: 55129<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265964757;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68300') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 9:52:50<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 12.880213 Lock_time: 0.000111 Rows_sent: 1
Rows_examined: 55129<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265964770;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68300') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 9:53:03<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 12.213462 Lock_time: 0.000006 Rows_sent: 1
Rows_examined: 55129<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265964783;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68300') AND (main.ContentType = 'text/plain')
ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 10:00:48<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 17.086619 Lock_time: 0.000006 Rows_sent: 0
Rows_examined: 55134<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265965248;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SELECT
main.* FROM Attachments main WHERE (main.Content IS NOT NULL AND
main.Content != '') AND (main.Parent = '68309') AND (main.ContentType =
'text/plain') ORDER BY main.id ASC;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Time: 100212 10:05:06<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
User@Host: rt_user[rt_user] @ localhost []<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>#
Query_time: 13.199653 Lock_time: 0.000006 Rows_sent: 0
Rows_examined: 55134<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Lucida Sans","sans-serif"'>SET
timestamp=1265965506;<o:p></o:p></span></p>
</div>
</body>
</html>