.Z42-Ͱը૾Λѻ͏ ϝϦοτɾσϝϦοτͱ ো֐ɾղܾࣄྫ ·Έ΍ͳ͓͖ !NBNZ +VO!QIQDPOGVL

ࣦഊମݧͱ ղܾख๏Λղઆ

ϝϦοτ " σϝϦοτ $

ద੾ʹը૾Λ ѻ͏ํ๏Λ ͓࿩͠͠·͢

͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ

͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ

ࣗݾ঺հ Name ɿ·Έ΍ͳ͓͖ ॴଐɹ ɿInnovator Japan Inc. Twitterɿ@mamy1326ʢ·Έʔʣ - ීஈ͸PHPॻ͍ͯ·͢ - 2017೥1݄ʹॳΊͯmy.cnfΛ৮Δ - 2017೥ MySQL͕झຯ - 2018೥ DNSͱωοτϫʔΫ͕झຯ

ͱ͜ΖͰ Έͳ͞Μ

ը૾Λ3%#ʹ ೖΕͨ͜ͱ ·ͨ͸ʜ

ϓϩδΣΫτܦݧ ͋Γ·͔͢ʁ ڍख✋

΋ͪΖΜʁ ๻΋͋Γ·͢ʂ

௞ି؅ཧγεςϜ ෺݅ը૾Λશ෦ ΧϥϜʹೖΕΔ

ͭΒ͍

͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ

No content

%#͔Β ը૾Λ4&-&$5 ʢ֎؍ɺ಺૷ɺؒऔɺपลʣ

ಥવͷ ͓٬͞·͔Βͷ ͓໰͍߹Θͤ

͋Δ೔ͷ͓໰͍߹Θͤ ☎ɿ෺݅σʔλΞοϓϩʔυͨ͠Βɺ ɹɹը໘͕ਅͬനʹͳΔΜͰ͚͢Ͳ ɿը໘Ωϟϓνϟૹͬͯ௖͍ͯ΋ ɹɹΑΖ͍͠Ͱ͔͢ʁ

͋Δ೔ͷ͓໰͍߹Θͤ ը໘ ਅͬന

͋Δ೔ͷ͓໰͍߹Θͤ ը໘ ਅͬന λΠϜΞ΢τ

࣮ࡍʹى͖ͨτϥϒϧ ⾣େ͖ͳαΠζͷը૾ΛΞοϓϩʔυ ɹˠεϚϗɺσδΧϝαΠζ ⾣ෳ਺ຕΛҰ౓ʹΞοϓϩʔυ ɹˠ෺݅ͷը૾਺͕ଟ͍ ⾣ϦΫΤετ͕ଟൃ ɹˠൟ๩ظʹूதɺෳ਺ళฮͰൃੜ

͸ͯ ςʔϒϧߏ੒ݟΔ͔ʜ

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)

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) ͑ʁ

ςʔϒϧߏ੒ 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=7687528 DEFAULT CHARSET=utf8mb4 1 row in set (0.00 sec)

ςʔϒϧߏ੒ `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) όΠφϦσʔλ อଘ༻ΧϥϜ

ͳΜͱը૾ શ෦3%#ʹ ͋ΔΜͰ͢Αʢ਒͑੠

࣮ࡍͷͱ͜Ζ ͲΜͳ։ൃ͔ͩͬͨ

ཧ૝ʢ։ൃʣͱݱ࣮ʢӡ༻ʣ ͏Μɺେৎ෉ʂ ⾣։ൃ͍ͯͨ͠؀ڥ 8FC %# ։ൃऀ

⾣࣮ࡍͷ؀ڥ 8FC %# ཧ૝ʢ։ൃʣͱݱ࣮ʢӡ༻ʣ

⾣࣮ࡍͷ؀ڥ ❌ ωοτϫʔΫ 8FC %# ཧ૝ʢ։ൃʣͱݱ࣮ʢӡ༻ʣ

⾣࣮ࡍͷ؀ڥ ϓϩηε 8FC %# ❌ ཧ૝ʢ։ൃʣͱݱ࣮ʢӡ༻ʣ

⾣࣮ࡍͷ؀ڥ ❌ λΠϜΞ΢τ 8FC %# ཧ૝ʢ։ൃʣͱݱ࣮ʢӡ༻ʣ

ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ɾେ͖ͳը૾͸Ξοϓ͠ͳ͍ͩΖ͏ ɾ͍ͬ΃ΜʹΞοϓ͠ͳ͍ͩΖ͏ ɾେ੎ͰΞοϓ͠ͳ͍ͩΖ͏ ɾ༰ྔ͸͙͢ʹᷓΕͳ͍ͩΖ͏ ɾ৑௕Խ͠ͳ͍͍ͯͩ͘Ζ͏ ɾࠔͬͨΒεέʔϧΞοϓ͢Ε͹ʁ

ӡ༻Λ૝ఆ͍ͯ͠ͳ͍ ɾେ͖ͳը૾͸Ξοϓ͠ͳ͍ͩΖ͏ ɾ͍ͬ΃ΜʹΞοϓ͠ͳ͍ͩΖ͏ ɾେ੎ͰΞοϓ͠ͳ͍ͩΖ͏ ɾ༰ྔ͸͙͢ʹᷓΕͳ͍ͩΖ͏ ɾ৑௕Խ͠ͳ͍͍ͯͩ͘Ζ͏ ɾࠔͬͨΒεέʔϧΞοϓ͢Ε͹ʁ ❌

Ͱ͸ Ͳ͏΍ͬͯ ղܾ͢Δ͔

ղܾࡦ ⾣ॲཧͰ͖ΔσʔλྔΛ੍ݶ ɹˠׂͱ͙͢ରԠͰ͖Δ͕࢑ఆత ⾣Ϣʔβʔ਺Λ੍ݶ ɹˠαʔϏεͰ͋ΔҎ্೉͍͠ ⾣؂ࢹ͢Δ ɹˠେ੾͕ͩࠜຊղܾͰ͸ͳ͍ ⾣%#ॲཧΛվળ͢Δ ɹˠ໌Β͔ͳωοΫΛࠜຊղܾ

ղܾࡦ ⾣ॲཧͰ͖ΔσʔλྔΛ੍ݶ ɹˠׂͱ͙͢ରԠͰ͖Δ͕࢑ఆత ⾣Ϣʔβʔ਺Λ੍ݶ ɹˠαʔϏεͰ͋ΔҎ্೉͍͠ ⾣؂ࢹ͢Δ ɹˠେ੾͕ͩࠜຊղܾͰ͸ͳ͍ ⾣%#ॲཧΛվળ͢Δ ɹˠ໌Β͔ͳωοΫΛࠜຊղܾ

ࠜຊղܾ·Ͱͷ ಓͷΓ

ࠜຊղܾ·ͰͷಓͷΓ ⾣ը૾Λ3%#͔Β੾Γ཭͢ ⾣3%#΁ͷόΠφϦొ࿥ഇࢭ ⾣׬શҠߦ·Ͱͷ࢓૊ΈߟҊ

ಓͷΓᶃ ⾣ը૾Λ3%#͔Β੾Γ཭͢ ɾը૾ϑΝΠϧ໊Λอଘ͢Δςʔϒϧ༻ҙ ɾ3%#Ҏ֎ʹը૾อଘ͢ΔॲཧΛ௥Ճʢᶄʣ ɾϑΝΠϧ໊Λ3%#ʹอଘ͢Δॲཧ௥Ճ ৽نొ࿥ɾมߋը૾Λ 3%#Ҏ֎ʹ഑ஔ͢Δ४උ

ಓͷΓᶄ ⾣3%#΁ͷόΠφϦొ࿥ॲཧΛഇࢭ ɾը૾อଘϧʔϧΛܾΊΔʢJEJEOBJTPKQHʣ ɾॲཧ੾Γସ͑ͷͨΊϝϯςφϯε ɾ3%#ʹొ࿥͍ͯͨ͠ॲཧΛ׬શʹഇࢭ 3%#Ͱͷ ը૾૿ՃΛఀࢭ

ಓͷΓᶅ ⾣׬શҠߦ·Ͱͷ࢓૊ΈߟҊ ɾ3%#ը૾ΛόονͰετϨʔδ΁ ɾετϨʔδʹແ͚Ε͹3%#͔ΒಡΉ ɾ׬શʹҠߦ͕ऴΘΔ࣌ؒΛܭࢉ ܭըతʹը૾Λ ׬શʹҠߦ

⾣අ༻ͱظ͕ؒ๲େʹ͔͔Δ ⾣αʔϏε͕ఀࢭ͢Δ ⾣ӡ༻ޙͰࣦഊ͕ڐ͞Εͳ͍ ⾣৴༻͕ࣦ௢͢Δ ղܾ·ͰʹΘ͔ͬͨ͜ͱ

͍ͬͨΜղܾ ͔ͨ͠Βͦ͜ ྐʹ͠Α͏ʂ

͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ

ϝϦοτ

ϝϦοτ ▶︎ τϥϯβΫγϣϯͷԸܙ ▶︎ ҉߸ԽͱηΩϡϦςΟ ▶︎ όοΫΞοϓͷू໿ੑ ▶︎ ؂ࠪʢཤྺʣͷ౷߹తͳ࣮૷

τϥϯβΫγϣϯͷԸܙ ⾣ϑΝϯτϜϑΝΠϧͷճආ ɹˠSPMMCBDLͰҰൃͰͳ͔ͬͨ͜ͱʹ ϑΝΠϧͱ%#͕ ಉ͡τϥϯβΫγϣϯͰ੍ޚ

҉߸ԽͱηΩϡϦςΟ ⾣ඇৗʹηϯγςΟϒͳը૾ ɹˠΧϧςʹఴ෇͢Δը૾ͳͲ ҉߸ԽɾηΩϡΞʹ औΓѻ͏

όοΫΞοϓͷू໿ੑ ⾣%#όοΫΞοϓͱಉ࣌ʹ ɹˠը૾΋όοΫΞοϓ͞ΕΔ %#ϦετΞ΍ผγεςϜͱͯ͠ͷ ؀ڥߏஙָ͕

؂ࠪ ཤྺ ͷ౷߹తͳ࣮૷ ⾣ը૾ͷߋ৽ཤྺΛऔΓ͍ͨ ɹˠόʔδϣϯ؅ཧ΋͍ͨ͠ ύϑΥʔϚϯεΛ٘ਜ਼ʹͯ͠΋ ࣮૷͍ͨ͠ͳΒ0,

σϝϦοτ

σϝϦοτ ▶︎ ύϑΥʔϚϯε௿Լ ▶︎ DBͷετϨʔδѹഭ ▶︎ ωοτϫʔΫΛѹഭ ▶︎ ো֐఺ͷ૿Ճ ▶︎ ͓·͚ɿը૾ΛDB͔Β෼ׂ࣌ͷฐ֐

ύϑΥʔϚϯε௿Լ ⾣ը૾σʔλΛϨίʔυʹؚΉ ɹˠಡΈॻ͖͢Δσʔλྔ૿Ճ σΟεΫ*0͕ ஗͘ͳΔ

%#ͷετϨʔδѹഭ ⾣૝ఆΛ௒͑ͨσʔλ૿Ճ ɹˠཁ݅௥Ճ΍ӡ༻ઃܭ΋Ε কདྷతʹ ετϨʔδΛѹഭ

ωοτϫʔΫΛѹഭ ⾣ը૾Λ%#͔Βऔಘ ɹˠωοτϫʔΫѹഭ 8FC%#ؒ 8FC%#ؒͷϨΠςϯγ͕ߴ͘ Ϩεϙϯε͕௿Լ

ো֐఺ͷ૿Ճ ⾣ը૾ߋ৽ॲཧ͕ෳࡶ ɹˠ༨ܭͳϓϩάϥϜɺ42-Λ௨͢ ো֐఺͕૿͑Δ

⾣੩తϑΝΠϧΛઐ༻αʔόʔ΁ ɹˠશϨίʔυҠߦɺϑΝΠϧ໊௥Ճ ؆୯ʹ෼ׂɺҠಈͰ͖ͣ σʔλྔ࣍ୈͰ͕͔͔࣌ؒΔ ʲ͓·͚ʳը૾Λ%#͔Β෼ׂ࣌ͷฐ֐

͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ

Կ͕ϕετͳͷ͔ ⾣ಛघͳཁ݅ͷ৔߹ʹ࢖͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃ޻਺ɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮૷Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷ੹຿Λߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ

͓࿩͢Δ͜ͱ ▶︎ ࣗݾ঺հ ▶︎ τϥϒϧࣄྫͱղܾํ๏ ▶︎ ϝϦοτɾσϝϦοτ ▶︎ Կ͕ϕετͳͷ͔ ▶︎ ͓ΘΓʹ

γεςϜɾαʔϏε͸

ཁ݅ͱϦιʔεͷ τϨʔυΦϑ

͋ͪΒΛཱͯΕ͹ ͪ͜Βཱ͕ͨ͵͕

ϝϦοτɾσϝϦοτ ಛघύλʔϯΛ Α͘ߟ͑ͯ

க໋తʹ ࠔΒͳ͍Α͏ʹ

ӡ༻Λߟ͑ͨ ઃܭΛ͠·͠ΐ͏ʂ

σʔλͷण໋͸ ΞϓϦΑΓ௕͍ͧ

͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ