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¡×¤Î»ØÄê¤Ç½½Ê¬¤À¤È»×¤¤¤Þ¤¹¡£
°Ê¾å¤Ç¤¹¡£Ä¹Ê¸¤Ë¤Ê¤Ã¤Æ¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¡£ ͼ±¼Ô¤ÎÊý¡¹¥Ä¥Ã¥³¥ß¤è¤í¤·¤¯¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£¡£¡£ |