mysql »ç¿ëÁß table check ¹× repair
Å×½ºÆ®È¯°æ : CentOS 5.x / Mysql5.0.77
> use DB¸í; (DBÁ¢¼Ó)
> show tables; (º¹±¸ÇÒ Å×À̺í È®ÀÎ)
> lock tables Å×À̺í¸í read; (º¹±¸Çϱâ Àü ÇØ´ç Å×À̺í lockÀ» °É¾î³õ°í Àб⸸ °¡´ÉÇϵµ·Ï ¼³Á¤)
> repair table Å×À̺í¸í; (ÇØ´ç Å×ÀÌºí º¹±¸¸¦ ÁøÇàÇÕ´Ï´Ù. mysql¿¡ Ãß°¡ Á¢¼ÓÇÏ¿© show full processlist;
ÀÔ·ÂÇÏ¿© º¹±¸ »óŸ¦ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù. repair »ç¿ë¹ý¿¡ ´ëÇؼ´Â ¾Æ·¡ºÎºÐÀ» Âü°íÇϽñ⠹ٶø´Ï´Ù.)
> unlock tables; (Á¤»ó º¹±¸µÇ¾úÀ» °æ¿ì ¸ðµç Å×ÀÌºí ¶ôÀ» ÇØÁ¦ÇÕ´Ï´Ù.)
> check table Å×À̺í¸í; (Á¤»óº¹±¸ µÇ¾ú´ÂÁö È®ÀÎÇÕ´Ï´Ù. Msg_test »óÅ°¡ OKÀ̸é Á¤»óó¸®µÈ °ÍÀÔ´Ï´Ù.)
[repair »ç¿ë¹æ¹ý]
repair [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name[,tbl_name...] [QUICK] [EXTENDED]
[¿É¼Ç¼³¸í]
QUICK : À妽º tree¸¸ º¹±¸ÇÕ´Ï´Ù.
EXTENDED : ÇÑÁÙ¾¿ º¹±¸ÇÏ¿© À妽º¸¦ ¸¸µì´Ï´Ù. myisamchk --safe-recover ¸í·É¾î¿Í °°½À´Ï´Ù.
´ÙÀ½°ú°°Àº °æ¿ì repair table ¹®ÀÌ ½ÇÇàµÇÁö ¾Ê½À´Ï´Ù.
- 'Å×À̺í¸í.frm' ÀÌ Àá°ÜÀÖÀ»°æ¿ì (ÀÏ¹Ý »ç¿ëÀÚ ±ÇÇÑÀ¸·Î´Â Ç® ¼ö ¾øÀ¸¸ç root ±ÇÇÑÀ¸·Î Ç®¾î¾ß ÇÕ´Ï´Ù.)
- 'Å×À̺í¸í.MYI' ÆÄÀÏÀÌ ¾ø´Â °æ¿ì (errcode:###)
- ÆÄÀÏÀÇ ³¡À» ¿¹ÃøÇÒ ¼ö ¾ø´Â °æ¿ì
- Record ÆÄÀÏÀÌ ±úÁ³À» °æ¿ì
- table handler·ÎºÎÅÍ ¿¡·¯ ###À» ¹Þ¾ÒÀ» °æ¿ì
repair °á°ú ¸Þ½ÃÁö°¡ OK°¡ ¾Æ´Ñ °æ¿ì myisamchk -o¸¦ »ç¿ëÇÏ¿© º¹±¸ÇØ¾ß ÇÕ´Ï´Ù.
Ãâó : http://smilemoon.kr/90116319492