??????SQL???
?????PHPor ???????[ 2017/1/17 11:35:00 ] ????????SQL??? ?????
????????絽?????????????????????????????????8w????????????????У????????????????????3??С??????????????£???????????????400ms?????
??????????????????????????????????????й???????????3С????????????????£?
????1??iops????????????湻??
????2??cpu???????????к?????????????????????????????????°?
????3?????????????????????
????4??8w?????????????????ú???????????????????????????10s
????5?????sql????????????explain????????????????????????????????rows???????????????裬?????
????6??sql????????? update table1 set bb=1 where aa=123
????7????????????????????aa????????ò???int???????????????aa???????varchar
????8?????sql???update table1 set bb=1 where aa=’123′
????9????????????8w????????????????10s
??????????
???????aa??varchar???????????????????????????aa?????????????ò???????????????????????????
??????
???·???
??????????????????
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