MySQL?????????????
???????????RDS ???????[ 2016/7/27 11:07:22 ] ????????????? MySQL
????????????
????RDS MySQL????????M-M?????ü?????????????????????????binlog???????????binlog?????????????????RDS?????????????oss?У? ????????binlog?????????????????????????????????????д?????????????????binlog????????????????RDS?????oss?????? ?????binlog???????????????????????????????????????С????????????????
???????????????????????????????????и??£????????????н??????Σ???????row????£?binlog???????м???? ??????????binlog??????????????????ο?Mysql????ε???????μ???binlog??????????????????????????????????Σ?varchar(8000)??text??blob??clob???
?????????????????????????????????????ж????????????binlog??д?????????????????binlog?????????????? ????????????????????
????????????
?????????????????????????????????????????????治????????????????е????д????????????????п????????????д?????? ????????????????????????????????????????order by??group by??distinct?????????????У???????????????order by????????????У? ????????sql??????????????????????????д??????
?????????????????????SQL?????μ???????????show processlist????????????SQL?????kill ??SQL??
?????????????sql??????????????????????????θ????????????????г????????SQL??
????????????????????????????????????????С?????????ο?RDS???????loose_rds_max_tmp_disk_space
???????????
??????????????????????????????????Щ?????????Щ???????????????????е????mysql??ibdata1??ib_logfile0??????????? ????? “???????”???????????????????ο???ibdata1????????????????λ
????1??ibdata1????д????????undo_log?????齫?汾??????5.6?????ж?????purge?????????????undo log?????????????undo tablespace ???????????ibdata1?????????
????2??????????????????????????ibdata1?????
????3?????????????δ?????????undo??????????????е?INNODB_TRX?????
??????????????????????????????????????????????????????????????????Щ??????????????????????????????Щ???? ????????????÷????
??????
???·???
??????????????????
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