??????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