¿ù¼¤Ç¤¹¡£

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