insert into select * from 锁表

 mysql[192.168.11.187]  processid[249] root@localhost in db[zjzc] hold  transaction time 197 
112069858,250,insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime) values(11,'1.1.1.1',NULL,' 用户注册-register-成功',NULL,NULL,NULL,NULL,now(),now()),112069824,249,insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime)  select clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime from ClientActionTrack20151125
 mysql[192.168.11.187]   blocking_thread[249] blocking waiting_thread[250]'s insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime) values(11,'1.1.1.1',NULL,' 用户注册-register-成功',NULL,NULL,NULL,NULL,now(),now())

原文地址:https://www.cnblogs.com/hzcya1995/p/13350007.html