[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

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>]