åç½®ã MySQL 5.1ã§ãInnoDBãªãã¼ã¿ãã¼ã¹ã使ã£ã¦ä½ããéçºãã¦ããæä¸ã«ã¯ããã©ã³ã¶ã¯ã·ã§ã³ãã³ããã(ã¾ãã¯ãã¼ã«ããã¯)ãããåã«ããã°ã©ã å´ã®å¦çã(Fatal errorãªã©ã§)ç°å¸¸çµäºããããã¦ããã©ã³ã¶ã¯ã·ã§ã³ãããã¯ãåå¾ããã¾ã¾æ¾ç½®ç¶æ ã«ãªã£ã¦ãã¾ããã¨ãããããããã(è¬)ã ãããªæãMySQLã®ã³ãã³ãã©ã¤ã³ããæ´æ°ã¯ã¨ãªãçºè¡ããã¨ããã°ããå¾ã«æ¬¡ã®ãããªã¨ã©ã¼ãè¿ã£ã¦ãããã¨ãããã ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction ä¸å¿åèã¾ã§ã«æ¸ãã¦ããã¨ããã®ã¨ã©ã¼ãè¿ã£ã¦ããã¾ã§ã®æéã¯ã次ã®ã³ãã³ãã§ç¥ããã¨ãã§ããã mysql> show global variables like 'innodb_lock_wait_timeout';
{{#tags}}- {{label}}
{{/tags}}