2009-04-23
¢£[mysql]innodb_log_file_size¤òÊѤ¨¤ë
innodb_log_file_size¤òÊѤ¨¤ë¤È¤¤Ë¤Ï¡¢
http://d.hatena.ne.jp/koziy/20070911/1189472682 ¤Ê¤É¤Ë¤è¤ë¤È¡¢
/var/lib/mysql/ib_logfile0,1¤¢¤¿¤ê¤ò¾Ã¤¹¤È¤«°Üư¤¹¤ë¤È½ñ¤«¤ì¤Æ¤¤¤ë¤¬¡¢
¤Ë¤Ï
WAL¤Ë¤Ï¥Æ¡¼¥Ö¥ë¥¹¥Ú¡¼¥¹¤Ë¤Þ¤ÀÈ¿±Ç¤µ¤ì¤Æ¤¤¤Ê¤¤¥Ç¡¼¥¿¤¬´Þ¤Þ¤ì¤Æ¤¤¤ë¤³¤È¤Ë¤Ê¤ë¡£
¤Ä¤Þ¤ê¡¢InnoDB¤Î¥Ç¡¼¥¿¤Ï¡¢¥Æ¡¼¥Ö¥ë¥¹¥Ú¡¼¥¹¤È¥í¥°¤ò¹ç¤ï¤»¤Æ½é¤á¤Æ¡¢´°Á´¤Ê¾ðÊó¤ò´Þ¤ó¤Ç¤¤¤ë¤Î¤Ç¤¢¤ë¡£¤Ê¤Î¤Ç¤ß¤À¤ê¤Ë¥í¥°¤òºï½ü¤·¤Æ¤Ï¤¤¤±¤Ê¤¤¡£
MySQL ¥µ¡¼¥Ð¤òÉáÄ̤˥·¥ã¥Ã¥È¥À¥¦¥ó¤·¤¿¾ì¹ç¤Ç¤â¡¢WAL¤Ë¤Ï¥Æ¡¼¥Ö¥ë¥¹¥Ú¡¼¥¹¤ËÈ¿±Ç¤µ¤ì¤Æ¤¤¤Ê¤¤¥Ç¡¼¥¿¤¬»Ä¤Ã¤Æ¤¤¤ë¡£
¤È¤¢¤ë¤Î¤Ç¡¢
mysql> SET GLOBAL innodb_fast_shutdown=0;
¤·¤Æ¤«¤é¥·¥ã¥Ã¥È¥À¥¦¥ó¤¹¤ë¤È¤¤¤¦¼ê½ç¤¬É¬Íפ¸¤ã¤Ê¤¤¤«¤È¤ª¤â¤¦¤Î¤À¤¬¤É¤¦¤Ê¤ó¤À¤í¤¦¡£
¥È¥é¥Ã¥¯¥Ð¥Ã¥¯ - http://d.hatena.ne.jp/urekat/20090423/1240473193
¥ê¥ó¥¯¸µ
- 372 http://d.hatena.ne.jp/koziy/20070911/1189472682
- 166 http://blog.flatlabs.net/20100727_212649/
- 32 http://www.google.co.jp/search?hl=ja&client=firefox-a&rls=org.mozilla:ja:official&q=Cannot+find+gem+for+Rails+~>1.2.3.0:&btnG=¸¡º÷&lr=lang_ja
- 30 http://www.google.co.jp/search?q=innodb_log_file_size&lr=lang_ja&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:ja:official&client=firefox-a
- 23 http://hatena-anohito.appspot.com/
- 23 http://www.google.co.jp/search?sourceid=navclient&hl=ja&ie=UTF-8&rlz=1T4ADBR_jaJP322JP322&q=lost+connect+to+mysql
- 15 http://wp.serpere.info/archives/1100
- 14 http://www.google.co.jp/search?q=innodb_log_file_size&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a&as_qdr=y15
- 12 http://search.yahoo.co.jp/search?p=innodb_log_file_size&search.x=1&fr=top_ga1_sa&tid=top_ga1_sa&ei=UTF-8&aq=&oq=
- 12 http://www.google.co.jp/search?hl=ja&q=mysql+innodb_log_file_size&btnG=¸¡º÷&lr=lang_ja
