???IOE?? ? MySQL??PostgreSQL?????
???????????? ???????[ 2016/8/17 15:18:15 ] ????????????? MySQL
???????
????????μ?????й??????????????????????????λ??????α?????ε?????????????????й????????????ɡ??????????????????????????С?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????λ????????????????IOE??????????????????MySQL??????PostgreSQL?????????IOE?MySQL???????У??????????????????????????????????????????????PostgreSQL??????????“????”????????????????????????????????????????????
????PostgreSQL
????PostgreSQL???????????“The world’s most advanced open source database”??most advanced????????????????????PosgreSQL??????B+????????????????Щ?????£???????????????仹?????????Щ?????????ò???????TokuDB??MongoDB??????????????????ò?????PostgreSQL??????????????????Oracle?????????????????????PostgreSQL????????????????????Oracle????????????????????????MySQL??????????????????????????????????????PostgreSQL????????????ж?????????????????????MySQL??????????????20??????????????PostgreSQL??????????д??????μ???????????????????????????繫????????????Nokia??????????£?
????PostgreSQL??????????????????л?????????????????????OLTP???????????????PostgreSQL????????????????????????????????????????????????????????????????????????????????????????????????20%?????MySQL 5.7????????????????50W QPS???????????????NoSQL???????100W QPS??????PostgreSQL????????????????????????????????????????????????????????????????????????????????
????PostgreSQL?????????????????????????????????????Join??????????棬????????????????????????Oracle????PostgreSQL??????????????PostgreSQL??GreenPlum????????????PostgreSQL???????????????
????MySQL
????MySQL??????????????“The world’s most popular open source database.”?????PostgreSQL????仰????????????????MySQL???????????????????е??????????????????????????????????MySQL????????????
????MySQL????????????????????????????????????汾??洢?????????????????InnoDB?洢???棬????TokuDB??Infobright?????????????????????á?????????MySQL?????????????????????????????MySQL???????MySQL??????????????????????????????????????????????
????MySQL??Oracle????????????????????????????????Oracle???????????????????о???????Oracle???????????????????bug?????????????????????н?10???bug?????????????????????????????MySQL????????????????????????г???????500???????????????
????MySQL???????????ж???????????????????????ī??????????κ????????????????MySQL?????????PostgreSQL??????????????????????JOIN??????????????Hash Join??????????????????????MySQL?????5.6?汾?????MRR??Multi-Range Read????ICP??Index Condition Pushdown????BKA??Batched Key Access ??Join??Щ?????????JOIN???????????????????????????????MySQL????????Hash Join????????Щ???????????????MySQL??Join??????????????????????????????????????????????????????Hash Join????5????????????????MySQL???8???????Щ????????????????????????????????0.1??????????????????????????????????????????????MySQL??5.6??5.7?汾???????????????5.1????5.5?汾??
????MySQL?滻Oracle?????????????????Oracle?????????(Transparent Gateway)?????MySQL?????Fedorate?洢???????MySQL????????????????????????????????????????????????MariaDB???????????????Connect?洢???棬???????Oracle????????????
??????????????????MySQL????????????????????????????????Щ?????????????????????????????鼮??MySQL?????????InnoDB?洢???桷??MySQL?????????SQL???????????????????????????????????????????á?
????????????MySQL??????????????????????????InfoBright??TokuDB?洢????????InfoBright???д??????????棬?????????????????????????PostgreSQL???????????С?TokuDB?????????LSM??????????????棬???????????????????£????????????????????????????????????PostgreSQL??Oracle?????????????MySQL???????????????????????????????????
????PosgreSQL??MySQL??????????????????????????????й????????????????????MySQL??????????????PostgreSQL???????????????????MySQL????????????????????????ü???????????????????飬????PostgreSQL?????0???????????г???PostgreSQL?????????MySQL???к????鼮??DBA?????????????????????????????MySQL??Oracle?????????????к????·????
?????IOE
?????IOE????????????????????IT????е?IBMС?????Oracle?????EMC?洢???IE??????????飬??????????????滻??????X86????????????????????С??????????С??????Oracle????????????IOE???????????????????Oracle???3??4?????????а???????????????????????????Oracle?????????????????????MySQL????????Oracle????????
???????????????????????????????“????”??????????IOE??????????????????????????????????????????????????????????Oracle???????????鰱?????????????????????????????????κ???????????????????????????39??????????????????IOE?????
?????IOE?糱???????????????????????????????????????????????????????飬?г?????????ɡ???????????????????????????????????????Щ????????????????????????????????????????+?????????????????????????????Щ?????????????
???????????????????Ч???????????£????Ч???????????????????????????????????????????????????????????????????????????????????????Oracle????3??4?????????????????????????????????????39???????????????????????????????????????????????15???????????????????2019?????????75????????????
?????????Щ????????????????????????PostgreSQL?滻Oracle????????????????“??”???滻Oracle????????????????IT????????????????????????????????????????????????????в???????????????????????????????????????????PostgreSQL???????????????????й???д???????t??????????????????????????????μ????????ν“??”???滻??????????????y??д洢???????????????????????PostgreSQL????????????????????????????????????????????????????????PostgreSQL??????????????????????????GreenPlum????PostgreSQL????????GreenPlum??????о?????????????????????????????????????????????????????????????
??????
???·???
??????????????????
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