- 论坛徽章:
- 0
|
根据楼主的建议,我把BINLOG里前后日志都打出来了,如下:- # at 931501361
- #130723 2:22:27 server id 2016204 end_log_pos 931501436 Query thread_id=2213567 exec_time=0 error_code=0
- SET TIMESTAMP=1374517347/*!*/;
- BEGIN
- /*!*/;
- # at 931501436
- #130723 2:22:27 server id 2016204 end_log_pos 931501794 Query thread_id=2213567 exec_time=0 error_code=0
- SET TIMESTAMP=1374517347/*!*/;
- INSERT INTO T_APP_FREE_ORDER(FFINISHEDTIME,FID ,FPHONE_SN,FPURCHASE_TIME,FSTATUS,FTOTALPRICE ,FUSERID, FNUMBER, FUSER_NAME,FAPPID,FVERSIONID,FQUANTITY) VALUES ('2013-07-23 02:22:26',131927742 ,'040BBG6F2ZND','2013-07-23 02:22:26',2,0
- ,0,'APMG130723020243', '',860056,2638611,1)
- /*!*/;
- # at 931501794
- #130723 2:22:27 server id 2016204 end_log_pos 931501951 Query thread_id=2213567 exec_time=0 error_code=0
- SET TIMESTAMP=1374517347/*!*/;
- DELETE FROM T_APP_DOWNLOAD WHERE FNEW_PHONE_SN ='040BBG6F2ZND' and FVERSIONID=2638611
- /*!*/;
- # at 931501951
- #130723 2:22:27 server id 2016204 end_log_pos 931502308 Query thread_id=2213567 exec_time=0 error_code=0
- SET TIMESTAMP=1374517347/*!*/;
- INSERT INTO T_APP_DOWNLOAD(FAPPID,FCLIENTID ,FDOWNLOAD_TIME,FID,FIP ,FNEW_PHONE_SN,FORDERID,FORDER_ITEMID,FORDER_PHONE_SN ,FVERSIONID, FDOWNLOAD_URL) VALUES (860056,0 ,'2013-07-23 02:22:26',130477183,'42.48.201.226' ,'040BBG6F2ZN
- D',131927742,0,'040BBG6F2ZND' ,2638611, '')
- /*!*/;
- # at 931502308
- #130723 2:22:27 server id 2016204 end_log_pos 931502335 Xid = 431918794
- COMMIT/*!*/;
- # at 931502335
- #130723 2:22:29 server id 2016204 end_log_pos 931502410 Query thread_id=2213567 exec_time=0 error_code=0
- SET TIMESTAMP=1374517349/*!*/;
- BEGIN
- /*!*/;
复制代码 慢日志记录如下:- # Time: 130723 2:06:18
- # User@Host: meizu_store[meizu_store] @ [192.168.16.85]
- # Query_time: 1.194662 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
- SET timestamp=1374516378;
- commit;
- # Time: 130723 2:22:28
- # User@Host: meizu_store[meizu_store] @ [192.168.16.123]
- # Query_time: 1.389423 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
- SET timestamp=1374517348;
- commit;
- # Time: 130723 7:07:40
- # User@Host: meizu_store[meizu_store] @ [192.168.16.104]
- # Query_time: 1.065205 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
- SET timestamp=1374534460;
- commit;
复制代码 在2:22:27的时候有一个事务操作,事务提交时间也是2:22:27.下一个事务的开始时间是2:22:29,中间有一秒时间是没有事务的。结合慢查询,慢查询里记录的commit是2:22:28,是不是说27开始的那个事务,在28的时候才提交成功?整个提交时间花了1S多?
我想做个例子出来验证,但是不知道怎么做。
|
|