List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:January 13 2010 1:13pm
Subject:Re: mysql query takes too much time to run
View as plain text  
Sac,
this is like saying I have a pain, what can it be?
Attach more info if you hope in some help, at least the explain plan.

Cheers

Claudio


2010/1/13 F.A.I.Z.A.L <sac.faizal@stripped>

> hi
>
> can anybody help me to check this query is written in good way
>
> select ATX_Status.Server as `Server`, ATX_Status.Load as
> `Load`,ATX_Status.System as `System`,
> atx.ATX_Status.Timestamp as `TimeStamp`, `Coverage`,
> atx.ATX_Summary.Testware as `View`, `Traffic`,
> ATX_Status.Status as `Status`, ATX_Request.Requestor as `Requestor`,
> atx.ATX_Summary.
> Logs as `Logs`, `Priority`, `Server_IP_Address`,
> atx.ATX_Request.isHostBuild
> as `isHost`,
> atx.ATX_WebLogs.Logs as `WLogs`, `TestRun`, `PRequestor`, `Reason`,
> `AbortRqstr`,
> DATE_SUB( str_to_date(ATX_Status.Timestamp, '%m%d%Y-%H'), INTERVAL
> ATX_Time.TimeDiff HOUR_MINUTE)
> as `ConvTime`, ATX_Reruns.isRerun as rerun, ATX_Reruns.comment as
> reruncomment, atx.ATX_RuntimeStats.
> lbtStartTime, atx.ATX_RuntimeStats.runStartTime,
> atx.ATX_RuntimeStats.totalRunDuration
> from atx.ATX_Status
> left join atx.ATX_Request on atx.ATX_Request.Timestamp =
> atx.ATX_Status.Timestamp
> left join atx.ATX_WebLogs on atx.ATX_Status.Timestamp =
> atx.ATX_WebLogs.Timestamp
> left join atx.ATX_Server on atx.ATX_Status.Server =
> atx.ATX_Server.Server_Name
> left join atx.ATX_Time on atx.ATX_Server.Server_Location =
> atx.ATX_Time.Server_Location
> left join atx.ATX_RuntimeStats on atx.ATX_Status.Timestamp =
> atx.ATX_RuntimeStats.Timestamp
> left join atx.ATX_AbortedJobs on atx.ATX_Status.Timestamp =
> atx.ATX_AbortedJobs.Timestamp
> left join atx.ATX_Reruns on atx.ATX_Status.Timestamp =
> atx.ATX_Reruns.Timestamp
> left join atx.ATX_Summary on atx.ATX_Summary.Timestamp =
> atx.ATX_Status.Timestamp
> where (
> ATX_Status.Status like '%running%' or ATX_Status.Status like '%queued%' or
> ATX_Status.Status like '%migrating%' or ATX_Status.Status like '%loading%'
> or
> ATX_Status.Status like '%configuring%' or ATX_Status.Status like
> '%activating%' )
> and ATX_Server.Server_Status=1 and ATX_Status.isAlive=1
> and ATX_Status.Server = 'ALIL-CHN RLAB'
> and ATX_Status.System = 'ETSI-NFXSA-NANTA-ISAM-01'
> and ATX_Status.Load = 'SD_4003.418' and str_to_date(ATX_Status.Timestamp,
> '%m%d%Y')
>
> thanks in advance
>
> Cheers
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>



-- 
Claudio

Thread
mysql query takes too much time to runF.A.I.Z.A.L13 Jan
  • Re: mysql query takes too much time to runClaudio Nanni13 Jan
  • Re: mysql query takes too much time to runmos13 Jan