mysql:13042
From: <ska_king2005@xxxxxxxxxx>
Date: Fri, 2 Jun 2006 00:01:25 +0900 (JST)
Subject: [mysql 13042] Re: ¡Ú InnoDB ¡Û¥Õ¥é¥°¥á¥ó¥È¤òÄêÎÌŪ¤ËÃΤëÊýË¡¤Ë¤Ä¤¤¤Æ
ska king ¤Ç¤¹¡£ ¤¢¤¯¤Þ¤Ç¿ä¬¤Ç¤¹¤¬¡¢·ë²Ì¤«¤é¸À¤¦¤È¡ÖInnoDB¤Î¥Õ¥é¥°¥á¥ó¥Æ¡¼¥·¥ç¥ó¾õ¶·¤òÄêÎÌŪ¤ËÃΤëÊýË¡¤Ï¤Ê¤¤¤Î¤Ç¡¢¸å½Ò¤¹¤ëÊýË¡¤ÇÄê´üŪ¤ËInnoDB¤ÎºÇŬ²½¤ò¹Ô¤¦¡×¤·¤«¤Ê¤¤¤Î¤«¤Ê¤È»×¤¤¤Þ¤¹¡£ Äê´üŪ¤È¤¤¤¦¤Î¤Ï¡¢Æü¡¹¤Î¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¿ô¤Ë±þ¤¸¤Æ1¥ö·î/3¥ö·î/6¥ö·îñ°Ì¤Ç¹Ô¤¨¤Ð¤è¤¤¤È»×¤¤¤Þ¤¹¡£ °Ê²¼¤Ï¡¢¼ÁÌä¤ËÂФ·¤Æ¤Î²óÅú¤Ç¤¹¡£¤Û¤È¤ó¤É¿ä¬¤Ç¤¹¤¬¡£ ¡¦1¤Ë¤Ä¤¤¤Æ InnoDB¤Î¥Õ¥é¥°¥á¥ó¥È¾õ¶·¤òÄêÎÌŪ¤ËÃΤëÊýË¡¤Ï̵¤¤¤È»×¤ï¤ì¤Þ¤¹¡£ ¤â¤·¤«¤·¤¿¤é¡¢¡Öshow innodb status¡×¤ä¡Öshow status¡×¥³¥Þ¥ó¥É ¤Ë¥Ò¥ó¥È¤é¤·¤¤â¤Î¤¬¤¢¤ë¤Î¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢±Ñ¸ì¤Ï¤µ¤Ã¤Ñ¤ê¤Ê¤â¤Î¤Ç¡£¡£¡£ ¡¦2¤Ë¤Ä¤¤¤Æ mysqlcheck¥³¥Þ¥ó¥É¤ÏMyISAM·¿¤äBDB·¿¤Î¥Æ¡¼¥Ö¥ë¤ËÂФ·¤Æ¤ÎºÇŬ²½¤Ç¡¢InnoDB·¿¤Ë ÂФ·¤Æ¤Ï»ÈÍѤǤ¤Ê¤«¤Ã¤¿µ¤¤¬¤·¤Þ¤¹¡£ ¿ä¬¤Ç¤¹¤¬¡¢ÆâÉôŪ¤Ë¤Ï¡ÖANALYZE TABLE¡×¤ä¡ÖOPTIMIZE TABLE¡×¤ò¸Æ¤ó¤Ç¤¤¤ë¤Î¤«¤â¤·¤ì¤Þ¤»¤ó¡£ MyISAM·¿¤Ç¤¢¤ì¤Ð¡¢¤³¤Î¥³¥Þ¥ó¥É¤Ç¥¤¥ó¥Ç¥Ã¥¯¥¹¤Î¥½¡¼¥È¤äÅý·×¾ðÊó¤òºÇ¿·¤Ë¤¹¤ë¤Î¤Ç¡¢ ¸¡º÷¸úΨÅù¤ò¥¢¥Ã¥×¤µ¤»¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ InnoDB¤Î¥Õ¥é¥°¥á¥ó¥Æ¡¼¥·¥ç¥ó¤ÎºÇŬ²½¤Ç¤¢¤ì¤Ð¼¡¤ÎÆóÄ̤꤬¤¢¤ê¤Þ¤¹¡£ ¡ mysqldump¥³¥Þ¥ó¥É¤Ç¥Æ¡¼¥Ö¥ë¤òºÆ¹½ÃÛ¤¹¤ëÊýË¡ ¢ ALTER TABLEʸ¤Ç¥Æ¡¼¥Ö¥ëʸ¤òºÆ¹½ÃÛ¤¹¤ëÊýË¡¡£ ¾åµ¤ÎÆóÄ̤ê¤Ç¡¢InnoDB¥Ç¡¼¥¿¥Õ¥¡¥¤¥ëÆâ¤Î¥¤¥ó¥Ç¥Ã¥¯¥¹Îΰè¤È¥Ç¡¼¥¿Îΰè¤òºÇŬ²½¤¹¤ë¤³¤È¤¬¤Ç¤¤ë¤Ï¤º¤Ç¤¹¡£ ¤¤¤º¤ì¤ÎÊýË¡¤â¡¢MySQL¥ê¥Õ¥¡¥ì¥ó¥¹¥Þ¥Ë¥å¥¢¥ë¤Î¡Ö7.5.13.3. InnoDB ¥Æ¡¼¥Ö¥ë¤Î¥Ç¥Õ¥é¥°¥á¥ó¥È²½¡×¤Ëµ½Ò¤µ¤ì¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢»²¾È¤¹¤ë¤³¤È¤ò¤ª´«¤á¤·¤Þ¤¹¡£¤Þ¤¿¡¢»î¤¹Á°¤Ë¤Ïɬ¤º¥Ð¥Ã¥¯¥¢¥Ã¥×¤ò¼èÆÀ¤·¤Æ¤¯¤À¤µ¤¤¡£ ⤷¡¢InnoDB¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¥µ¥¤¥º¤¬¾®¤µ¤¯¤Ê¤ë¤ï¤±¤Ç¤Ï¤Ê¤¤¤Î¤ÇÃí°Õ¤·¤Æ²¼¤µ¤¤¡£ °Ê²¼¤Ï¡¢Á´¤¯¤Î̤¸¡¾ÚÊýË¡¤Ç¡¢±¿ÍÑÃʳ¬¤Ç¤É¤Î¤è¤¦¤ÊÊÀ³²¤¬È¯À¸¤¹¤ë¤«¤ï¤«¤é¤Ê¤¤¤Î¤Ç¡¢¼Â¹Ô¤¹¤ë¾ì¹ç¤Ï½½Ê¬¤Ë¸¡¾Ú¤·¤Æ²¼¤µ¤¤¡£ ¡ ÀßÄê¥Õ¥¡¥¤¥ë¤Î[mysqld]¥»¥¯¥·¥ç¥ó¤Ë¡Öinnodb_file_per_table¡×¥ª¥×¥·¥ç¥ó¤òµ½Ò¤¹¤ë¡£ ¢ Äê´üŪ¤Ëmysqldump¤ò»ÈÍѤ·¤Æ¥Æ¡¼¥Ö¥ëñ°Ì¤ËºÇŬ²½¤ò¹Ô¤¦¡£ ¡¤Ë¤è¤Ã¤Æ¡¢InnoDB¤Î¥Æ¡¼¥Ö¥ëñ°Ì¤Ë¡Ö¥Æ¡¼¥Ö¥ë̾.ibd¡×¤È¤¤¤¦¥Õ¥¡¥¤¥ë¤¬ºîÀ®¤µ¤ì¤Þ¤¹¡£ ¤³¤Î¥Õ¥¡¥¤¥ë¤Ï¡¢MyISAM¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¤¿»þ¤ËÀ¸À®¤µ¤ì¤ë¡ÖMYD¡Ê¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¡Ë¡×¡ÖMYI¡Ê¥¤¥ó¥Ç¥Ã¥¯¥¹¥Õ¥¡¥¤¥ë¡Ë¡×¤ò¹ç¤ï¤»¤¿¤è¤¦¤Ê¥Õ¥¡¥¤¥ë¤Ç¤¹¡£ ¤Ê¤Î¤Ç¡¢¡Ö°ì¤Ä¤ÎInnoDB¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ÎÈîÂç²½¤òËɤ°¤³¤È¤¬¤Ç¤¡¢¥Æ¡¼¥Ö¥ëñ°Ì¤ÇºÇŬ²½¤Ç¤¤ë¡×¤Î¤Ç¤Ï¤Ê¤¤¤«¤È»×¤Ã¤Æ¤¤¤Þ¤¹¡£ ¤¿¤ÀOS¤ÎÀ©¸Â¤Ë¤è¤Ã¤Æ¡¢°ì¤Ä¤ÎInnoDB¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤¬ÈîÂç²½¤¹¤ë¤Î¤òËɤ®¤¿¤¤¤À¤±¤Ç¤¢¤ì¤Ð¡¢¡Öinnodb_data_file_path¡×¤Î»ØÄê¤Ç½½Ê¬¤À¤È»×¤¤¤Þ¤¹¡£ °Ê¾å¤Ç¤¹¡£Ä¹Ê¸¤Ë¤Ê¤Ã¤Æ¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¡£ ͼ±¼Ô¤ÎÊý¡¹¥Ä¥Ã¥³¥ß¤è¤í¤·¤¯¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£¡£¡£ --------------------------------- Let's start Yahoo! Auction - Free Campaign Now!
13036 2006-05-30 19:57 [µ×²¬¡¡½¨»Ê <hisaoka@] ¡ÚInnoDB¡Û¥Õ¥é¥°¥á¥ó¥È¤òÄêÎÌŪ¤ËÃΤëÊýË¡¤Ë¤Ä¤¤¤Æ -> @ 13042 2006-06-02 00:01 ¨±[<ska_king2005@xxxxxx] @ 13080 2006-06-06 09:21 ¡¡¨±[µ×²¬¡¡½¨»Ê <hisaoka@]