images_with_mysql_merit_demerit_and_troubleshooting

PHPカンファレンス 2017で話す予定だった「MySQLで画像を扱うメリット・デメリットと特殊パターン」を改題し、「MySQLで画像 を扱うメリット・デメリットと障害・解決事例」として、第119回 PHP勉強会＠東京で登壇した際のスライドです。

Transcript

1. .Z42-Ͱը૾
   Λѻ͏
   ϝϦοτɾσϝϦοτͱ
   ো֐ɾղܾࣄྫ
   ·Έ΍ͳ͓͖
   !NBNZ
   
   0DU
   
   !QIQDPO
   
   0DU
   
   ୈճ
   1)1ษڧձˏ౦ژ
   
2. Ξ΢τϓοτͷ
   ͖͔͚ͬ
3. ͖͔͚ͬ ⾣UFSBUBJMͰ౴͑ͨ
   
   
   
   
   
   IUUQTUFSBUBJMDPNRVFTUJPOT
4. ͖͔͚ͬ ⾣ϕετΞϯαʔʹͳͬͨ
5. ͖͔͚ͬ ⾣5XJUUFSʹ౤ߘͨ͠
6. ͖͔͚ͬ ⾣ΊͬͪΌ੝Γ্͕ͬͨ
7. ͖͔͚ͬ ⾣·ͱΊͨ
   IUUQTUPHFUUFSDPNMJ
8. ͏͔ͬΓը૾Λ
   3%#
   ʹಥͬࠐΜͩ
   ͹͔Γʹ
9. ࣮ࡍʹ
   ۤ࿑ͨ͠࿩
   Λ
   ަ͑ͯ
10. 3%#
    .Z42-
    Ͱ
    ը૾Λѻ͏
11. 
    ϝϦοτ
    "
    ˍ
    
    σϝϦοτ
    $
12. Կ͕
    μϝ
    ͳͷ͔
13. Կ͕
    ϕετ
    ͳͷ͔
    Λߟ͑
14. ద੾ʹ
    ը૾Λ
    ѻ͏جຊΛ
    ͓࿩͠͠·͢
15. ͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ ࣮ࡍͷॻ͖ࠐΈ଎౓ɾσʔλྔ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ
16. ͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ ࣮ࡍͷॻ͖ࠐΈ଎౓ɾσʔλྔ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ
17. ࣗݾ঺հ ▶︎ ΦϥΫΕͳ͍ ▶︎ ϙεάΕͳ͍ ϫλγνϣοτμέ
    ϚΠΤεΩϡʔΤΔ
18. ࣗݾ঺հ ▶︎ ΦϥΫΕͳ͍ ▶︎ ϙεάΕͳ͍ ϫλγνϣοτμέ
    ϚΠΤεΩϡʔΤΔ
19. ࣗݾ঺հ Name ɿ·Έ΍ͳ͓͖ ॴଐɹ ɿInnovator Japan Inc. Twitterɿ@mamy1326 - ීஈ͸PHPॻ͍ͯ·͢ - 2017೥1݄ʹॳΊͯmy.cnfΛ৮Δ - ࠓ೥1೥ MySQLΛझຯʹͯ͠ΈΔ
20. ͱ͜ΖͰ
    Έͳ͞Μ
21. ը૾Λ3%#ʹ
    ΩϟοΩϟ΢ϑϑ
    Ҋ݅
22. ܦݧͨ͜͠ͱ
    ͋Γ·͔͢ʁ
    ڍख✋
23. ๻͸͋Γ·͢ʂ
24. ͨͱ͑͹ʜ
    ͱ͋Δෆಈ࢈γεςϜ
    ෺݅ը૾Λશ෦
    ΧϥϜʹೖΕΔ
25. ͭΒ͍
26. Ͱ΋
    ඞཁͳ࣌͸
    ͋Δ͔΋͠Εͳ͍
27. Զ͕ࢮΜͩΒʜ
    ͋ͷൿଂͷը૾
    ϑΥϧμΛʜ
28. ࡟আͯ͠ʜ
    ͓͔ʜͶ͹ʜ
    ŰƄŦŕ@ 
    ʯ㲃 @
29. Ͱ΋҆৺
    ͓ๅը૾
    %#ͷதͳΒͶ
30. ͑ʁ
    ͦΕͰ͍͍ͷʁ
31. ͓લͷ
    αʔϏεͳΒͳ
32. ͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ ࣮ࡍͷॻ͖ࠐΈ଎౓ɾσʔλྔ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ
34. %#͔Β
    ը૾Λ4&-&$5
    ʢ֎؍ɺ಺૷ɺؒऔɺपลʣ
35. ಥવͷ
    ͓٬͞·͔Βͷ
    ͓໰͍߹Θͤ
36. ͋Δ೔ͷ͓໰͍߹Θͤ ☎ɿ෺݅σʔλొ࿥ͨ͠Βɺ
    ɹɹը໘͕ਅͬനʹͳΔΜͰ͚͢Ͳ ɿը໘Ωϟϓνϟૹͬͯ௖͍ͯ΋
    ɹɹΑΖ͍͠Ͱ͔͢ʁ
37. ͋Δ೔ͷ͓໰͍߹Θͤ ը໘
    ਅͬന
38. ͋Δ೔ͷ͓໰͍߹Θͤ ը໘
    ਅͬന λΠϜΞ΢τ
39. ࣮ࡍʹى͖ͨτϥϒϧ ⾣େ͖ͳαΠζͷը૾ΛΞοϓϩʔυ
    ɹˠεϚϗɺσδΧϝ͔Βͦͷ··
    ⾣ෳ਺ຕΛҰ౓ʹΞοϓϩʔυ
    ɹˠ෺݅ͷը૾਺͕ଟ͍
    ⾣ϦΫΤετ͕ଟൃ
    ɹˠൟ๩ظʹूதɺෳ਺ళฮͰൃੜ
40. ͸ͯ
    
    ςʔϒϧߏ੒ݟΔ͔ʜ
41. mysql> show create table bukken\G *************************** 1. row *************************** Table: bukken Create Table: CREATE TABLE `bukken` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `gaikan_01` mediumblob NOT NULL, `gaikan_02` mediumblob, `gaikan_03` mediumblob, `gaikan_04` mediumblob, `gaikan_05` mediumblob, `gaikan_06` mediumblob, `gaikan_07` mediumblob, `gaikan_08` mediumblob, `gaikan_09` mediumblob, `gaikan_10` mediumblob, `madori_01` mediumblob NOT NULL, `naiso_01` mediumblob NOT NULL, `naiso_02` mediumblob, `naiso_03` mediumblob, `naiso_04` mediumblob, `naiso_05` mediumblob, `naiso_06` mediumblob, `naiso_07` mediumblob, `naiso_08` mediumblob, `naiso_09` mediumblob, `naiso_10` mediumblob, `syuhen_01` mediumblob NOT NULL, `syuhen_02` mediumblob, `syuhen_03` mediumblob, `syuhen_04` mediumblob, `syuhen_05` mediumblob, `syuhen_06` mediumblob, `syuhen_07` mediumblob, `syuhen_08` mediumblob, `syuhen_09` mediumblob, `syuhen_10` mediumblob, `panorama` mediumblob, `gaikan_s_01` mediumblob NOT NULL, `gaikan_s_02` mediumblob, `gaikan_s_03` mediumblob, `gaikan_s_04` mediumblob, `gaikan_s_05` mediumblob, `gaikan_s_06` mediumblob, `gaikan_s_07` mediumblob, `gaikan_s_08` mediumblob, `gaikan_s_09` mediumblob, `gaikan_s_10` mediumblob, `madori_s_01` mediumblob NOT NULL, `naiso_s_01` mediumblob NOT NULL, `naiso_s_02` mediumblob, `naiso_s_03` mediumblob, `naiso_s_04` mediumblob, `naiso_s_05` mediumblob, `naiso_s_06` mediumblob, `naiso_s_07` mediumblob, `naiso_s_08` mediumblob, `naiso_s_09` mediumblob, `naiso_s_10` mediumblob, `syuhen_s_01` mediumblob NOT NULL, `syuhen_s_02` mediumblob, `syuhen_s_03` mediumblob, `syuhen_s_04` mediumblob, `syuhen_s_05` mediumblob, `syuhen_s_06` mediumblob, `syuhen_s_07` mediumblob, `syuhen_s_08` mediumblob, `syuhen_s_09` mediumblob, `syuhen_s_10` mediumblob, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 1 row in set (0.00 sec) ͑ʁ
42. ςʔϒϧߏ੒
     mysql> show create table bukken\G ****************** 1. row ****************** Table: bukken Create Table: CREATE TABLE `bukken` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, ⾣ʮͪΌΜͱʯ֬ೝͯ͠ΈΔ
43. ςʔϒϧߏ੒
     `gaikan_01` mediumblob NOT NULL, `gaikan_02` mediumblob, `gaikan_03` mediumblob, `gaikan_04` mediumblob, `gaikan_05` mediumblob, `gaikan_06` mediumblob, `gaikan_07` mediumblob, `gaikan_08` mediumblob, `gaikan_09` mediumblob, `gaikan_10` mediumblob,
44. ςʔϒϧߏ੒
     `madori_01` mediumblob NOT NULL, `naiso_01` mediumblob NOT NULL, `naiso_02` mediumblob, `naiso_03` mediumblob, `naiso_04` mediumblob, `naiso_05` mediumblob, `naiso_06` mediumblob, `naiso_07` mediumblob, `naiso_08` mediumblob, `naiso_09` mediumblob, `naiso_10` mediumblob,
45. ςʔϒϧߏ੒
     `syuhen_01` mediumblob NOT NULL, `syuhen_02` mediumblob, `syuhen_03` mediumblob, `syuhen_04` mediumblob, `syuhen_05` mediumblob, `syuhen_06` mediumblob, `syuhen_07` mediumblob, `syuhen_08` mediumblob, `syuhen_09` mediumblob, `syuhen_10` mediumblob, `panorama` mediumblob,
46. ςʔϒϧߏ੒
     `gaikan_s_01` mediumblob NOT NULL, `gaikan_s_02` mediumblob, `gaikan_s_03` mediumblob, `gaikan_s_04` mediumblob, `gaikan_s_05` mediumblob, `gaikan_s_06` mediumblob, `gaikan_s_07` mediumblob, `gaikan_s_08` mediumblob, `gaikan_s_09` mediumblob, `gaikan_s_10` mediumblob,
47. ςʔϒϧߏ੒
     `madori_s_01` mediumblob NOT NULL, `naiso_s_01` mediumblob NOT NULL, `naiso_s_02` mediumblob, `naiso_s_03` mediumblob, `naiso_s_04` mediumblob, `naiso_s_05` mediumblob, `naiso_s_06` mediumblob, `naiso_s_07` mediumblob, `naiso_s_08` mediumblob, `naiso_s_09` mediumblob, `naiso_s_10` mediumblob,
48. ςʔϒϧߏ੒
     `syuhen_s_01` mediumblob NOT NULL, `syuhen_s_02` mediumblob, `syuhen_s_03` mediumblob, `syuhen_s_04` mediumblob, `syuhen_s_05` mediumblob, `syuhen_s_06` mediumblob, `syuhen_s_07` mediumblob, `syuhen_s_08` mediumblob, `syuhen_s_09` mediumblob, `syuhen_s_10` mediumblob, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7687528 DEFAULT CHARSET=utf8mb4 1 row in set (0.00 sec)
49. ςʔϒϧߏ੒
     `syuhen_s_01` mediumblob NOT NULL, `syuhen_s_02` mediumblob, `syuhen_s_03` mediumblob, `syuhen_s_04` mediumblob, `syuhen_s_05` mediumblob, `syuhen_s_06` mediumblob, `syuhen_s_07` mediumblob, `syuhen_s_08` mediumblob, `syuhen_s_09` mediumblob, `syuhen_s_10` mediumblob, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7687528 DEFAULT CHARSET=utf8mb4 1 row in set (0.00 sec) όΠφϦσʔλ
    อଘ༻ΧϥϜ
50. ͳΜͱ͜Ε
    શ෦
    3%#
    ʹ
    ͋ΔΜͰ͢Αʢ਒͑੠
51. ࣮ࡍͷͱ͜Ζ
    ͲΜͳ։ൃ͔ͩͬͨ
52. ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ⾣։ൃ͍ͯͨ͠؀ڥ 8FC %# ΫϥΠΞϯτ
53. ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ͏Μɺେৎ෉ʂ ⾣։ൃ͍ͯͨ͠؀ڥ 8FC %# ΫϥΠΞϯτ
54. ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ⾣࣮ࡍͷ؀ڥ 8FC %#
55. ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ⾣࣮ࡍͷ؀ڥ ❌ ωοτϫʔΫ 8FC %#
56. ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ⾣࣮ࡍͷ؀ڥ ϓϩηε 8FC %# ❌
57. ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ⾣࣮ࡍͷ؀ڥ ❌ λΠϜΞ΢τ 8FC %#
58. ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ɾେ͖ͳը૾͸Ξοϓ͠ͳ͍ͩΖ͏
    ɾ͍ͬ΃ΜʹΞοϓ͠ͳ͍ͩΖ͏
    ɾେ੎ͰΞοϓ͠ͳ͍ͩΖ͏
    ɾ༰ྔ͸͙͢ʹᷓΕͳ͍ͩΖ͏
    ɾ৑௕ԽʁΑ͘Θ͔Μͳ͍
    ɾࠔͬͨΒεέʔϧΞοϓ͢Ε͹ʁ
59. ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ɾେ͖ͳը૾͸Ξοϓ͠ͳ͍ͩΖ͏
    ɾ͍ͬ΃ΜʹΞοϓ͠ͳ͍ͩΖ͏
    ɾେ੎ͰΞοϓ͠ͳ͍ͩΖ͏
    ɾ༰ྔ͸͙͢ʹᷓΕͳ͍ͩΖ͏
    ɾ৑௕ԽʁΑ͘Θ͔Μͳ͍
    ɾࠔͬͨΒεέʔϧΞοϓ͢Ε͹ʁ ❌
60. Ͱ͸
    Ͳ͏΍ͬͯ
    ղܾ͢Δ͔
61. ղܾࡦ ⾣ॲཧͰ͖ΔσʔλྔΛ੍ݶ
    ɹˠׂͱ͙͢ରԠͰ͖Δ͕࢑ఆత
    ⾣Ϣʔβʔ਺Λ੍ݶ
    ɹˠαʔϏεͰ͋ΔҎ্೉͍͠
    ⾣؂ࢹ͢Δ
    ɹˠେ੾͕ͩࠜຊղܾͰ͸ͳ͍
    ⾣%#ॲཧΛվળ͢Δ
    ɹˠ໌Β͔ͳωοΫΛࠜຊղܾ
62. ղܾࡦ ⾣ॲཧͰ͖ΔσʔλྔΛ੍ݶ
    ɹˠׂͱ͙͢ରԠͰ͖Δ͕࢑ఆత
    ⾣Ϣʔβʔ਺Λ੍ݶ
    ɹˠαʔϏεͰ͋ΔҎ্೉͍͠
    ⾣؂ࢹ͢Δ
    ɹˠେ੾͕ͩࠜຊղܾͰ͸ͳ͍
    ⾣%#ॲཧΛվળ͢Δ
    ɹˠ໌Β͔ͳωοΫΛࠜຊղܾ ࢑ఆରԠͰ
    ࠜຊղܾͰ͖ͳ͍
63. ղܾࡦ ⾣ॲཧͰ͖ΔσʔλྔΛ੍ݶ
    ɹˠׂͱ͙͢ରԠͰ͖Δ͕࢑ఆత
    ⾣Ϣʔβʔ਺Λ੍ݶ
    ɹˠαʔϏεͰ͋ΔҎ্೉͍͠
    ⾣؂ࢹ͢Δ
    ɹˠେ੾͕ͩࠜຊղܾͰ͸ͳ͍
    ⾣%#ॲཧΛվળ͢Δ
    ɹˠ໌Β͔ͳωοΫΛࠜຊղܾ ࠜຊղܾ
    ͍ͯ͘͠
64. ࠜຊղܾ·Ͱͷ
    ಓͷΓ
65. ࠜຊղܾ·ͰͷಓͷΓ ⾣ͭͷϑΣʔζ
    ɾը૾Λ3%#͔Β੾Γ཭͢
    ɾ3%#΁ͷόΠφϦొ࿥ഇࢭ
    ɾ׬શҠߦ·Ͱͷ࢓૊ΈߟҊ
66. ϑΣʔζᶃ ⾣ը૾Λ3%#͔Β੾Γ཭͢
    ɾը૾ϑΝΠϧ໊Λอଘ͢Δςʔϒϧ༻ҙ
    ɾ%PDVNFOU3PPUʹը૾อଘ͢ΔॲཧΛ௥Ճ
    ɾϑΝΠϧ໊Λ3%#ʹอଘ
    ৽نొ࿥ɾมߋը૾Λ
    %PDVNFOU3PPUʹ഑ஔ
67. ϑΣʔζᶄ ⾣3%#΁ͷόΠφϦొ࿥ॲཧΛഇࢭ
    ɾը૾อଘϧʔϧΛܾΊΔʢϑΝΠϧ໊ͳͲʣ
    ɾॲཧ੾Γସ͑ͷͨΊϝϯςφϯε
    ɾ3%#ʹొ࿥͍ͯͨ͠ॲཧΛ׬શʹഇࢭ
    3%#Ͱͷ
    ը૾૿ՃΛఀࢭ
68. ϑΣʔζᶄ ⾣3%#΁ͷόΠφϦొ࿥ॲཧΛഇࢭ
    ɾը૾อଘϧʔϧΛܾΊΔʢϑΝΠϧ໊ͳͲʣ
    ɾॲཧ੾Γସ͑ͷͨΊϝϯςφϯε
    ɾ3%#ʹొ࿥͍ͯͨ͠ॲཧΛ׬શʹഇࢭ
    3%#Ͱͷ
    ը૾૿ՃΛఀࢭ ߋ৽ॲཧͷ
    λΠϜΞ΢τΛ
    ৯͍ࢭΊΔ
69. ϑΣʔζᶅ ⾣׬શҠߦ·Ͱͷ࢓૊ΈߟҊ
    ɾ3%#ը૾ΛόονͰ%PDVNFOU3PPU΁
    ɾ%PDVNFOU3PPUʹແ͚Ε͹3%#͔ΒಡΉ
    ɾ׬શʹҠߦ͕ऴΘΔ࣌ؒΛܭࢉ
    ܭըతʹը૾Λ
    %PDVNFOU3PPUʹҠߦ
70. ϑΣʔζᶅ ⾣׬શҠߦ·Ͱͷ࢓૊ΈߟҊ
    ɾ3%#ը૾ΛόονͰ%PDVNFOU3PPU΁
    ɾ%PDVNFOU3PPUʹແ͚Ε͹3%#͔ΒಡΉ
    ɾ׬શʹҠߦ͕ऴΘΔ࣌ؒΛܭࢉ
    ܭըతʹը૾Λ
    %PDVNFOU3PPUʹҠߦ ҠߦظؒΛ
    εέδϡʔϦϯά
71. ղܾ·ͰͷৼΓฦΓ ⾣අ༻ͱظ͕ؒ๲େʹ͔͔Δ
    ⾣αʔϏε͕ఀࢭ͢Δ
    ⾣ӡ༻ޙͰࣦഊ͕ڐ͞Εͳ͍
    ⾣৴༻͕ࣦ௢͢Δ
72. ͜Ε͕
    ϕετ͔Ͳ͏͔
    ະͩʹ౴͕͑ग़·ͤΜ͕
73. ͜Ε͚ͩؤுͬͯ΋
    ద੾ʹ
    ৼΓฦΒͳ͚Ε͹
74. ͳΜʹ΋ͳΒͳ͍
75. ͱ͍͏Θ͚Ͱ
76. ͠ΜͲ͍
    ӡ༻ʹ
    ͳΒͳ͍ͨΊʜ
77. ࠓ೔͔ΒΘ͔Δ
    ϝϦοτɾσϝϦοτ
78. ͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ ࣮ࡍͷॻ͖ࠐΈ଎౓ɾσʔλྔ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ
79. ϝϦοτ
80. ϝϦοτ ▶︎ τϥϯβΫγϣϯͷԸܙ ▶︎ ҉߸ԽͱηΩϡϦςΟ ▶︎ όοΫΞοϓͷू໿ੑ ▶︎ ؂ࠪʢཤྺʣͷ౷߹తͳ࣮૷
81. τϥϯβΫγϣϯͷԸܙ ⾣ϑΝϯτϜϑΝΠϧͷճආ
    ɹˠSPMMCBDLͰҰൃͰͳ͔ͬͨ͜ͱʹ
    ϑΝΠϧͱ%#͕
    
    ಉ͡τϥϯβΫγϣϯͰ੍ޚ
82. ҉߸ԽͱηΩϡϦςΟ ⾣ඇৗʹηϯγςΟϒͳը૾
    ɹˠΧϧςʹఴ෇͢Δը૾ͳͲ
    ҉߸ԽɾηΩϡΞ
    ʹ
    औΓѻ͏
83. όοΫΞοϓͷू໿ੑ ⾣%#όοΫΞοϓͱಉ࣌ʹ
    ɹˠը૾΋όοΫΞοϓ͞ΕΔ
    %#ϦετΞ΍ผγεςϜͱͯ͠ͷ
    ؀ڥߏஙָ͕
84. ؂ࠪ ཤྺ ͷ౷߹తͳ࣮૷ ⾣ը૾ͷߋ৽ཤྺΛऔΓ͍ͨ
    ɹˠόʔδϣϯ؅ཧ΋͍ͨ͠
    ύϑΥʔϚϯεΛ٘ਜ਼
    ʹͯ͠΋
    ࣮૷͍ͨ͠ͳΒ0,
85. σϝϦοτ
86. σϝϦοτ ▶︎ ύϑΥʔϚϯε௿Լ ▶︎ DBͷετϨʔδѹഭ ▶︎ ωοτϫʔΫΛѹഭ ▶︎ ো֐఺ͷ૿Ճ ▶︎ ͓·͚ɿը૾ΛDB͔Β෼ׂ࣌ͷฐ֐
87. ύϑΥʔϚϯε௿Լ ⾣ը૾σʔλΛϨίʔυʹؚΉ
    ɹˠಡΈॻ͖͢Δσʔλྔ૿Ճ
    σΟεΫ*0͕
    ஗͘ͳΔ
88. %#ͷετϨʔδѹഭ ⾣૝ఆΛ௒͑ͨσʔλ૿Ճ
    ɹˠཁ݅௥Ճ΍ӡ༻ઃܭ΋Ε
    কདྷతʹ
    ετϨʔδΛѹഭ
89. ωοτϫʔΫΛѹഭ ⾣ը૾Λ%#͔Βऔಘ
    ɹˠωοτϫʔΫѹഭ
    8FC%#ؒ
    8FC%#ؒͷϨΠςϯγ͕ߴ͘
    Ϩεϙϯε͕௿Լ
90. ো֐఺ͷ૿Ճ ⾣ը૾ߋ৽ॲཧ͕ෳࡶ
    ɹˠ༨ܭͳ
    ϓϩάϥϜɺ42-
    Λ௨͢
    ো֐఺
    ͕૿͑Δ
91. ⾣੩తϑΝΠϧΛઐ༻αʔόʔ΁
    ɹˠશϨίʔυҠߦɺϑΝΠϧ໊௥Ճ
    ؆୯ʹ෼ׂɺҠಈͰ͖ͣ
    σʔλྔ࣍ୈͰ
    ͕͔͔࣌ؒΔ ʲ͓·͚ʳը૾Λ%#͔Β෼ׂ࣌ͷฐ֐
92. ͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ ࣮ࡍͷॻ͖ࠐΈ଎౓ɾσʔλྔ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ
93. ॻ͖ࠐΈ଎౓ͷ
    ൺֱ
94. ը૾Λ3%#
    WT
    ϑΝΠϧ໊͚ͩ3%#
95. ը૾Λ3%#ͷ৚݅ ⾣ը૾ $ ls -lh gaikan* -rw-r--r-- 1 vagrant vagrant 612K 9݄ 18 17:53 gaikan_01.png -rw-r--r-- 1 vagrant vagrant 27K 9݄ 18 17:51 gaikan_s_01.jpg ⾣*/4&35৚݅
    ɾϝΠϯը૾ɹɹɿ,#
    ຕ
    ɾαϜωΠϧը૾ɿ
    
    ,#
    ຕ
    ɾϨίʔυ*/4&35
96. ը૾Λ3%#ͷ݁Ռ $ php db_img.php ## insert image ..1..2..3..4..5..6..7..8..9..10 total :9.1205940247ඵ avarage:0.9120594025ඵ ⾣݁Ռ
    ɾ
    
    Ϩίʔυॻ͖ࠐΈɿ
    TFD
    ɾϨίʔυॻ͖ࠐΈɿ
    TFD
97. ϑΝΠϧ໊͚ͩ3%#
98. ϑΝΠϧ໊͚ͩ3%#ͷ৚݅ ⾣ը૾ $ pwd /var/www/html/img $ ls -lh ߹ܭ 640K -rw-r--r-- 1 apache apache 612K 10݄ 1 06:34 gaikan_01.png -rw-r--r-- 1 apache apache 27K 10݄ 1 06:34 gaikan_s_01.jpg ⾣*/4&35৚݅
    ɾը૾͸ϑΝΠϧ໊ͷΈ
    ɾϨίʔυ*/4&35
99. ϑΝΠϧ໊͚ͩ3%#ͷ݁Ռ $ php db_img_name.php ## insert image ..1..2..3..4..5..6..7..8..9..10 total :0.0100040436ඵ avarage:0.0010004044ඵ ⾣݁Ռ
    ɾ
    
    Ϩίʔυॻ͖ࠐΈɿ
    TFD
    ɾϨίʔυॻ͖ࠐΈɿ
    TFD
100. ॻ͖ࠐΈ଎౓ͷ
     ൺֱͷ݁Ռ͔Β
     ༰ྔΛݟͯΈΔ
101. ࣮ࡍͷ༰ྔ ⾣ը૾Λ3%# # pwd /var/lib/mysql/mamy_test [root@localhost mamy_test]# ll bukken_*.ibd -rw-r----- 1 mysql mysql 213909504 10݄ 1 06:17 bukken_img.ibd -rw-r----- 1 mysql mysql 98304 10݄ 1 06:58 bukken_name.ibd
102. ࣮ࡍͷ༰ྔ ⾣ը૾Λ3%# # pwd /var/lib/mysql/mamy_test [root@localhost mamy_test]# ll bukken_*.ibd -rw-r----- 1 mysql mysql 213909504 10݄ 1 06:17 bukken_img.ibd -rw-r----- 1 mysql mysql 98304 10݄ 1 06:58 bukken_name.ibd ࠩ͸ྺવ
103. ͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ ࣮ࡍͷॻ͖ࠐΈ଎౓ɾσʔλྔ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ
104. Կ͕ϕετͳͷ͔ ⾣ಛघͳཁ݅
     ͷ৔߹ʹ࢖͏
     ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍
     ⾣ύϑΥʔϚϯεɾίετ
     ɹͱͷτϨʔυΦϑ
     ɹɹˠ։ൃ޻਺ɺӡ༻ίετΛਂ͘ߟྀ
     ⾣ઃܭɾ࣮૷Λ͔ͬ͠Γܭը
     ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍
     ⾣3%#ͷຊདྷͷ੹຿
     Λߟྀ
     ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ
105. ͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ ࣮ࡍͷॻ͖ࠐΈ଎౓ɾσʔλྔ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ
106. γεςϜɾαʔϏε͸
107. ཁ݅ͱϦιʔεͷ
     τϨʔυΦϑ
108. ͋ͪΒΛཱͯΕ͹
     ͪ͜Βཱ͕ͨ͵͕
109. ϝϦοτɾσϝϦοτ
     ಛघύλʔϯΛ
     Α͘ߟ͑ͯ
110. க໋తʹ
     ࠔΒͳ͍Α͏ʹ
111. ӡ༻Λߟ͑ͨ
     ઃܭΛ͠·͠ΐ͏ʂ
112. σʔλͷण໋͸
     ΞϓϦΑΓ௕͍ͧ
113. ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ