mysqldumpslow sql语句分析
dzypb 2010-03-16 10:43:29 Count: 16 Time=8.13s (130s) Lock=0.00s (0s) Rows=0.0 (0), gedevuser[gedevuser]@[10.2.6.43]
update xxx set ProcessType=N,ProcessFileName='S' ,UpdaterId=N,UpdateDate=now() where ProcessId=N
Count: 11 Time=10.12s (111s) Lock=0.00s (0s) Rows=0.0 (0), gedevuser[gedevuser]@3hosts
update xx set ProcessStatus='S' , DealStatus ='S', processFileName = 'S' ,updaterId = N, updateDate=now() where ProcessType='S' and fileid='S'
ProcessId 为主键,fileid建了索引,怎么主键 跟新还那么慢??