(1) mysqlÀÇ Å×À̺í Á¡°Ë
CHECK TABLE tbl_name[,tbl_name...] [option [option...]]
(option=QUICK | FAST | MEDIUM | EXTENDED | CHANGED , ±âº»Àº medium)
mysql> check table Å×À̺í¸í;
mysql> check table Å×À̺í¸í quick;
mysql> check table Å×À̺í¸í fast;
mysql> check table Å×À̺í¸í changed;
mysql> check table Å×À̺í¸í extended;
µîµî.. ¿¡·¯°¡ ÀÖÀ¸¸é Msg_text Çʵ忡 ¸Þ¼¼Áö°¡ ³ª¿Â´Ù.
(2) mysql Å×À̺íÀÇ º¹±¸
REPAIR [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name[,tbl_name...] [QUICK] [EXTENDED]
(option=QUICK| EXTENDED)
mysql> repair table Å×À̺í¸í;
mysql> repair table Å×À̺í¸í quick;
mysql> repair table Å×À̺í¸í extended;
µîµî.. À¸·Î º¹±¸°¡ °¡´ÉÇÏ´Ù.
(3) ¶Ç´Ù¸¥ º¹±¸ ¹æ¹ý
- º¹±¸´ë»ó À妽º Å×À̺íÀÌ *.ISM ÆÄÀÏ Çü½ÄÀ̸é isamchk »ç¿ë
- º¹±¸´ë»ó À妽º Å×À̺íÀÌ *.MYI ÆÄÀÏ Çü½ÄÀ̸é myisamchk »ç¿ë
*.MYD : ½ÇÁ¦ µ¥ÀÌÅÍ°¡ ÀúÀåµÇ´Â µ¥ÀÌÅÍÆÄÀÏ
*.MYI : Å×À̺íÀÇ À妽º Á¤º¸¸¦ ÀúÀåÇÏ´Â À妽º ÆÄÀÏ
*.frm : Å×À̺íÀÇ ±¸Á¶°¡ ÀúÀåµÇ´Â ½ºÅ°¸¶ÆÄÀÏ
- ÀÌ»óÀ¯¹« Á¡°Ë ¹æ¹ý
# myisamchk -s /var/lib/mysql/test.MYI //Á¡°Ë°á°ú¸¦ °£·«È÷ Ãâ·Â
# myisamchk -v /var/lib/mysql/test.MYI //Á¡°Ë°á°ú¸¦ »ó¼¼È÷ Ãâ·Â
# myisamchk -i /var/lib/mysql/test.MYI //Á¡°Ë°á°ú¸¦ »ó¼¼È÷ Á¾ÇÕÇÏ¿© Ãâ·Â
- ±úÁø Å×ÀÌºí º¹±¸Çϱâ
# myisamchk -rv /var/lib/mysql/test.MYI //
# myisamchk -o /var/lib/mysql/test.MYI // r¿É¼Çº¸´Ù´Â ¾ÈÀü¸ðµå·Î º¹±¸, ¼Óµµ´Â ´À¸®´Ù
r¿É¼ÇÀ¸·Î º¹±¸ÇÏÁö ¸øÇÏ´Â ³»¿ëµµ º¹±¸ °¡´É
# myisamchk -er ¶Ç´Â -eo /var/lib/mysql/test.MYI // Å×À̺íÀÌ ¿ÏÀüÈ÷ ±úÁø ÃÖÈÄÀÇ º¹±¸¹æ¹ý