ãã®è¨äºã¯MySQL Casual Advent Calendar 2013 3æ¥ç®ã®è¨äºã§ãã ã¯ãã㫠以åã«SELECT ... FOR UPDATEã¨ããã¯ã®æå - walf443's blogã®è¨äºã«Twitterã§å°ãè¨åãããã§ãããããã®è£è¶³ã¨ããããInnoDBã®ããã¯ã®ç¯å²ã«ã¤ãã¦åã¯ããç解ãã¦ãã¾ããã¨ãã話ã§ãã MySQLã¨ããã°ãInnoDBããããã¯ã¼ã¯ãµã¼ãã¨ãã¦ä½¿ãããã®ãã¬ã¼ã ã¯ã¼ã¯ã§ãããSQLã¯InnoDBã®ã¤ã³ããã¯ã¹ã«ã¢ã¯ã»ã¹ããããã®DSLã¨ãã£ã¦ãéè¨ã§ã¯ãªãã§ãããã InnoDBã®ããã¯ã¨ã¯ã¤ã¾ãã¨ããã¤ã³ããã¯ã¹è¡ã®ããã¯ãªã®ã§ãInnoDBã®ããã¯ã®ç¯å²ãç解ããããã«InnoDBã®ã¤ã³ããã¯ã¹ã«ã¤ãã¦å°ãåç½®ããã¦ããã¾ã(ã ãã¶ç«¯æã£ããã©é·ããªã£ãâ¦)ã ã¯ã©ã¹ã¿ã¤ã³ããã¯ã¹ã¨ã»ã«ã³ããªã¤ã³ããã¯ã¹ ãã§ã«InnoDBã®ã¤ã³
çã¹ãã¼ãã§é§ãä¸ãã£ããæ°ãããã¸ãã¹ãä½ãä¸ãããåä¸é·è ã«ããªã£ãã®ã«ãã©ããã¦ãããªã«ä¸å®ãªãã ããããæ代ã®å¯µå ãã¨æã¦åãããçµå¶è ãã¡ããã®é¡ã«ç¦ãã®è²ã滲ã¿å§ããã 社å¡ã®çµ¦æãé«ãã㦠å æ¬æ¨ãã«ãº(æ±äº¬é½æ¸¯åº)ã®ã°ãªã¼æ¬ç¤¾ã訪ããã¨ãã¨ã¬ãã¼ã¿ã¼ãã¼ã«ããç¶ãã¨ã³ãã©ã³ã¹ã¯ãçã£ç½ãåºèª¿ã¨ããåºã ã¨ããå¾ åã¹ãã¼ã¹ã«ãªã£ã¦ãããæ¥å®¢è ã¯ãã£ããã¨ããç½ãã½ãã¡ã«åº§ã£ã¦ãã¢ãã¤ã³ããåã£ãã°ãªã¼ç¤¾å¡ãããã§å¾ ã¤ãçµè²»ç¯ç´ã®ããã«åä»ã¯ãé»è©±ã ããã¨ããä¼ç¤¾ãå¢ãã¦ããä¸ã«ãã£ã¦ãæ¥æ¬ãããã¯ã©ã¹ã®å®¶è³ãèªãå æ¬æ¨ãã«ãºã§ãæ¥å®¢è ã®ããã«æãã¿ãªãã¹ãã¼ã¹ã使ãæ§ã¯åªé ããæ¼ããã¦ããã æ¥å®¢è ã®ä¸äººãããã®ç©ºéããã¾ãã§å·¨å¤§å®æå£ä½ã®æ½è¨ã®ããã ãã¨èªã£ã¦ããã®ãè³ã«æ®ãããã¾ãã2å¹´åã®2011å¹´ãæ¬èªè¨è ãåæã§ã°ãªã¼ã訪ããæã®ãã¨ã§ããã å½æã対å¿ã«åºã¦ããåºå ±
ã¨ã³ã¸ãã¢ãªã誰ã§ãçªè²«å·¥äºã«åã³ãè¦åºããçµé¨ããããæ·±å¤2æã®å¤é£ãå ±ã«ããååã®ãã¨ã¯ããã®è·æ¥äººçãéãã¦å¿ãããã¨ã¯ãªããããããããã«ãããªããã©ãããããã¨ããçªè²«å·¥äºã¯ä¾å¤ã§ãããããã常æ ã¨ãã¦ã¯ãªããªãã ã¡ã¼ã«ã¼ã®çµè¾¼ã¿ããã°ã©ãã¨ãã¦ã¨ã³ã¸ãã¢ã®ãã£ãªã¢ãã¹ã¿ã¼ãããç§ã¯ãããã製åã¯ããããã»ã¹ããçã¾ããããã¨ãé ã«å©ããã¾ãããç´ æ´ããã製åãçã¿åºãå·¥å ´ã¯éãã§ããã常ã«èª°ãã大声ã§å«ãã§ãããããªå·¥å ´ã«ã¯æããã«ããã»ã¹ä¸ã®åé¡ãèªããããç´ æ´ããã製åãçããã¨ã¯æ±ºãã¦ãªãã æ¬ç©ã®ã¨ã³ã¸ãã¢ã¯çªè²«å·¥äºã好ã¾ãªããçªè²«å·¥äºã¨ã¯ããã»ã¹ä¸ã®èª¤ãã§ãããã¤ã¾ã誰ãã大声ã§å«ã°ãªããã°ãªããªãã¨ãããã¨ã ããã§ãããã¨ã³ã¸ãã¢ã®ä»äºã¯è¨ç»ãããã³ã³ããã¼ã«ããããã®ã§ãªããã°ãªããªãã é·æéå´åã«ãã£ã¦ææãçã¿åºããã¨ãããã¨ãããã¯ãä¾å¤ã¨ããªããã°ãªã
ç©ä¾¡å¤åã®å½±é¿ãé¤ããå®è³ªè³éã®ä½è¿·ãç¶ãã¦ãããåçå´åçã3æ¥çºè¡¨ãã10æã®æ¯æå¤å´çµ±è¨ã«ããã¨ãåç®ã®è³éææ°ãæ¶è²»è ç©ä¾¡ææ°ã§å²ã£ã¦ç®åºããå®è³ªè³éææ°ã¯83.5ã¨ãªããåå¹´åææ¯1.3%ä½ä¸ãããä½ä¸ã¯4ã«æé£ç¶ãæ¯æ°å復ã«ããçç£å¢ãªã©ãèæ¯ã«åç®ã®è³éã¯4ã«æã¶ãã«å¾®å¢ã¨ãªã£ãããç©ä¾¡ã®ä¸ãå¹ ã«ã¯è¿½ãã¤ãã¦ããªãã調æ»ã¯å¾æ¥å¡5人以ä¸ã®äºæ¥æã対象ãåç®ã®ç¾é給ä¸ç·é¡ã¯0.1%
æºå¸¯ã²ã¼ã æ©ããã³ãã³ãã¼ï¼ï¼¤ï¼³ãã§è£¸ãæ®å½±ãããç»åãããåãããããªã©ã®ããããåããã¨ãã¦ãè¨åçå®è°·å¸ã®å°å¦ï¼å¹´ã®ç·å ï¼ï¼ï¼ï¼ãåç´çã®ç·åå ç«¥ã¨ä¸ï¼ã®ç·åçå¾ã®è¨ï¼äººã¨ããããã®è¦ªãç¸æã«ï¼åä¸åã®æå®³è³ åãæ±ãã¦æ°´æ¸å°è£é¾ã±å´æ¯é¨ã«æ訴ãããç·å ã®ä¸¡è¦ªã¨å¼è·å£«ãï¼æ¥ãå¸å ã§è¨è ä¼è¦ãã¦æããã«ãããã訴ç¶ã«ããã¨ãç·å ã¯ï¼æï¼æ¥ãåäººå® ã§è¤æ°ã®åç´çã«ç¡çããå ¨è£¸ã«ããããããï¼ï¼¤ï¼³ã®ã«ã¡ã©æ©è½ã使ã£ã¦ãã®æ§åãåç»ã§æ®å½±ãããããã«ä¸å身ã®åçãæ®ããããåç´çã®ï¼äººããã¤ã³ã¿ã¼ããããéãã¦åçã交æã§ããï¼ï¼¤ï¼³ã®ç¡æã½ããã§ãç·å ã¨å人ï¼äººã«éä¿¡ãï¼æä¸æ¬ã«ãåç´çï¼äººã«ãºãã³ãè±ãããã¦ä¸å身ãæ®å½±ããããªã©ã®ããããåãã¦ããã¨ããããï¼ï¼¤ï¼³ã販売ãã任天å ã¯ãæªæå¹´è ãã®éã§ãããã¤ãªåçãªã©ãããã¨ãããã¦ãããã¨ãåé¡è¦ãããã®ç¡æã½ããã®ãµã¼ãã¹ãï¼ï¼æã«åæ¢
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}