pixivにおけるMySQL運用の実際

by konoiz

Slide 1

Slide 1 text

QJYJWʹ͓͚Δ.Z42-ӡ༻ͷ࣮ࡍ .Z42-5SFOE4FNJOBS!෱Ԭ ϐΫγϒגࣜձࣾΠϯϑϥ෦ࢁࠜ঵೭

Slide 2

Slide 2 text

ࣗݾ঺հ

Slide 3

Slide 3 text

ࣗݾ঺հ w :"."/&:PTIJZVLJLPOPJ[ w ೥ʹ৽ଔೖࣾɺΠϯϑϥνʔϜʹ഑ଐ w ීஈ͸౦ژΦϑΟεۈ຿

Slide 4

Slide 4 text

BHFOEB w QJYJWʹ͍ͭͯ w QJYJWͷΠϯϑϥɺ.Z42-ߏ੒ w QJYJWͰͷ.Z42-ͷӡ༻ʹ͍ͭͯ w .BTUFSঢ֨ɺ"-5&3

Slide 5

Slide 5 text

QJYJWʹ͍ͭͯ

Slide 6

Slide 6 text

QJYJWʹ͍ͭͯ w ΫϦΤΠλʔͷͨΊͷ4/4 w ೥݄αʔϏε։࢝ w ొ࿥Ϣʔβ਺ ສਓҎ্ w ݄ؒͷ΂ར༻ऀ਺໿ ສਓ w ૯౤ߘ਺໿ ສ࡞඼

Slide 7

Slide 7 text

QJYJWʹ͍ͭͯ

Slide 8

Slide 8 text

QJYJWͷΠϯϑϥʹ͍ͭͯ

Slide 9

Slide 9 text

QJYJWͷΠϯϑϥʹ͍ͭͯ

Slide 10

Slide 10 text

QJYJWͷΠϯϑϥʹ͍ͭͯ

Slide 11

Slide 11 text

QJYJWͷΠϯϑϥʹ͍ͭͯ w ݱࡏ͸σʔληϯλͰӡ༻ w ڌ఺ϥοΫ w पลαʔϏεͱ߹Θͤͯαʔό໿୆ w ໿(CQT

Slide 12

Slide 12 text

QJYJWͷΠϯϑϥʹ͍ͭͯ w νʔϜϝϯόʔਓ w αʔϏεͷ਺ΠϯϑϥνʔϜ w .Z42-αʔόͷӡ༻΋ਓ

Slide 13

Slide 13 text

QJYJWͷΠϯϑϥʹ͍ͭͯ 'SPOU4FSWFS  OHJOY -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- TMBWF *NBHF  4UPSBHF ,74  3FEJT /"5(BUFXBZ -PH4UPSBHF XSJUF JNHVQMPBE SFQMJDBUJPO SFBE  SFR SFBE SFT MPH DBDIF ˞/"5HBUFXBZ͸*OUFSOFUʹ௚͍݁ͯ͠ͳ͍ αʔόʹରͯ͠ΠϯλʔωοτΞΫηεΛఏڙ *OUFSOFU $POWFSU $BDIF4FSWFS *NBHF'MVY "QQMJDBUJPO4FSWFS BQBDIFQIQ 4FBSDI4FSWFS  4PMS TFBSDI JNQPSU *NBHF %JTQBUDIFS  OHJOY

Slide 14

Slide 14 text

Slide 15

Slide 15 text

QJYJWͷ.Z42-

Slide 16

Slide 16 text

QJYJWͷ.Z42- w ༻్ผʹܥ౷ͷ.Z42-σʔλϕʔε w .Z42-ࣗମ͸͘͝ී௨ͷ.BTUFS4MBWFߏ੒ w SFBE͸-JOVY7JSUVBM4FSWFS -74 Ͱ෼ࢄ w ։ൃ΍όοΫΞοϓ༻ʹ.Z42-4BOECPYΛ࢖༻

Slide 17

Slide 17 text

ܥ౷ͷ.Z42- w Ϣʔβؔ࿈σʔλɺΠϥετؔ࿈σʔλɺܾࡁؔ࿈σʔλʜͱ͍ͬ ͨܗͰਨ௚෼ׂ w ݪଇͱ֤ͯ͠ܥ౷୆͸4MBWF͕͍Δ w ߹ܭ.BTUFS୆ɺ4MBWF୆ w ࠷΋େ͖ͳߏ੒ͷܥ౷͸.BTUFS୆ʹରͯ͠4MBWF୆

Slide 18

Slide 18 text

-74 w -JOVY7JSUVBM4FSWFS w ܥ౷ຖʹTMBWF༻ͷԾ૝*1Λ༻ҙ w BQQ͕Ծ૝*1ʹରͯ͠ࢀরϦΫΤετ w -74͕όϥϯγϯάͯ͠TMBWFʹ࠶ૹ w TMBWF͸BQQʹରͯ͠௚઀Ԡ౴ %43 -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- TMBWF XSJUF SFQMJDBUJPO SFBE  SFR SFBE SFT "QQMJDBUJPO4FSWFS BQBDIFQIQ

Slide 19

Slide 19 text

.Z42-4BOECPY w αʔόͰෳ਺ͷ.Z42-Λ؆୯ʹىಈͰ͖Δ w ։ൃ؀ڥ΍όοΫΞοϓ༻ͷ.Z42-ʹ࢖༻ w 4BOECPYͰ࡞ͬͨTMBWFͷEBUBσΟϨΫτϦΛίϐʔͯ͠όοΫ ΞοϓΛ࡞੒ w ։ൃ؀ڥ΋ಉ༷ͷख๏Ͱຖ೔ຊ൪σʔλͱಉظ͠ͳ͓͢

Slide 20

Slide 20 text

.Z42-ͷӡ༻ʹ͍ͭͯ

Slide 21

Slide 21 text

લఏ w QJYJWͰ͸ݪଇϝϯςφϯεϞʔυʹ͠ͳ͍ w ਺݅ͷΤϥʔ͸ڐ༰͠ɺαʔϏεແఀࢭͰϝϯςφϯε͢Δ w .Z42-4MBWFΛ.BTUFSʹঢ֨ͤ͞Δࡍ΋ಉ༷

Slide 22

Slide 22 text

.BTUFSঢ֨

Slide 23

Slide 23 text

.BTUFSঢ֨ w QJYJWͷ.Z42-.BTUFS͸ܥ౷͝ͱʹԾ૝*1Λ͍࣋ͬͯΔ w Ծ૝*1Λ4MBWFʹ෇͚ସ͑ΔࣄͰ.BTUFSঢ֨Λॠؒతʹ࣮ࢪ͢Δ w ྗٕӡ༻

Slide 24

Slide 24 text

.BTUFSঢ֨ -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- TMBWF XSJUF SFQMJDBUJPO SFBE "QQMJDBUJPO4FSWFS BQBDIFQIQ .Z42- TMBWF Ծ૝*1 ࣮*1

Slide 25

Slide 25 text

.BTUFSঢ֨ -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- TMBWF XSJUF SFQMJDBUJPO "QQMJDBUJPO4FSWFS BQBDIFQIQ .Z42- TMBWF Ծ૝*1 ࣮*1 SFBE LJMMNZTRME

Slide 26

Slide 26 text

.BTUFSঢ֨ -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- TMBWF XSJUF "QQMJDBUJPO4FSWFS BQBDIFQIQ .Z42- TMBWF Ծ૝*1 ࣮*1 SFBE

Slide 27

Slide 27 text

.BTUFSঢ֨ -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- TMBWF XSJUF "QQMJDBUJPO4FSWFS BQBDIFQIQ .Z42- TMBWF Ծ૝*1 ࣮*1 SFBE

Slide 28

Slide 28 text

.BTUFSঢ֨ -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- /FX.BTUFS XSJUF "QQMJDBUJPO4FSWFS BQBDIFQIQ .Z42- TMBWF Ծ૝*1 ࣮*1 SFBE

Slide 29

Slide 29 text

.BTUFSঢ֨ -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- /FX.BTUFS XSJUF "QQMJDBUJPO4FSWFS BQBDIFQIQ .Z42- TMBWF Ծ૝*1 ࣮*1 SFBE

Slide 30

Slide 30 text

.BTUFSঢ֨ -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- /FX.BTUFS XSJUF "QQMJDBUJPO4FSWFS BQBDIFQIQ .Z42- TMBWF $)"/(&."45&350 ."45&3@)045 Ծ૝*1 ࣮*1 SFBE

Slide 31

Slide 31 text

.BTUFSঢ֨ -PBE#BMBODFS  -74 .Z42- NBTUFS .Z42- /FX.BTUFS XSJUF "QQMJDBUJPO4FSWFS BQBDIFQIQ .Z42- TMBWF SFQMJDBUJPO Ծ૝*1 ࣮*1 SFBE

Slide 32

Slide 32 text

.BTUFSঢ֨ w ܭըతʹ࣮ߦ͢Δ৔߹͸֓Ͷඵఔ౓Ͱ.BTUFSঢ֨Λ׬ྃͤ͞Δ w TMBWFಉ࢜ͰQPTJUJPO͕ҟͳΔ৔߹͸࠷΋৽͍͠΋ͷ·ͨ͸ଟ਺ܾͰ ଟ͍΋ͷΛਖ਼ͱͯ͠.BTUFSʹ͢Δ w ݩ.BTUFS͸ࢮΜͰ͍ΔͷͰ࠶ηοτΞοϓͯ͠4MBWFͱͯ͠໭͢ w ো֐Ͱ.BTUFS͕ࢮ๢ͨ͠৔߹΋खॱ͸΄΅ಉ͡

Slide 33

Slide 33 text

.BTUFSঢ֨ͷλΠϛϯά w %#ͷ࠶ىಈ͕ඞཁͳ࣌ w .Z42-ͷόʔδϣϯΞοϓ w ΦϯϥΠϯมߋෆՄͳઃఆͷมߋ࣌ w αʔόҠసɾ෺ཧαʔόͷϝϯςφϯε࣌ w 8SJUFʹӨڹ͕͋Δέʔε w େن໛ͳςʔϒϧͷ"-5&3 w .BTUFSো֐ൃੜ࣌

Slide 34

Slide 34 text

"-5&3

Slide 35

Slide 35 text

CPPLNBSLUBCMF w QJYJWͷػೳͷҰͭͰ͋ΔΠϥετͷʮϒοΫϚʔΫʯΛอଘ͢Δ UBCMF w QJYJWͷ%#ͷதͰ΋ಛʹϨίʔυ਺ͷଟ͍ςʔϒϧ w ໿(#ͷσʔλΛΦϯϝϞϦͰॲཧ w ౥ࡌϝϞϦ(#ͷαʔό

Slide 36

Slide 36 text

CPPLNBSLͷ"-5&3 w ೥Πϯϑϥ഑ଐޙ࠷ॳͷ࢓ࣄ w ౰࣌ͷ#PPLNBSLUBCMF͸.Z*4".Ͱ.Z42-ɺ໿ԯϨίʔυ w ͜ΕΛ*OOP%#ɺ.Z42-ʹมߋ w ී௨ʹ"-5&35"#&-ͨ͠৔߹ɺҰिؒఔ౓͔͔Δ

Slide 37

Slide 37 text

CPPLNBSLͷ"-5&3 w "-5&3Λ࢖Θͳ͍ w ฒྻ*/4&354&-&$5

Slide 38

Slide 38 text

ฒྻ*/4&354&-&$5 w ִ཭͞ΕͨTMBWF؀ڥΛ༻ҙ w "-5&3ޙͷঢ়ଶͷςʔϒϧΛ࡞੒ w "-5&3લͷςʔϒϧΛ4&-&$5ͯ͠CVML*/4&35 w ͨͩ͠*%ͰൣғΛ੾ͬͯɺฒྻ࣮ߦ͢Δ

Slide 39

Slide 39 text

*%CJHJOU ฒྻ*/4&354&-&$5 *%JOU ʜ ʜ ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$

Slide 40

Slide 40 text

*%CJHJOU ฒྻ*/4&354&-&$5 *%JOU ʜ ʜ ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5 4&-&$5

Slide 41

Slide 41 text

*%CJHJOU ʜ ʜ ʜ ฒྻ*/4&354&-&$5 *%JOU ʜ ʜ ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5 4&-&$5 */4&35 */4&35 */4&35

Slide 42

Slide 42 text

*%CJHJOU ʜ ʜ ʜ ฒྻ*/4&354&-&$5 *%JOU ʜ ʜ ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5

Slide 43

Slide 43 text

*%CJHJOU ʜ ʜ ʜ ʜ ʜ ฒྻ*/4&354&-&$5 *%JOU ʜ ʜ ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5 */4&35 */4&35

Slide 44

Slide 44 text

ฒྻ*/4&354&-&$5 w ฒྻ࣮ߦ͢Δͱ΄΅׬શʹ*0ϘτϧωοΫʹͳΔ w ଎౓͸σΟεΫੑೳ࣍ୈ w ͜ͷ࣌͸໿೔൒Ͱ׬ྃ

Slide 45

Slide 45 text

CPPLNBSLUBCMF

Slide 46

Slide 46 text

w ΋͏௚͙*/5ܕͷݶքͷԯʹୡ͢Δ w ͜͜਺೥Ͱ૿Ճϖʔε͸Ճ଎܏޲ w ૣٸʹ*/5Λ#*(*/5ʹ͢Δඞཁ͕͋Δ CPPLNBSLUBCMF

Slide 47

Slide 47 text

w ೥લͱಉ༷ʹฒྻ*/4&54&-&$5Λ࣮ߦ */5UP#*(*/5

Slide 48

Slide 48 text

*/5UP#*(*/5 TUBSU FOE

Slide 49

Slide 49 text

w ೥લͱಉ༷ʹฒྻ*/4&54&-&$5Λ࣮ߦ w ೔͔Β։࢝ͯ͠ࠓே׬ྃ w ೔ؒ */5UP#*(*/5

Slide 50

Slide 50 text

ฒྻ*/4&354&-&$5 w "-5&3ͱൺֱͨ͠ϝϦοτ w ௨ৗͷ"-5&3ΑΓߴ଎ʹॲཧͰ͖ΔՄೳੑ͕͋Δ w ࿦ཧ࡟আͷϨίʔυΛ෺ཧ࡟আ͢Δͱ͍ͬͨࣄ͕ಉ࣌ʹͰ͖Δ

Slide 51

Slide 51 text

·ͱΊ w QJYJWͰͷ.Z42-ʹ͍ͭͯ঺հ͠·ͨ͠ w QJYJWͷ৔߹ɺجຊతʹ͸γϯϓϧͳ.BTUFS4MBWFߏ੒Ͱɺ  ͋Δఔ౓ͷن໛·Ͱ͸໰୊ͳ͘ӡ༻Ͱ͖͍ͯ·͢

Slide 52

Slide 52 text

QJYJWͰ͸.Z42-αʔόͷӡ༻ɾվળ ͍ͨ͠ΠϯϑϥΤϯδχΞΛืू͍ͯ͠·͢ʂ XXXQJYJWDPKQ