MHAでデータベースの運用を楽にしよう！

Transcript

1. ٱถ୓അ
   
   (.0
   1&1"#0
   JOD
   ϗε5FDI
   .5(
    .)"Ͱσʔλϕʔεӡ༻Λ
   ָʹ͠Α͏ʂ 

2. ΠϯϑϥΤϯδχΞ ٱถ୓അ
   !UBLVNBLVNF ϗεςΟϯάࣄۀ෦ΠϯϑϥνʔϜ 

3. .)"ͱ͸ʁ 

4. .)"ͱ͸ʁ w.Z42-
   ΤΩεύʔτͱͯ͠ੈքతʹ΋༗໊ͳদ৴ՅൣࢯʹΑΔɺ .Z42-
   Ϛελʔͷ
   ৑௕ԽΛߦ͏ͨΊͷ1FSM੡ͷιϑτ΢ΣΞɻ
   w਺ඵͷμ΢ϯλΠϜͰɺσʔλͷ੔߹ੑΛอͪͭͭɺϚελʔαʔ όͷϑΣΠϧΦʔόΛߦ͏ػೳΛ΋͍ͬͯΔɻ (JUIVC
   IUUQTHJUIVCDPNZPTIJOPSJNNIBNZTRMNBOBHFS
   IUUQTHJUIVCDPNZPTIJOPSJNNIBNZTRMOPEF 

5. Զ͸σʔλϕʔεͷഒ
   ௼Γ͕޷͖ͩʂʂʂ 

6. ͱ͍͏͜ͱͰ 

7. Ϛελʔσʔλϕʔεͷো֐ʹΑͬͯ w͓٬༷ʹఏڙ͍ͯ͠ΔαʔϏεΛࢭΊͨ͘ͳ͍ʂ
   w ͍ͭͰʹɺ௼ΓΛָ͠ΜͰ͍Δͱ͜ΖΛअຐ͞Εͨ͘ͳ͍ʂ 

8. Ϛελʔσʔλϕʔεͷো֐ʹΑͬͯ w͓٬༷ʹఏڙ͍ͯ͠ΔαʔϏεΛࢭΊͨ͘ͳ͍ʂ
   w ͍ͭͰʹɺ௼ΓΛָ͠ΜͰ͍Δͱ͜ΖΛअຐ͞Εͨ͘ͳ͍ʂ 

9. ͱ͍͏ײ͡ͷϞνϕʔγϣϯͰ
   .)"ͷಋೖΛߦ͍·ͨ͠ʂ 

10. ຊ೔ͷ಺༰ 
    લఏ஌ࣝ
    ɾϚελʔσʔλϕʔεͷো֐ରԠ͕ਏ͍͜ͱͷڞ༗
    
    ϝΠϯͷ͓͸ͳ͠
    ɾͦΕΛղܾ͢Δ.)"ͷಈ࡞ͷ࢓૊Έ
    
    ͓ΘΓ
    ɾࠓޙʹ͍ͭͯ

11. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢ 

12. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢ NBTUFS TMBWF TMBWF "QQMJDBUJPO ॻ͖ࠐΈ ಉظ ಉظ ௨ৗ࣌ 

13. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢ NBTUFS TMBWF TMBWF "QQMJDBUJPO ॻ͖ࠐΈ େ੾ͳߋ৽ॲཧ͕ࢭ·Δ ো֐ൃੜʂ ো֐ൃੜ 

14. ͔͜͜Β෮چ࡞ۀ͕࢝·Δ 

15. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢ NBTUFS TMBWF TMBWF "QQMJDBUJPO σʔλ͕൪৽͍͠αʔόΛબͿ ৽Ϛελʔબఆ 

16. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢ NBTUFS NBTUFS TMBWF "QQMJDBUJPO σʔλͷ੔߹ੑΛ߹ΘͤΔ ৽NBTUFS
    TMBWFؒͷ
    σʔλͷ੔߹ੑΛ߹ΘͤΔ 

    σʔλྔʹԠ͕͔͔ͯ࣌ؒ͡Δ࡞ۀ

17. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢ NBTUFS NBTUFS TMBWF "QQMJDBUJPO εϨʔϒಉظΛ։࢝ ಉظ 

18. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢ NBTUFS NBTUFS TMBWF "QQMJDBUJPO ΞϓϦέʔγϣϯ͸
    ॻ͖ࠐΈΛ࠶։ ॻ͖ࠐΈ࠶։ ಉظ 

19. ͜ͷҰ࿈ͷ࡞ۀΛٸ͍Ͱ
    ߦΘͳ͚Ε͹ͳΒͳ͍ 

20. େมͰ͢Ͷʜ 

21. खಈ෮چͷ໰୊఺ wਓ͕ରԠ͢ΔͨΊҎԼΛڐ༰͠ͳ͚Ε͹ͳΒͳ͍
    wো֐ݕ஌ˠΤεΧϨʔγϣϯˠݱঢ়֬ೝˠରԠ։࢝
    wλΠϜϥά͕ൃੜ͢Δɻͦͷؒ͸αʔϏεஅɻ
    wϛεΦϖϨʔγϣϯʹΑΔσʔλϩετͷةݥ
    w໷ؒͳͲʹى͖Δ͜ͱ΋͋ΔͷͰ୲౰ऀ͕ർฐ͢Δ 

22. खಈ෮چͷ໰୊఺ wਓ͕ରԠ͢ΔͨΊҎԼΛڐ༰͠ͳ͚Ε͹ͳΒͳ͍
    wো֐ݕ஌ˠΤεΧϨʔγϣϯˠݱঢ়֬ೝˠରԠ։࢝
    wλΠϜϥά͕ൃੜ͢Δɻͦͷؒ͸αʔϏεஅɻ
    wϛεΦϖϨʔγϣϯʹΑΔσʔλϩετͷةݥ
    w໷ؒͳͲʹى͖Δ͜ͱ΋͋ΔͷͰ୲౰ऀ͕ർฐ͢Δ
    w୲౰ऀ͕௼ΓΛָ͠ΜͰ͍Δ͔΋͠Εͳ͍ɻ 

23. ͦΕΛղܾ͢Δҝʹ.)"Λಋೖͨ͠ʂ 

24. .)"͸ো֐ݕ஌͔Β෮چ·ͰͷҰ࿈ͷ
    ྲྀΕΛࣗಈͰߦͬͯ͘ΕΔιϑτ΢ΣΞɻ 

25. ຊ೔͸.)"ͷಈ࡞ͷ࢓૊Έʹ͍ͭͯ
    આ໌͍ͨ͠ͱࢥ͍·͢ʂ 

26. ߏ੒ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ϔϧενΣοΫ ࠷௿ϊʔυ  Ϛελʔʹো֐͕ى͖Ε͹ࣗಈͰ
    ผͷαʔόʹ੾Γସ͑Δ

27. Ҏ߱ͷઆ໌ .)"ͷओͳҎԼͷػೳʹ͍ͭͯॱʹઆ໌͠·͢ɻ
    ɾϔϧενΣοΫ
    ɾσʔλͷ੔߹ੑͷΩʔϓ
    ɾϑΣΠϧΦʔόʔ 

28. ϔϧενΣοΫ ɾNBTUFSσʔλϕʔε͕ࢀর΋͘͠͸ॻ͖ࠐΈͰ͖Δঢ়ଶͰ͋Δ͔
    ɹΛνΣοΫ͢Δɻ NIBNBOBHFSNIBOPEF<.BTUFS> 

29. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH ʢ.BTUFS͔ΒૹΒΕ͖ͯͨσʔλͰσʔλϕʔεʹॻ͖ࠐ·Ε͍ͯͳ͍΋ͷʣ 

30. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH Ϛελʔσʔλϕʔεʹো֐ൃੜʂ 

31. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH ൪σʔλ͕.BTUFSʹ͍ۙαʔόΛ
    ৽Ϛελʔʹબఆ 

32. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH  ৽Ϛελʔʹબఆ

33. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH Ͳͷ4MBWFʹ΋సૹ͞Ε͍ͯͳ͍σʔλ͸ϩετ 

34. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH .BTUFS ৽ϚελʔͷSFMBZMPH͕શͯద༻͞ΕΔ·Ͱ
    NIBNBOBHFS͸଴ػ

    

35. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH .BTUFS 4MBWFʹ଍Γͳ͍σʔλΛ4$1Ͱసૹ͢Δ 

36. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH .BTUFS SFMBZMPHΛద༻ 

37. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH .BTUFS σʔλͷ੔߹ੑ͕อͨΕΔ 

38. ϑΣΠϧΦʔόʔ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ো֐ൃੜ ݕ஌ʂ  "QQT

39. ϑΣΠϧΦʔόʔ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    Ϛελʔબఆ  "QQT

40. ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ੔߹ੑͷΩʔϓ  "QQT

41. ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ಉظ։࢝ ಉظ։࢝  "QQT

42. ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ಉظ։࢝ ಉظ։࢝  "QQT ⾨
    ͜Ε͚ͩͰ͸ΞϓϦέʔγϣϯ͕ݹ͍ϚελʔΛࢀর͍ͯ͠Δঢ়ଶ

43. ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ಉظ ಉظ ϑΣΠϧΦʔόʔ࣌ʹ.)"ͷػೳͰ೚ҙͷ
    εΫϦϓτΛ࣮ߦͰ͖Δʂ  "QQT

44. ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ಉظ ಉظ όʔνϟϧ*1 όʔνϟϧ*1ΞυϨεΛ༧Ί෇༩͓͖ͯ͠ɺεΫϦϓτͰ৽ϚελʔʹҠಈͤͯ͞
    ΞϓϦέʔγϣϯ͕ϚελʔͷࢀরઌΛม͑ͳͯ͘ྑ͍Α͏ʹ͢Δɻ  "QQT

45. ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ಉظ ಉظ όʔνϟϧ*1  "QQT ⾨
    ΞϓϦέʔγϣϯ͸৽͍͠ϚελʔΛࣗಈతʹࢀর͢Δ

46. ͦͷଞͷػೳ ɾࣗಈϑΣΠϧΦʔό࣌ͷ௨஌ػೳ
    ɾखಈͰͷϚελʔ੾ସ͑ػೳ
    ɹˠ
    σʔλϕʔεͷϝϯςφϯεָ͕ʹͳΔʂ
    ɾεϨʔϒຖʹϚελʔঢ֨ީิͷઃఆ͕Ͱ͖Δɻ
    ɹˠ
    όοΫΞοϓ༻్ͷαʔό͸Ϛελʔʹঢ֨ͤ͞ͳ͍
    ɹɹ
    ͳͲͷӡ༻͕Մೳɻ 

47. .)"͸طଘͷ.Z42-ͷఀࢭΛ
    ൐Θͣʹಋೖ͢Δ͜ͱ͕Ͱ͖ΔͷͰ
    ඇৗʹಋೖͷෑډ͕௿͍Ͱ͢ʂ 

48. ୆ͷNIBNBOBHFSͰෳ਺ͷ
    γεςϜΛ؅ཧ͢Δ͜ͱ͕Ͱ͖·͢ʂ 

49. ʲࢀߟʳ.)"Λಋೖ͢ΔͨΊͷલఏ৚݅ w֤ϊʔυؒͰͷ
    44)
    ެ։伴ೝূ͕Ͱ͖Δ͜ͱ
    w.Z42-
    
    Ҏ߱ͷΈαϙʔτ
    wϚελʔঢ֨ީิͷαʔόͰ
    MPHCJO
    ͕
    FOBCMF
    ʹͳͬͯΔ͜ͱ
    wSFMBZ@MPH@QVSHFΛແޮʹ͓ͯ͘͠ඞཁ
    wཧ༝͸ɺϑΣΠϧΦʔό࣌ʹ࠷৽ͷ4MBWFͷSFMBZ@MPHΛݹ͍4MBWFʹసૹ͠ ͯ੔߹ੑΛ୲อ͢ΔͨΊɻ
    w Ϛελʔঢ֨ީิαʔόʹϨϓϦέʔγϣϯ༻Ϣʔβ͕ଘࡏ͢Δ͜ͱ
    w

    εςʔτϝϯτϕʔεͷϨϓϦέʔγϣϯͰ͸
    -0"%
    %"5"
    */'*-&
    Λ࢖༻ͯ͠͸ ͍͚ͳ͍ 

50. ϖύϘͰ͸ɺ͓ͬ͘Μ͞Μ !IGN ͕
    EBZT
    "MCVN
    ʹઌߦಋೖ͍ͯͨ͠ͷͰ
    ஌ݟΛڞ༗௖͖ɺඇৗʹָʹಋೖͰ͖·ͨ͠ʂ
    ʢ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂʣ 

51. ࠓޙʹ͍ͭͯ ɾ·ͩ.)"͕ಋೖ͞Ε͍ͯͳ͍γεςϜ͕ෳ਺͋ΔͷͰɺ
    ɹ࣮੷ΛੵΈͭͭਵ࣌ಋೖΛ޿͍͖͍͛ͯͨͱࢥ͍·͢ɻ 

52. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ