Hi List, Any update on this
Thanks Anil Hi List, Below is the output of mysqldumpslow. In the output query execution time is showing -ve value how to interpret the below output i.e how to interpret -ve value for query execution time please advice Count: 1 Time=4294967223.00s (-73s) Lock=0.00s (0s) Rows=0.0 (0), ebizb11[ebizb11]@ UPDATE MM_EMAIL,MM_GROUP SET MM_EMAIL.STATUS='S' WHERE MM_EMAIL.EMAILADD=lower('S') AND MM_GROUP.ID=MM_EMAIL.GROUPID AND MM_GROUP .DEPTID=N Count: 1 Time=4294967223.00s (-73s) Lock=0.00s (0s) Rows=0.0 (0), ebizb11[ebizb11]@ SELECT LIST.NAME,DEPT.NAME FROM MM_LIST LIST, MM_DEPARTMENT DEPT WHERE LIST.DEPTID=DEPT.ID AND LIST.LISTTYPE = 'S' AND LIST.STATUS = 'S' AND LIST.CREATEDDATE > DATE_SUB(NOW(),INTERVAL N DAY) Thanks Anil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]