???mysql????????????
?????Young ???????[ 2017/2/21 13:45:05 ] ????????????? MySQL
???????????WAITING FOR THIS LOCK TO BE GRANTED??????????????????2????????S????????????????????insert into test (id??a) values (10??2)?????????insert???????????????????????????????X?????????????????S???????????a??????????????????insert?????????????????duplicate key???飬??????μ?????????????S??????????????a??ν???????
????????????S?????????????????????ε???????????????????S????滹?????δ????????X????????S???????????????γ??????????????????????
???????????????????????????????????????????γ??????????????????????????????????????????????????????????γ?????
?????????γ??????
???????????????????????γ??????????????????????????????γ???????
???????
???????????????????У??и????????????????????????????????????ó???????????????????и?????????2??п???????
?????????????????????????????????????????????????????2?????????S????????X???????lock_mode X locks gap before rec insert intention waiting????????????????????????????????????????
???????
???????????????????????????????????????????????????????????????????е?SQL????????????????????????????????γ??????????????????????????????????
????PS????????????????????????????????С??????????????е????????????????лл??
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11