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

mysql:11892

From: ¤È¤ß¤¿¤Þ¤µ¤Ò¤í <¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tommy@xxxxxxxxxx>>
Date: Fri, 5 Aug 2005 12:44:24 +0900
Subject: [mysql 11892] Re: REPAIR TABLE ¤Ç¤Î¥¨¥é¡¼¤Ë¤Ä¤¤¤Æ

¤È¤ß¤¿¤Ç¤¹¡£

On Fri, 05 Aug 2005 11:03:06 +0900 (JST)
SUGIMURA Takashi ¿ù¼ µ®»Î <sugimura@xxxxxxxxxx> wrote:

> [¤·¤«¤·ÊÌ¤Ê INDEX ¤òºîÀ®¤·¤è¤¦¤È¤¹¤ë¤È¥¨¥é¡¼]
> 
> 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 ¤¢¤¿¤ê¤Ë̯¤ÊÀ©¸Â¤¬³Ý¤«¤Ã¤Æ¤¤¤ë¤Ã¤Æ¤³¤È¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£

# »ä¤Î´Ä¶­¤Ï Linux ¤Ê¤Î¤Ç limit ¤Î¥Ñ¥é¥á¡¼¥¿Ì¾¤Ï FreeBSD ¤È°Û¤Ê¤ë¤«¤â
# ¤·¤ì¤Þ¤»¤ó¡£

-- 
¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tommy@xxxxxxxxxx>
ÆüËÜMySQL¥æ¡¼¥¶²ñ http://www.mysql.gr.jp

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

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