mysql:11880
From: SUGIMURA Takashi ¿ù¼ µ®»Î <SUGIMURA Takashi ¿ù¼ µ®»Î <sugimura@xxxxxxxxxx>>
Date: Thu, 04 Aug 2005 17:54:44 +0900 (JST)
Subject: [mysql 11880] REPAIR TABLE ¤Ç¤Î¥¨¥é¡¼¤Ë¤Ä¤¤¤Æ
¿ù¼¤Ç¤¹¡£¤³¤ó¤Ë¤Á¤Ï¡£ ¤Þ¤º¡¢´Ä¶¤Ï¼¡¤ÎÄ̤ê¤Ç¤¹¡£ FreeBSD 5.3-SECURITY Pentium 4 2.8GHz / 1GB RAM / 250GB HDD MySQL 4.1.11 REPAIR TABLE ʸ¤Ç¥¨¥é¡¼¤¬½Ð¤¿¤È¤¤Ë¡¢¤É¤¦Âн褹¤Ù¤¤Ê¤Î¤«¤Ë¤Ä¤¤¤Æ Ǻ¤ó¤Ç¤¤¤Þ¤¹¡£¤³¤Î¥Æ¡¼¥Ö¥ë¤Ï MyISAM ¤Ç¤¹¡£ -------------------------------------------------------------- mysql> REPAIR TABLE XXXXXXXXXXX \G; *************************** 1. row *************************** Table: xxxxxxxxx.XXXXXXXXXXX Op: repair Msg_type: error Msg_text: Not enough memory for blob at 5154540 (need 2603799) *************************** 2. row *************************** Table: xxxxxxxxx.XXXXXXXXXXX Op: repair Msg_type: status Msg_text: Operation failed 2 rows in set (0.84 sec) ERROR: No query specified -------------------------------------------------------------- MySQL ¤òÍî¤È¤·¤Æ myisamchk -o ¤¹¤ì¤ÐÉüµì¤Ï¤·¤Þ¤¹¤¬¡¢ DROP INDEX ¤ä CREATE INDEX ¤¬¸ú¤«¤º¡¢¼Â¼ÁŪ¤Ë¤¢¤Þ¤ê»È¤¨¤Þ¤»¤ó¡£ ¤³¤ì¤À¤±¤Î¾õ¶·¤Ç¤Ï¤è¤¯ÅÁ¤ï¤é¤Ê¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢ ²¿¤«¤ä¤ì¤ë¤³¤È¤¬¤¢¤ê¤Þ¤·¤¿¤é¶µ¤¨¤Æ¤¯¤À¤µ¤¤¡£ Oracle Certified Professional (Gold 9i) ¤Ï»ý¤Ã¤Æ¤Þ¤¹¤Î¤Ç¡¢ Oracle ¤ÎÉüµì¼ê½ç¤Ï°ì±þÍý²ò¤·¤Æ¤¤¤Þ¤¹¡£MySQL ¤Ë¤Ï¤Þ¤À¤¢¤Þ¤ê´·¤ì¤Æ¤¤¤Þ¤»¤ó¡£ ¤è¤í¤·¤¯¤ª¤Í¤¬¤¤¤·¤Þ¤¹¡£ --- ¿ù¼ µ®»Î <sugimura@xxxxxxxxxx> GnuPG fingerprint: C81B 9835 1C9E BD9B 84BF 9785 0B91 D08B F667 DCED
-> 11880 2005-08-04 17:54 [SUGIMURA Takashi ¿ùÂ] REPAIR TABLE ¤Ç¤Î¥¨¥é¡¼¤Ë¤Ä¤¤¤Æ 11885 2005-08-05 10:05 ¨²["T.Sasaki" <papasan2] 11888 2005-08-05 11:03 ¨¨±[SUGIMURA Takashi ¿ùÂ] 11891 2005-08-05 12:44 ¨¡¡¨²["T.Sasaki" <papasan2] 11892 2005-08-05 12:44 ¨¡¡¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 11893 2005-08-05 12:55 ¨¡¡¡¡¨±[SUGIMURA Takashi ¿ùÂ] 11895 2005-08-05 14:04 ¨±[<takeshi@xxxxxxxxxx>]