performance-tuning-mysql

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

    View Slide

27. ղઆ
    ⾣JOOPEC@MPH@pMF@TJ[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