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

performance-tuning-mysql

mamy1326
February 22, 2017

 performance-tuning-mysql

mamy1326

February 22, 2017
Tweet

More Decks by mamy1326

Other Decks in Programming

Transcript

  1. .Z42-αʔόʔΛ
    ηϒϯηϯγζʹ
    ໨֮Ίͤ͞Δ͓࿩
    ·Έ΍ͳ͓͖ !NBNZ

    'FC !ୈճ1)1ษڧձ!౦ژ

    View Slide

  2. 8)0"3&:06
    Name    :まみやなおき
    Twitter   :@mamy1326
    好きな漫画 :CLAYMORE
    好きな謙三 :北方謙三
    好きな晃司 :吉川晃司
    好きな運昇 :石塚運昇
    好きな規夫 :若本規夫

    View Slide

  3. ࠓ೔ͷςʔϚ
    .Z42-ͷ
    খӉ஦Λ೩΍͠
    νϡʔχϯά

    View Slide

  4. ࠓ೔ͷςʔϚ
    %#αʔόʔΛ
    ηϒϯηϯγζ
    ύϑΥʔϚϯε

    ʹ໨֮Ίͤ͞Δ

    View Slide

  5. τϥϒϧ͸ಥવʹ
    ɾڭߖ
    ʮϦΫΤετ૿ՃͰαʔόʔ͕མͪͨΑ͏͕ͩʯ
    ɾࡶڕ
    ʮ%#ωοΫͳͷͰBQBDIFͷ઀ଓ਺ݮΒ͠·͠ΐ͏ʯ

    View Slide

  6. τϥϒϧ͸ಥવʹ
    ɾϑΣχοΫεҰً
    ʮ๟ཌྷఱᠳʯ
    ɾڭߖ
    ʮϦΫΤετ૿ՃͰαʔόʔ͕མͪͨΑ͏͕ͩʯ
    ɾࡶڕ
    ʮ%#ωοΫͳͷͰBQBDIFͷ઀ଓ਺ݮΒ͠·͠ΐ͏ʯ

    View Slide

  7. ֓ཁ
    %#ͷ
    -"͕௓Ͷ্͕ͬͯΔΜͰ
    ͱΓ͋͑ͣ
    8ͷ઀ଓ਺੍ݶͯ͠
    Ͳ͏ʹ͔͍ͯͨ͠

    View Slide

  8. ঢ়گ̍
    νϡʔχϯά͞Ε͍ͯͳ͍
    .Z42-
    ઐ༻αʔόʔ

    View Slide

  9. ঢ়گ̎
    ࢭ·Βͳ͍ϦΫΤετ
    Ͱ΋ඵؒ̑

    View Slide

  10. ঢ়گ̏
    ڊେͳϩάςʔϒϧ
    º̎
    ֤ສϨίʔυ

    View Slide

  11. ໨ࢦ͢
    .Z42-ͷઃఆΛ
    ͪΌΜͱཧղͯ͠
    ࠷దͳύϑΥʔϚϯεΛɻ

    View Slide

  12. ɹNZDOG֬ೝ
    ΄΅σϑΥϧτ ɾТɾA

    View Slide

  13. ɹNZDOGઃఆํ਑
    େࣄͳͱ͜Ζ͚ͩൈਮ ࣌ؒతʹͭ

    ɾڞ༗ྖҬ͔ΒςʔϒϧݸผྖҬ΁
    ɾద੾ͳϝϞϦׂΓ౰ͯ

    View Slide

  14. ɹNZDOGઃఆํ਑
    େࣄͳͱ͜Ζ͚ͩൈਮ ࣌ؒతʹͭ

    ɾڞ༗ྖҬ͔ΒςʔϒϧݸผྖҬ΁
    ɾద੾ͳϝϞϦׂΓ౰ͯ

    View Slide

  15. ɹڞ༗ྖҬͱ͸
    ɾ.Z42-ͷσϑΥϧτ͸ɺ͓͖͍ͬശͷத
    ɹͰશςʔϒϧΛऔΓѻ͍ͬͯΔ
    ɾେ͖ͳςʔϒϧ΋খ͞ͳςʔϒϧ΋ಉډ
    ɾϨίʔυͰ΋ߋ৽ʹ͕͔͔࣌ؒΔ

    View Slide

  16. ɹڞ༗ྖҬͷ࣮ྫ
    EBUBCBTF UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB

    View Slide

  17. ɹڞ༗ྖҬͷ࣮ྫ
    EBUBCBTF UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    ͜ͷϑΝΠϧʹ
    શͯͷςʔϒϧͷσʔλ͕
    ه࿥͞Ε͍ͯΔ

    View Slide

  18. ɹςʔϒϧݸผྖҬͱ͸
    ɾςʔϒϧΛ̍ͭͣͭ෼͚ͯऔΓѻ͏
    ɾେ͖ͳςʔϒϧ΋খ͞ͳςʔϒϧ΋ݸผ
    ɾߋ৽ର৅ͷςʔϒϧͷྖҬʹͷΈߋ৽͕
    ɹ͔͔ΔͨΊଞʹӨڹΛ༩͑ͳ͍

    View Slide

  19. ɹઃఆ಺༰
    ͜Μ͚ͩʂ

    View Slide

  20. ͨͩ͠ɾɾɾ
    ɾNZTRM࠶ىಈ͚ͩͰ͸
    ɹطଘͷςʔϒϧʹରͯ͠͸ద༻͞Εͳ͍
    ɾ࠶ىಈޙʹ$3&"5&
    ɹ͞ΕΔςʔϒϧʹͷΈ༗ޮ
    EVNQϦετΞ͕ඞཁ

    View Slide

  21. ɹ݁Ռ
    EBUBCBTF
    UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    WBSMJCNZTRMNBNZ

    View Slide

  22. ɹ݁Ռ
    EBUBCBTF
    UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    WBSMJCNZTRMNBNZ
    EBUBCBTF໊Ͱ
    σΟϨΫτϦ͕࡞੒͞Ε
    ςʔϒϧ͝ͱʹ
    ϑΝΠϧ͕࡞ΒΕ͍ͯΔ

    View Slide

  23. ɹNZDOGઃఆํ਑
    େࣄͳͱ͜Ζ͚ͩൈਮ ࣌ؒతʹͭ

    ɾڞ༗ྖҬ͔ΒςʔϒϧݸผྖҬ΁
    ɾద੾ͳϝϞϦׂΓ౰ͯ

    View Slide

  24. ɹϝϞϦׂΓ౰ͯͱ͸
    ɾσʔλͱJOEFY͸ϝϞϦʹΩϟογϡ
    ɾద੾ͳαΠζ͸෺ཧϝϞϦͷׂ
    ɹ ॾઆ͋Δ͕ࠓͷॴ҆ఆ

    View Slide

  25. ɹઃఆ಺༰
    ͜Μ͚ͩʂ

    View Slide

  26. ղઆ
    [email protected][email protected]@TJ[F(
    ɾσʔλͱJOEFYΛΩϟογϡ͓ͯ͘͠αΠζ
    ɾ%#αʔόʔͷ෺ཧϝϞϦ(ʹର͢Δ͓Αׂͦ
    ɾNZTRM࠶ىಈ࣌ʹׂΓ౰ͯΒΕ·͢
    ɾॻ͖ࠐΈ࣌ʹ΋ύϑΥʔϚϯε޲্͕ݟࠐ·ΕΔ
    ɹˏ.Z42-ެࣜ

    View Slide

  27. ղઆ
    [email protected]@[email protected][F(
    ɾ*OOP%#ͷߋ৽ϩάαΠζ
    ɾDPNNJU଴ͪͷϩάΛه࿥͢Δ
    ɹˠ.Z42-͸DPNNJU࣌ɺ͍ͬͨΜϩάʹه࿥͞ΕΔ
    ɾϑΝΠϧ͸γʔέϯγϟϧͳͷͰɺߋ৽͕଎͍
    ɾੵΜͩDPNNJUΛॱ࣮࣍σʔλʹ൓ө͢Δ

    View Slide

  28. ͦͷଞͷઃఆ
    ⾣εϩʔΫΤϦϩάؔ࿈
    ׂѪʂ
    ه࿥ͯ͠؂ࢹ͢ΔΑ͏
    ઃఆ͠Α͏ʂ

    View Slide

  29. ͦͷଞͷઃఆ
    ⾣ΫΤϦΩϟογϡؔ࿈
    ׂѪʂ
    ಉҰΫΤϦ͸Ωϟογϡ͔
    Βฦ͢Α͏ઃఆ͠Α͏ʂ
    ˞ॾઆ͋Γ

    View Slide

  30. ͦͷଞͷઃఆ
    ⾣εϨουΩϟογϡؔ࿈
    ׂѪʂ
    ଟ͗͢Δͱอ࣋͗͢͠Δ
    ͔Β஫ҙͩͧʂ

    View Slide

  31. ࠷ऴ݁Ռ
    ⾣ඵؒϦΫΤετʂ
    ⾣ϝϞϦ͕ੵ·Εͨ෼͚ͩՔಇʂ
    ⾣ςʔϒϧݸผͰߋ৽ܥ͕ૣ͘ʂ
    ⾣JOEFYݟ௚͠ͰεϩʔΫΤϦ๾໓ʂ
    ɹ ͍ͭͰʹ

    View Slide

  32. ·ͱΊ
    ⾣αʔϏεʹԠͯ͡ద੾ʹઃఆʂ
    ⾣σϑΥϧτμϝʂθολΠʂ
    ⾣ઃఆޙͷ਺஋͸ఆظతʹ؂ࢹʂ
    ɹˠνϡʔχϯά͸ܧଓ໋͕ʂ
    ⾣ςʔϒϧઃܭ͸ܭըతʹʂ

    View Slide

  33. ऴΘΓʹ
    ܅͸খӉ஦ʢίεϞʣΛ
    ײͨ͜͡ͱ͕͋Δ͔

    View Slide

  34. ऴΘΓʹ
    ΞϓϦΤϯδχΞ͔ͩΒͬͯ
    ΠϯϑϥΛ
    ଞਓ೚ͤʹ͠ͳ͍

    View Slide

  35. ऴΘΓʹ
    ࠓ͍ΔੈքΛ޿͛Δ͜ͱ͸
    ΤϯδχΞਓੜͷ޿͕Γ
    Λҙຯ͢Δ

    View Slide

  36. ऴΘΓʹ
    ޿͍ੈք͸ָ͍ͧ͠ʂ

    View Slide

  37. ऴΘΓʹ
    ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ

    View Slide

  38. وَ "QQFOEJY

    ⾣ݩهࣄͷ͝঺հ
    ɹ.Z42-ύϑΥʔϚϯενϡʔχϯά
    ɹɹNZDOGͷݟ௚͠
    ɹIUUQRJJUBDPNNBNZJUFNTDFBFFDD⒎B

    View Slide