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

2大OSSデータベースのMySQLとPostgreSQLの違い(後半)

88f4e84b94fe07cddbd9e6479d689192?s=47 soudai sone
April 02, 2016
Technology
6
3.3k

 2大OSSデータベースのMySQLとPostgreSQLの違い(後半)

第32回 PostgreSQL 勉強会(2015年10月10日)の資料です。
https://www.postgresql.jp/wg/shikumi/pgstudy_32/view

88f4e84b94fe07cddbd9e6479d689192?s=128

soudai sone

April 02, 2016
Tweet

More Decks by soudai sone

See All by soudai sone
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
0
14
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
1
560
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
8
3.5k
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
1
350
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
0
630
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
1
420
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
13
12k
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
5
3.7k
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
2
710

Other Decks in Technology

See All in Technology
E567a535ddc7964130dd086f147a7682?s=48 matoken
0
120
E53046bb9794560f541fcf2cf0b9d526?s=48 sayokomiura
0
540
97d180294474e9df01503148f3b11f39?s=48 lambda
0
350
Dc35998459997f1063eab4194fcb4531?s=48 mars_eu
0
150
4649f3418cb4e7b951ca28e65003c7ac?s=48 sumi
1
490
54bcc1069d75636cc735e72877dd30ec?s=48 taichinakamura
0
750
7975b9fd58c8945ae1c6b38747de7f28?s=48 line_developers_tw2
0
490
462feb0fe0493c40d55650da664e8773?s=48 clustervr
PRO
0
180
79fc33e55cacc42beef647541de24d58?s=48 yasuakiomokawa
1
590
E9a13bad191688bca6cdcf4a12195bb4?s=48 hanakara_milk
0
190
Cb88f765dd38cd942c39aacb5abbea06?s=48 ufoo68
0
210
E10d51de51c08e913216385be87dc1ca?s=48 pongzu
1
270

Featured

See All Featured
6804f1775cb4babfcc3851298566fbce?s=48 tanoku
259
24k
B83d5b590577969ee79a5ad845411a7d?s=48 ammeep
657
54k
Af6a12710770ad9a7cfd08c97efd40d3?s=48 pedronauck
652
110k
95d9f37115fbb0d13135d0f77132f856?s=48 morganepeng
22
1.3k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
120
8k
64827b31aef81498662e8af4bd6d5157?s=48 jonrohan
1021
390k
78b475797a14c84799063c7cd073962f?s=48 holman
462
280k
D09fad3e36ae6841f54820be0e907f7a?s=48 rocio
155
11k
Aebc2d07a50011e2a30d38435fde564a?s=48 jrom
116
7.2k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
56
5.5k
A415db3ac9e9668acbc1fb36eead84ac?s=48 mthomps
40
2.4k
B47b288784fda77a94aeb234ca743c24?s=48 keavy
108
14k

Transcript

  1. 2େOSSσʔλϕʔεͷ MySQLͱPostgreSQLͷҧ͍ (ޙ൒) ୈ32ճ PostgreSQL ษڧձ

  2. What is it? ͜ͷεϥΠυͷ గਖ਼Օॴ ΛؚΊͨϒϩά͸ͪ͜Β IUUQTPVEBJCMPHTQPUKQPTTNZTRMQPTUHSFTRMIUNM

  3. What is it? લ൒ઓΛऴ͑ͯ

  4. What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ

  5. What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ ΠϯυͱΠϯυωγΞ͘Β͍ҧ͏

  6. What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ +BWBͱ+BWB4DSJQU͘Β͍ҧ͏

  7. What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ +BWBͱ+BWB4DSJQU͘Β͍ҧ͏ ྨࣅྫҰཡ ΠϯυͱΠϯυωγΞҧ͏

    ,0'ͷژͱ,0'ͷژ͘Β͍ҧ͏ ετͷϦϡ΢ͱέϯ͘Β͍ҧ͏ ए೫Ֆͱو೫Ֆ͘Β͍ҧ͏ ϙέϞϯͱ༯ո΢Υον͘Β͍ҧ͏ લా݈ଠͱલాஐಙ͘Β͍ҧ͏ ʜͳͲ

  8. What is it? ͭ·Γ͸ಉ͡3%#Ͱ΋݁ߏҧ͏

  9. What is it? Ͱ΋ػೳͷҧ͍͚ͩͰ͸ઓྗͷҧ͍ʹͳΒͳ͍

  10. What is it? Ћͷ෦෼Λ͝঺հ͠·͢

  11. What is it? લఏ৚݅ લ൒ઓͷ࿩Λௌ͍ͯΔ͜ͱ·ͨ͸ݟͯΔ͜ͱ

  12. What is it? લఏ৚݅ ଓɾ1PTUHSF42-ŧŔŕŪƂŜſ

  13. What is it? લఏ৚݅ ଓɾ1PTUHSF42-ŧŔŕŪƂŜſ ˣ ࠷৽൛ͱ͔1PTUHSF42-ͷ᠘ͷ࿩͸ͳ͍Ͱ͢

  14. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  15. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  16. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ̏̌ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿWebΤϯδχΞ ॴଐɿ೔ຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

  17. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ̏̌ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿWebΤϯδχΞ ॴଐɿ೔ຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

  18. தࠃ஍ํDBษڧձ https://dbstudychugoku.github.io/

  19. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  20. ίϛϡχςΟͷҧ͍ ߲໨ίϛϡχςΟ໊ .Z/" +16( ࢀՃํ๏ .-ͷొ࿥ .-ʹొ࿥ਖ਼ձһొ࿥ ૊৫छྨ ༗ࢤʹΑΔϘϥϯςΟΞ /10๏ਓ

    ӡӦࢿۚ ɹແ͠ ༗Γ ίϛϡχέʔγϣϯ πʔϧ .-ɾTMBDL .-ɾTMBDL

  21. ίϛϡχςΟͷҧ͍ ߲໨ίϛϡχςΟ໊ .Z/" +16( ࢀՃํ๏ .-ͷొ࿥ .-ʹొ࿥ਖ਼ձһొ࿥ ૊৫छྨ ༗ࢤʹΑΔϘϥϯςΟΞ /10๏ਓ

    ӡӦࢿۚ ɹແ͠ ༗Γ ίϛϡχέʔγϣϯ πʔϧ .-ɾTMBDL .-ɾTMBDL

  22. ίϛϡχςΟͷҧ͍ ߲໨ίϛϡχςΟ໊ .Z/" +16( ࢀՃํ๏ .-ͷొ࿥ .-ʹొ࿥ਖ਼ձһొ࿥ ૊৫छྨ ༗ࢤʹΑΔϘϥϯςΟΞ /10๏ਓ

    ӡӦࢿۚ ɹແ͠ ༗Γ ίϛϡχέʔγϣϯ πʔϧ .-ɾTMBDL .-ɾTMBDL

  23. ίϛϡχςΟͷҧ͍ ༧ࢉͷ༗ແ w .Z42-Ϣʔβձ͸͓ۚͷ੍໿Λ࡞Βͳ͍ͨΊ ʹ༧ࢉΛ׶͑ͯઃ͚ͯͳ͍ w ೔ຊ1PTUHSFTϢʔβձ͸ڠࢍۚΛूΊɺ/10 ๏ਓͱͯ͠؅ཧ͍ͯ͠Δ

  24. ίϛϡχςΟͷҧ͍ ༧ࢉͷ༗ແ w .Z42-Ϣʔβձ͸͓ۚͷ੍໿Λ࡞Βͳ͍ͨΊ ʹ༧ࢉΛ׶͑ͯઃ͚ͯͳ͍ w ೔ຊ1PTUHSFTϢʔβձ͸ڠࢍۚΛूΊɺ/10 ๏ਓͱͯ͠؅ཧ͍ͯ͠Δ ࠓ೔ͷަ௨අ͸+16(ʹࢧԉͯ͠΋Βͬͯ·͢

  25. ίϛϡχςΟͷҧ͍ ϢʔβձͷΞ΢τϓοτͷҧ͍ w +16(͸υΩϡϝϯτ͸ίϛϡχςΟͰ࡞੒ w .Z/"͸ݸʑͷΞ΢τϓοτʹҕͶΔ
 ެࣜυΩϡϝϯτ͸0SBDMF͕࡞੒ w ษڧձ͸ͲͪΒ΋ਵ࣌ओମͰߦ͍ͬͯΔ

  26. ίϛϡχςΟͷҧ͍ TMBDL͕ؾܰʹ࣭໰Ͱ͖ͯϨεϙϯε΋ྑ͍ .Z42-ɿIUUQNZTRMDBTVBMTMBDLJOIFSPLVBQQDPN 1PTUHSF42-ɿIUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN

  27. ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ

  28. ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ ˣ ࠓ͙͢ϑΥϩʔ͢΂͖ΤϯδχΞϦετ

  29. ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ ˣ ࠓ͙͢ϑΥϩʔ͢΂͖ΤϯδχΞϦετ େମࠓ೔ͷ࿩͸͜ͷਓͨͪΛݟͯΕ͹ࣗવͱ֮͑Δ

  30. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ

  31. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !3,BKJZBNB

  32. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !LBNJQP

  33. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !ZZBNBTBLJ

  34. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !OJQQPOEBOKJ

  35. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !ZPLV

  36. ίϛϡχςΟͷҧ͍ ԶΑΓڧ͍.Z42-ΤϯδχΞʹձ͍ʹߦ͘ ೔ຊ.Z42-Ϣʔβձձʢ.Z/"ձʣಛผฤ Ϣʔβձप೥ه೦ύʔςΟ ʙϢʔβձͱ.Z42-ͷ೥ΛৼΓฦΔʂʙ ։࠵೔෇ɿ೥݄೔ ۚ  ։࠵࣌ࠁɿΛ༧ఆ ձ৔ɿגࣜձࣾίϩϓϥ

    ʢ౦ژɾܙൺणΨʔσϯϓϨΠελϫʔ֊ʣ

  37. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ

  38. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ 1PTUHSF42-ͳਓɺ5XJUUFS࢖ͬͯͳ͍໰୊

  39. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !GVKJJ@NBTBP

  40. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !TOBHB

  41. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !T

  42. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !TBXBEB@NBTBIJLP

  43. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !OPCPSVT

  44. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !OVLP@ZPLPIBNB

  45. ίϛϡχςΟͷҧ͍ 1PTUHSF42-ΧϯϑΝϨϯε ೔࣌ɿ೥݄೔ ۚ ɹʙ ৔ॴɿ"1඼઒ɹ ౦ژ౎ߓ۠ߴྠ౦ٸୈೋϏϧ  ಺༰ɿޕલجௐߨԋΛؚΉߨԋΛ༧ఆ ޕޙτϥοΫʹͯߨԋఔ౓Λ༧ఆɻ

    ΧϯϑΝϨϯεऴྃޙʹ࠙਌ձ͕͋Γ·͢ɻ ࢀՃਓ਺ݟࠐΈɿ໊ ҰൠࢀՃ໊ఔ౓  ࢀՃඅɿ ԁΛ༧ఆ IUUQXXXQPTUHSFTRMKQFWFOUTKQVHQHDPO

  46. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  47. ϋϚϦͲ͜ΖͷTips ͓଴ͨͤ͠·ͨ͠ ຊ೔ͷϝΠϯͰ͢

  48. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ

  49. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ

  50. ϋϚϦͲ͜ΖͷTips 4&-&$5 '30.TBNQMF JE HSPVQ OBNF BHF  ޿ౡ 4POF

      ޿ౡ TPOF   ෱ࢁ TPVEBJ   ෱ࢁ UBLFUPNP 

  51. ᐆດͳGROUP SELECT id, `group`,age FROM sample GROUP BY `group`

  52. ᐆດͳGROUP SELECT id, `group`,age FROM sample GROUP BY `group` HSPVQ͕༧໿ޠͳͷͰAͰғΉ

  53. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ BHF  ޿ౡ   ෱ࢁ

    

  54. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ BHF  ޿ౡ   ෱ࢁ

     6OJRVFͰ͸ແ͍ͷͰԿ͕ग़Δ͔͸Θ͔Βͳ͍

  55. ϋϚϦͲ͜ΖͷTips LBNJQP53"%*5*0/"-

  56. ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP

    BY `group`;

  57. ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP

    BY `group`;

  58. ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP

    BY `group`; .Z42-ͷಠ֦ࣗுΛແޮʹ͢Δ

  59. ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP

    BY `group`; ΋ͪΖΜNZDPOGʹ͔͍ͯ΋ྑ͍

  60. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ w ࢖͑Δͷ͸ͭ

  61. root͸2౓ࢗ͢ ——ΞΧ΢ϯτΛ֬ೝ͢Δ SELECT user , host FROM user;

  62. ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU  SPPU  SPPU MPDBMIPTU

  63. ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU  SPPU  SPPU MPDBMIPTU

    ͦΕͧΕผϢʔβ

  64. ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU  SPPU  SPPU MPDBMIPTU

    ΞΫηεग़དྷΔIPTU

  65. ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU  SPPU  SPPU MPDBMIPTU

    QH@ICB@DPOG૬౰

  66. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ

  67. ᐆດͳ஋ SELECT * FROM sample WHERE name = 'sone'

  68. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ OBNF BHF  ޿ౡ 4POF 

     ޿ౡ TPOF 

  69. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ OBNF BHF  ޿ౡ 4POF 

     ޿ౡ TPOF 

  70. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ OBNF BHF  ޿ౡ 4POF 

     ޿ౡ TPOF  େจࣈখจࣈΛൺֱͯ͠ͳ͍

  71. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ

  72. ϋϚϦͲ͜ΖͷTips τϥϯβΫγϣϯϨϕϧ ෼཭Ϩϕϧ μʔςΟ Ϧʔυ ϑΝδʔ Ϧʔυ ϑΝϯτϜ Ϧʔυ ಡΈऔΓ

    ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P

  73. ϋϚϦͲ͜ΖͷTips τϥϯβΫγϣϯϨϕϧ ෼཭Ϩϕϧ μʔςΟ Ϧʔυ ϑΝδʔ Ϧʔυ ϑΝϯτϜ Ϧʔυ ಡΈऔΓ

    ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P .Z42-ͷσϑΥϧτ

  74. ϋϚϦͲ͜ΖͷTips τϥϯβΫγϣϯϨϕϧ ෼཭Ϩϕϧ μʔςΟ Ϧʔυ ϑΝδʔ Ϧʔυ ϑΝϯτϜ Ϧʔυ ಡΈऔΓ

    ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P 1PTUHSF42-ͷσϑΥϧτ

  75. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫ w .Z42-ͷσϑΥϧτ͸3&1&"5"#-&3&"% w *OOPEC͸ߋ৽ର৅ͷߦ͚ͩΛϩοΫͰ͸ͳ͍ʂ w ༧૝֎ͷϩοΫΛऔಘ͢Δ w ߋ৽ॲཧͳͲͰϩοΫ଴ͪ౳͕ൃੜ͢Δ͜ͱ͕͋Δ

  76. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫ w .Z42-ͷσϑΥϧτ͸3&1&"5"#-&3&"% w *OOPEC͸ߋ৽ର৅ͷߦ͚ͩΛϩοΫͰ͸ͳ͍ʂ w ༧૝֎ͷϩοΫΛऔಘ͢Δ w ߋ৽ॲཧͳͲͰϩοΫ଴ͪ౳͕ൃੜ͢Δ͜ͱ͕͋Δ

  77. ΪϟοϓϩοΫ begin; SELECT * FROM lock_demo WHERE id >= 5

    AND id <= 10 FOR UPDATE; commit;

  78. ΪϟοϓϩοΫ begin; SELECT * FROM lock_demo WHERE id >= 5

    AND id <= 10 FOR UPDATE; commit; ൣғΛࢦఆͯ͠ϩοΫΛऔಘ

  79. ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test');

  80. ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test'); ؒͷۭߦ΁*/4&35

  81. ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test'); ؒͷۭߦ΁*/4&35

    ͜ͷ*/4&35͸଴ͨ͞ΕΔʂʂ

  82. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺ w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ w ൣғ಺ͷۭߦͰ΋ϩοΫ w ۭৼΓͷ4&-&$5'0361%"5&Ͱ΋ϩοΫ w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ

  83. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺ w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ w ൣғ಺ͷۭߦͰ΋ϩοΫ w ۭৼΓͷ4&-&$5'0361%"5&Ͱ΋ϩοΫ w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ

    ؒͷۭߦ΁*/4&35

  84. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺ w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ w ൣғ಺ͷۭߦͰ΋ϩοΫ w ۭৼΓͷ4&-&$5'0361%"5&Ͱ΋ϩοΫ w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ

    8)&3&JEͳͲ͸ةݥ

  85. ϋϚϦͲ͜ΖͷTips ߋʹωΫετΩʔϩοΫ΋͋Δ

  86. ϋϚϦͲ͜ΖͷTips ߋʹωΫετΩʔϩοΫ΋͋Δ ˣ ߋ৽ߦͷલޙͷϩοΫΛऔΔ

  87. ϋϚϦͲ͜ΖͷTips ௕͍ͷͰଓ͖͸8FCͰ !LBNJQP͞ΜͷϒϩάΛҾ༻ *OOP%#ͷϩοΫͷൣғͱωΫετΩʔϩοΫͷ࿩ IUUQCMPHLBNJQPOFUFOUSZ

  88. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  89. MySQL 5.7ͱPostgreSQL 9.5 ྆%#ͷ࠷৽൛

  90. MySQL 5.7ͱPostgreSQL 9.5 ྆%#ͷ࠷৽൛ ˣ ͦΖͦΖਖ਼ࣜ൛͕ग़Δ

  91. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ͷ࿩Λฉ͖ʹདྷͨਓʁ

  92. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ͷ࿩Λฉ͖ʹདྷͨਓʁ ˣ ࢒೦ɺ๯಄Ͱ΋৮Ε·͕ͨ͠આ໌͠·ͤΜ

  93. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-

  94. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42- ˣ ϧʔΫɺʮࣰాͷދͷרͦͷ̐ʯΛ࢖͑ ελʔɾ΢Υʔζݟͨ͜ͱແ͍͚Ͳ

  95. MySQL 5.7ͱPostgreSQL 9.5 ஶऀͷࣰా͞Μ

  96. MySQL 5.7ͱPostgreSQL 9.5 ஶऀͷࣰా͞Μ ˣ ୈճதࠃ஍ํ%#ษڧձJOग़Ӣ   Ͱ1PTUHSF42-ͷ࿩Λͯ͘͠Ε·͢

  97. MySQL 5.7ͱPostgreSQL 9.5 ͋ͱᖒా͞Μ͕1PTUHSF42-ৄ͍͠

  98. MySQL 5.7ͱPostgreSQL 9.5 ͋ͱᖒా͞Μ͕1PTUHSF42-ৄ͍͠ ˣ 1PTUHSF42-৽ػೳ঺հ IUUQXXXTMJEFTIBSFOFUIBEPPQYOUUEBUBQPTUHSFTRMOFXGFBUVSFTOUUEBUB ֆͱ͔͍ͬͺ͍͋ΔͷͰॳ৺ऀʹ΋༏͍͠ࢿྉͱͳ͓ͬͯΓ·͢

  99. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ΧϯϑΝϨϯε ߦͬͨΒ୭͔࿩ͯ͠ΔΑ ʢଟ෼ɺ͖ͬͱɺ.BZCFʣ

  100. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ

  101. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ ˣ தࠃ஍ํ%#ษڧձʹஔ͍ͯ͋ΔΑ IUUQTECTUVEZDIVHPLVHJUIVCJP

  102. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ ˣ தࠃ஍ํ%#ษڧձʹஔ͍ͯ͋ΔΑ IUUQTECTUVEZDIVHPLVHJUIVCJP ͔͠΋ಈը෇͖

  103. MySQL 5.7ͱPostgreSQL 9.5 தࠃ஍ํ%#ษڧձ ୈճ.Z42-ͷ࠷৽ࣄ৘ ֿࢁ͞Μ  ୈճ.Z42-࠷৽ࣄ৘ ֿࢁ͞Μ 

    ୈճ.Z42-3$ొ৔ʂ࣍ͷ.Z42-͸͕͜͜ҧ͏ͬʂ ֿࢁ͞Μ  ୈճ.Z42-։ൃ࠷৽ಈ޲ ࢁ࡚͞Μ  ͦͷதͰ͍͔ͭ͘ϐοΫΞοϓ

  104. MySQL 5.7ͱPostgreSQL 9.5 ιʔείʔυ͕HJUIVCͰެ։͞Εͨ ެࣜϦϙδτϦ IUUQTHJUIVCDPNNZTRM .Z42-ຊମҎ֎ʹ΋໘ന͍΋ͷ͕୔ࢁʂ

  105. MySQL 5.7ͱPostgreSQL 9.5 ߴ଎Խ w ಉҰεΩʔϚ಺Ͱ΋ϚϧνεϨουରԠ w ΦϓςΟϚΠβ͕ΑΓݡ͘ w *OOP%#ʹ೔ຊޠશจݕࡧ͕௥Ճ

    w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ

  106. MySQL 5.7ͱPostgreSQL 9.5 ߴ଎Խ w ಉҰεΩʔϚ಺Ͱ΋ϚϧνεϨουରԠ w ΦϓςΟϚΠβ͕ΑΓݡ͘ w *OOP%#ʹ೔ຊޠશจݕࡧ͕௥Ճ

    w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ

  107. MySQL 5.7ͱPostgreSQL 9.5

  108. MySQL 5.7ͱPostgreSQL 9.5

  109. MySQL 5.7ͱPostgreSQL 9.5 ߴ଎Խ w ಉҰεΩʔϚ಺Ͱ΋ϚϧνεϨουରԠ w ΦϓςΟϚΠβ͕ΑΓݡ͘ w *OOP%#ʹ೔ຊޠશจݕࡧ͕௥Ճ

    w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ ಛʹߴෛՙ͕࣌ૣ͘ͳͬͨ

  110. MySQL 5.7ͱPostgreSQL 9.5 ߴػೳԽ w ΫΤϦɾϦϥΠτɾϓϥάΠϯ w +40/ܕΛαϙʔτ w ϨϓϦέʔγϣϯͷڧԽ

  111. MySQL 5.7ͱPostgreSQL 9.5 ߴػೳԽ w ΫΤϦɾϦϥΠτɾϓϥάΠϯ w +40/ܕΛαϙʔτ w ϨϓϦέʔγϣϯͷڧԽ

    ·ͩ1PTUHSF42-ͷํ͕Ұ೔ͷ௕͕͋Δ

  112. MySQL 5.7ͱPostgreSQL 9.5 ߴػೳԽ w ΫΤϦɾϦϥΠτɾϓϥάΠϯ w +40/ܕΛαϙʔτ w ϨϓϦέʔγϣϯͷڧԽ

    .Z42-ຊମͰࣗಈϑΣΠϧΦʔόʔΛαϙʔτ 1PTUHSF42-ίϛολ༷ɺ·ͩͰ͔͢ʁ

  113. MySQL 5.7ͱPostgreSQL 9.5 ͦͷଞ w 4:4εΩʔϚΛαϙʔτ w 0/-:@'6--@(3061@#: .Z42- ͕σϑΥϧτ

    w ೔Ͱ1BTTXPSEมߋڧ੍͕σϑΥϧτ w ͭͷςʔϒϧʹϚϧντϦΨʔΛαϙʔτ

  114. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-

  115. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42- ˣ ਖ਼౷೿ͳ3%#ΛΑΓ֦ு͍ͯ͘͠ײ͡

  116. MySQL 5.7ͱPostgreSQL 9.5 .Z42-

  117. MySQL 5.7ͱPostgreSQL 9.5 .Z42- ˣ ਖ਼͍͠3%#ͬΆ͘ͳͬͨ ʢͦͷӨڹͰԼҐޓ׵ੑͷແ͍มߋ΋ଟ͍ʣ ݩ͕ΏΔ;Θܥա͗ͨͷͰྑ͍ͱࢥ͏

  118. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42-

  119. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42- ΑΓେن໛ΞʔΩςΫνϟʹಛԽ͍͖ͯͦ͠͏

  120. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42- ΑΓେن໛ΞʔΩςΫνϟʹಛԽ͍͖ͯͦ͠͏ ˣ ϥΠόϧ͸1PTUHSF42-Ͱ͸ͳ͘/042-

  121. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42-

  122. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42- ਖ਼౷೿3%#ͱͯ͠ਐԽ͍͖ͯͦ͠͏

  123. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42- ਖ਼౷೿3%#ͱͯ͠ਐԽ͍͖ͯͦ͠͏ ˣ ϥΠόϧ͸.Z42-Ͱ͸ͳ͘ɺ঎༻%#

  124. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͱ1PTUHSF42-

  125. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͱ1PTUHSF42- ࠓ·Ͱ΋͜Ε͔Β΋ॅΈ෼͚͕ਐΜͰ͍͘

  126. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  127. ·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ

  128. ·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ ˣ ධՁ͕࣠૿͑ͯൃ૝͕޿͕Δ

  129. ·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ ˣ ධՁ͕࣠૿͑ͯൃ૝͕޿͕Δ ˣ ઃܭྗ্͕͕Δ

  130. ·ͱΊ બ୒ࢶ͕૿͑Δ

  131. ·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ

  132. ·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍

  133. ·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍ ࠓޙ΋3%#૚ͷ044ར༻͸૿͑Δ͸ͣ

  134. ·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍ ࠓޙ΋3%#૚ͷ044ར༻͸૿͑Δ͸ͣ %#ΤϯδχΞͷੜ͖࢒ΓઓུͷҰͭ

  135. ·ͱΊ ࠷৽൛ͷௐࠪ

  136. ·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏

  137. ·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏ ˣ ೔ຊޠ৘ใ΋ଟ͍

  138. ·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏ ˣ ೔ຊޠ৘ใ΋ଟ͍ ߴ଎Խ΋ϝϦοτ͕ͩ ࠓࠔͬͯΔࣄΛղܾͯ͘͠ΕΔࣄ΋ଟ͍ ྫɿ1PTUHSF42-ͷ.BSHFจ .Z42-ͷτϦΨʔͳͲ

  139. ·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸

  140. ·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸ ˣ 3%#ͷٕज़ͷण໋͸௕͍

  141. ·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸ ˣ 3%#ͷٕज़ͷण໋͸௕͍ ˣ ϕϯμʔϩοΫΠϯ͞Εͳ͍஌ࣝ͸وॏ

  142. ·ͱΊ σʔλͷण໋͸ίʔυΑΓ௕͍

  143. ·ͱΊ σʔλͷण໋͸ίʔυΑΓ௕͍ ˣ ͔ͩΒͦ͜%#ͷ஌ࣝ͸େ੾Ͱ͢

  144. ·ͱΊ %#ͷʮ͜Ε஌Βͳ͔ͬͨʯ

  145. ·ͱΊ %#ͷʮ͜Ε஌Βͳ͔ͬͨʯ ˣ க໋ইʹͳΔ͜ͱ΋ଟ͍

  146. ·ͱΊ ීஈ͔Βͷ஌ࣝͷΞοϓσʔτΛେ੾ʹ

  147. ·ͱΊ ීஈ͔Βͷ஌ࣝͷΞοϓσʔτΛେ੾ʹ ˣ ൺֱ͢Δ͜ͱͰؔ࿈෇͚ͨ͠هԱʹͳΔ

  148. ·ͱΊ ٕज़͸ෳ਺ֶͼ·͠ΐ͏

  149. ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ