MySQL?????????????
???????????RDS ???????[ 2016/7/27 11:07:22 ] ????????????? MySQL
????????????????RDS for MySQL?????????????????????????????????????????洢?????????????
?????洢?????RDS???????????????RDS??????????У????????????????????top 5????RDS?????????????????????????????????????????????????д????????????????????????RDS???????п????趨?????????????????????????????????????????????? ?????????????????ж??????????????????
?????????????????????????????е??????????????????????????????????????
????· ???????????????????????????????????????????????????????????????????????????????????????ú??????
????· ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????С????????????漰???????????????μ???????????????????????????????????????????????Щ???????????????????????????????????????е?????????????????????????????????·??д???????
??????????????????????????п?????ж?????????????
????
???????????????RDS?????????????????Щ????RDS??????п?????????????????5???????????
????· ????????
????· ??????
????· ??????
????· ?????????
????· ????????
??????????????????????????Щ???????
???????????
??????????????????????????????????????????????????????????????????????????????????????????????????????????? ????????????????????????μ??????????????????????????????????????????????????????????
????select TABLE_SCHEMA??TABLE_NAME??INDEX_LENGTH/1024/1024 as index_M??DATA_LENGTH/1024/1024 as data_M from TABLES order by (INDEX_LENGTH+DATA_LENGTH) desc limit 10;
?????????????????????????????δ??????????????????????????洢??
????1??δ????????????????????????????С??
????2???????????????????????????????????????鵵??
????3????????ú???????????????δ?С???洢???棬???з??????????
?????????????У???????????????????????????????????????????λ??????е???????Щ?????????μ?????
????????????????
????1???????????????????????????
???????????????????????????????????Optimize table xxxxx???÷?????5.6????????????RDS 5.6????????????
????2?????????????????????仹??
?????????????????????????????????????????????????????????????????????á?
????3????????????????????????洢???????????????????
??????????????????tokudb???潫???е???????????????????Ч????3?????????????tokudb???????????tokudb??buffer?? ??ο????????loose_tokudb_buffer_pool_ratio??
??????
???·???
??????????????????
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