Upgrade to Pro — share decks privately, control downloads, hide ads and more …

pixivにおけるMySQL運用の実際

konoiz
February 23, 2018

 pixivにおけるMySQL運用の実際

MySQL Trend Seminar 2018 @ 福岡

konoiz

February 23, 2018
Tweet

More Decks by konoiz

Other Decks in Technology

Transcript

  1. 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 BQBDIF QIQ 4FBSDI4FSWFS
 4PMS TFBSDI JNQPSU *NBHF %JTQBUDIFS
 OHJOY
  2. 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 BQBDIF QIQ 4FBSDI4FSWFS
 4PMS TFBSDI JNQPSU *NBHF %JTQBUDIFS
 OHJOY
  3. -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 BQBDIF QIQ
  4. .BTUFSঢ֨ -PBE#BMBODFS
 -74 .Z42- NBTUFS .Z42- TMBWF XSJUF SFQMJDBUJPO SFBE

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

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

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

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

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

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

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

    QIQ .Z42- TMBWF     SFQMJDBUJPO Ծ૝*1 ࣮*1 SFBE
  12. *%CJHJOU ฒྻ*/4&354&-&$5 *%JOU  ʜ   ʜ  

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

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

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

    *%JOU  ʜ   ʜ   ʜ   ʜ   ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5
  16. *%CJHJOU  ʜ   ʜ   ʜ 

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