2019-11-01ãã1ã¶æéã®è¨äºä¸è¦§
é çªã¯å®ãã¾ããããã©ãããããããã§ãããã©ã³ã¶ã¯ã·ã§ã³ãå®è£ ä¸ã§ãã ãã¦ãå æ¥ãã©ã³ã¶ã¯ã·ã§ã³ã®ä¸¦è¡å¶å¾¡ã¢ã«ã´ãªãºã ã§ãããS2PL (Strict Two Phase Lock)ããå®è£ ãã 1 ã®ã§ãããRead ãªãã¬ã¼ã·ã§ã³ã§ã¯ Read Lock ãåã£ãå¾ã«ããã«è§£æ¾â¦
éããã°éãã»ã©è¯ããã©ããããããã§ãããã©ã³ã¶ã¯ã·ã§ã³ãå®è£ ä¸ã§ãã ãã©ã³ã¶ã¯ã·ã§ã³ã®ä¸¦è¡å¦ç㧠S2PL (Strict Two Phase Lock) ã Go ã§å®è£ ãããã¨ãã¦ããã®ã§ãããã©ããã¦ãææ ¼å¯è½ãª Reader Writer Mutex ãå¿ è¦ã«ãªããGithub ã«ããå®â¦
ãã©ã³ã¶ã¯ã·ã§ã³ã¯æ éã«ãã©ãããããããã§ããä»ãã©ã³ã¶ã¯ã·ã§ã³ãå®è£ ãã¦ãã¾ãã ã¿ã¤ãã«ã¯é£ãã§ããMySQL ã®ããã©ã«ãã®ãã©ã³ã¶ã¯ã·ã§ã³åé¢ã¬ãã«ã§ãã REPEATABLE READ ã§ã®è©±ã§ããå¾ã確ããã訳ã§ã¯ãªãã§ãã MySQL ã«éã£ã話ã§ã¯ãªãâ¦
ããã°ã©ãã¼ããããããªã«ãã¨ç¬èªã®ããè¨èªãä½ããã¡ãã©ãããããããã§ãã æ¨æ¥ã11 æ 16 æ¥ã«éå¬ããã WEBã¨ã³ã¸ãã¢åå¼·ä¼ #15 ã® LT 10 åæ ã§ããã¹ããã JSON ã CSV ã«èªåå¤æãã Python ã©ã¤ãã©ãªãä½ã£ããã¨ããã¿ã¤ãã«ã§ç»å£ãã¦â¦
ãã¤ãå¿ã«çã¡ã¢ãªãã©ãããããããã§ããä»æ¥ã¯ã¡ã¢ãªã¢ãã±ã¼ã·ã§ã³ã«ã¤ãã¦ã®ãã¨ã ã綴ãã¾ããããã£ã¨æµãã¦ãã ããã ã¡ãªã¿ã«ãããã§ããçã¡ã¢ãªã¨ã¯ã¡ã¢ãªãµã¤ãºã ãã®è©±ã§ã¯ããã¾ããã ã¡ã¢ãªãã¢ãã±ã¼ãï¼ç¢ºä¿ï¼ããã¨ããããªãã¯ã©ãâ¦