¤ªÀ¤Ïäˤʤê¤Þ¤¹¡£
 
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£»²¹Í¤Ë¤Ê¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£
¤ä¤Ï¤ê¥Õ¥é¥°¥á¥ó¥È¤òÄêÎÌŪ¤Ëõ¤ëÊýË¡¤Ã¤Æ¤Ê¤¤¤ß¤¿¤¤¤Ç¤¹¤Í¡£
 
¤´»ØŦ¤Î¤È¤ª¤ê¡¢¥½¡¼¥¹¤ò¸«¤¿¤È¤³¤íÆâÉô¤ÇOPTIMIZE TABLE¤ò¸Æ¤ó¤Ç¤Þ¤·¤¿¡£
 
·î¼¡¤¯¤é¤¤¤Çmysqlcheck¤òÁö¤é¤»¤ë¤È¤«¹Í¤¨¤Æ¸«¤Þ¤¹¡£
 
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£


From: ska_king2005@yahoo.co.jp [mailto:ska_king2005@yahoo.co.jp]
Sent: Friday, June 02, 2006 12:01 AM
To: ml@mysql.gr.jp
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!