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

images_with_mysql_merit_demerit_and_troubleshooting

51e80cbd34eaaf04af9fdb6d6044196b?s=47 mamy1326_2
October 25, 2017

 images_with_mysql_merit_demerit_and_troubleshooting

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

51e80cbd34eaaf04af9fdb6d6044196b?s=128

mamy1326_2

October 25, 2017
Tweet

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. ͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ ࣮ࡍͷॻ͖ࠐΈ଎౓ɾσʔλྔ ▶︎

    Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ
  33. None
  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. ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ