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

mysql:11893

From: SUGIMURA Takashi ¿ù¼ µ®»Î <SUGIMURA Takashi ¿ù¼ µ®»Î <sugimura@xxxxxxxxxx>>
Date: Fri, 05 Aug 2005 12:55:15 +0900 (JST)
Subject: [mysql 11893] Re: REPAIR TABLE ¤Ç¤Î¥¨¥é¡¼¤Ë¤Ä¤¤¤Æ

¿ù¼¤Ç¤¹¡£

> > mysql> CREATE INDEX IX_XXXXXXXXXXXXXXXX ON XXXXXXXXXXXXXX (A, B);
> > ERROR 1030 (HY000): Got error 12 from storage engine
> > 
> > % perror 12
> > OS error code  12:  Cannot allocate memory
> > 
> > 
> > ¤É¤Î¥á¥â¥ê¤¬Â­¤ê¤Ê¤«¤Ã¤¿¤Î¤«¤¬¤ï¤«¤ë¤È¤â¤¦¾¯¡¹Äɤ¤¤ä¤¹¤¤¤Î¤Ç¤¹¤¬¡¢
> > ¤Ê¤«¤Ê¤«Æñ¤·¤¤¤È¤³¤í¤Ç¤¹¡£
> 
> limit ¥³¥Þ¥ó¥É¤Çɽ¼¨¤µ¤ì¤ë¥Ñ¥é¥á¡¼¥¿¤Î¡¢datasize stacksize memoryuse
> vmemoryuse ¤¢¤¿¤ê¤Ë̯¤ÊÀ©¸Â¤¬³Ý¤«¤Ã¤Æ¤¤¤ë¤Ã¤Æ¤³¤È¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
> 

¤Ï¤¤¡£¡£¤â¤Á¤í¤ó¸«¤Æ¤¤¤Þ¤¹¡£

----------------
% limit
cputime      unlimited
filesize     unlimited
datasize     524288 kbytes
stacksize    65536 kbytes
coredumpsize unlimited
memoryuse    unlimited
vmemoryuse   unlimited
descriptors  11095
memorylocked unlimited
maxproc      5547
sbsize       unlimited
----------------

datasize ¤ä stacksize ¤òµ¿¤Ã¤Æ¤Ï¤¤¤Þ¤¹¤¬¡¢
¤³¤Îñ°Ì¤Ï kbytes ¤Ç¤¹¤Î¤Ç­¤ê¤Ê¤¯¤Ê¤ë¤È¤Ï¹Í¤¨¤Ë¤¯¤¤¤Ç¤¹¡£

¤¿¤À¡¢¤³¤Î¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ÏÌó400MB¤¢¤ê¤Þ¤¹¤Î¤Ç¡¢
°ìµ¤¤ËÁ´ÂΤòÆɤ߹þ¤ó¤Ç¤·¤Þ¤Ã¤¿¤ê¤¹¤ë¤è¤¦¤Ê¤³¤È¤¬¤â¤·¤¢¤ì¤Ð
­¤ê¤Ê¤¯¤Ê¤ë²ÄǽÀ­¤Ï¤¢¤ë¤«¤È»×¤¤¤Þ¤¹¤¬¡¢¤è¤¯¤ï¤«¤Ã¤Æ¤¤¤Þ¤»¤ó¡£

¤¢¤Þ¤ê»þ´Ö¤Ï¤Ê¤¤¤ó¤Ç¤¹¤±¤ì¤É¤â¡¢
º´¡¹ÌÚ¤µ¤ó¤«¤é¤Î¾ðÊó¤Î sort_get_next_record() ¤â´Þ¤á¤Æ
°ú¤­Â³¤­Ä´¤Ù¤Æ¤ß¤Þ¤¹¡£

# ±¿ÍѤϤ錄¤·¤Î»Å»ö¤¸¤ã¤Ê¤¤¤Î¤Ç¡Ö¤â¤¦ÃΤé¤Ê¤¤¡×¤È¤«
# ¸À¤Ã¤Æ¤·¤Þ¤¤¤¿¤¤¤È¤³¤í¤Ç¤Ï¤¢¤ê¤Þ¤¹(¶ì¾Ð)

---
¿ù¼ µ®»Î <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>]