ããã«ã¡ã¯ãid:shallow1729ã§ããå æ¥ã¯redo logãä¸å¿ã«ã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã«ã¤ãã¦è§£èª¬ãè¡ãã¾ããããä»åã¯åæå®è¡å¶å¾¡ãç¹ã«MySQLãªã©å¤ãã®ãã¼ã¿ãã¼ã¹ã§æ¡ç¨ããã¦ããMultiversion Concurrency Control(MVCC)ã¨ããæè¡ã«ãã©ã¼ã«ã¹ãããã¨æãã¾ãã ä»åã®è¨äºã§ã¯ã¾ãååã§MVCCã¨ãããã®ãã©ããããã®ãã«ã¤ãã¦è§£èª¬ããã¦ã次ã«MVCCã®å®è£ æ¹æ³ã«ã¤ãã¦InnoDBã®å®è£ ãåèã«ããªããè¦ã¦ãããã¨æãã¾ããåæç¥èã¯ãã¾ããããªãã¨æãã¾ããããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã®æä½çµé¨ã¯ãã£ãã»ããããããªã¨æãã¾ããã¾ããååã®ã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã®è§£èª¬ã§è¿°ã¹ãå 容ã¯ãã¾ã説æããªãã®ã§ã軽ãç®ãéãã¦ããããã¨é ã«å ¥ããããããªã¨æãã¾ãã shallow1729.hatenablog.com ãã©ã³ã¶ã¯ã·ã§ã³ã®ååæ§ ã¾ããã©

{{#tags}}- {{label}}
{{/tags}}