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

mysql:4125

From: Tatsuhiko Miyagawa <Tatsuhiko Miyagawa <miyagawa@xxxxxxxxxx>>
Date: Fri, 03 Aug 2001 06:22:37 +0900
Subject: [mysql 04125] Re: ¥á¥â¥ê¤ÎÀáÌóÊýË¡

µÜÀî¤Ç¤¹¡£¤³¤ó¤Ë¤Á¤Ï¡£

On Fri, 03 Aug 2001 03:05:18 +0900
moeru@xxxxxxxxxx (moeru) wrote:

 > ¥á¥â¥ê¤ÎÀáÌóÊýË¡¤Ë¤Ä¤¤¤Æ¤Î¼ÁÌä¤Ç¤¹¡£

¤³¤¦¤¤¤Ã¤¿¼ÁÌä¤Î¾ì¹ç¡¢OS ¤ä mysql ¤Î¥Ð¡¼¥¸¥ç¥ó¤ò¤«¤«¤ì¤¿¤Û¤¦¤¬¤è¤¤
¤«¤È»×¤¤¤Þ¤¹¡£
 

> ¸½ºß£Ô£Ï£Ð¥³¥Þ¥ó¥É¤ò¸«¤ë¤È°Ê²¼¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£(°ìÉô)
> 
> Mem:  1036268K av, 657196K used, 379072K free, 122856K shrd, 365396K buff
> Swap: 265032K av,      0K used, 265032K free                177792K cached
> 
>   PID USER     PRI  NI  SIZE  RSS SHARE STAT  LIB %CPU %MEM   TIME COMMAND
> 19124 root      19   0 31272  30M  1304 S       0  5.5  3.0   0:00 mysqld

´Ø·¸¤Ê¤¤¤Î¤Ç¤¹¤¬¡¢mysqld ¤ò root ¤ÇÆ°¤«¤¹¤Î¤Ï¤¢¤Þ¤ê¤è¤í¤·¤¯¤Ê¤¤¤È
¤ª¤â¤¤¤Þ¤¹¡£mysql ¥æ¡¼¥¶¤ÇÆ°¤«¤¹¤³¤È¤ò¥ª¥¹¥¹¥á¤·¤Þ¤¹¡Êsafe_mysqld
--user=mysql)
 
> ­¢PHP¤Ç¥×¥í¥°¥é¥à¤òºî¤Ã¤Æ¤¤¤Þ¤¹¡£
>   mysql_free_result($result);¡¡
> ¡¡¤òºÇ¶áÆþ¤ì¤Þ¤¯¤Ã¤Æ¤Þ¤¹¤¬¥á¥â¥ê»ÈÍÑÎ̤ϸº¤Ã¤Æ¤¯¤ì¤Þ¤»¤ó¡£

PHP¤Ë¾Ü¤·¤¯¤Ê¤¤¤Î¤Ç¤Ï¤º¤·¤Æ¤¤¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢¾åµ­¤ÏPHP¤Î¥á¥â¥ê
¤ò²òÊü¤¹¤ë¤ó¤Ç¤¢¤Ã¤Æ¡¢mysqld ¤Ë¤Ï´Ø·¸¤Ê¤¤¤È¤¤¤¦¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¤«¡©
 
> ­£MySQL¤Î¥Á¥å¡¼¥Ë¥ó¥°(¥·¥¹¥Æ¥àÊÑ¿ô)¤Ë¤Ä¤¤¤Æ¤Ï¡¢
> ¡¡¤Û¤Ü¥Ç¥Õ¥©¥ë¥È¤«£²ÇÜÃͤ¯¤é¤¤¤Ç¤¹¡£
> ¡¡¥·¥¹¥Æ¥àÊÑ¿ô¤ò¤¤¤¸¤ë¤È¥á¥â¥ê¤òÀáÌó¤Ç¤­¤ë¤è¤¦¤Ê½ê¤¬¤¢¤ë¤Ç¤·¤ç¤¦¤«¡©

¶ñÂÎŪ¤Ë¤É¤¦¤¤¤Ã¤¿¿ôÃͤʤΤ«¤ò½Ð¤·¤¿Êý¤¬Ïä¬Áᤤ¤«¤È»×¤¤¤Þ¤¹¡£

FLUSH TABLES (mysqladmin flush-tables) ¤ò¤«¤±¤ë¤È¡¢¤¿¤Þ¤Ã¤Æ¤ëʬ¤ò 
flush ¤¹¤ë¤Î¤Ç¡¢¥á¥â¥ê»ÈÍÑÎ̤ϼ㴳¤ª¤µ¤Þ¤ë¤è¤¦¤Ç¤¹¡£



--
Tatsuhiko Miyagawa                mod_perl Mailing List   
mailto:miyagawa@xxxxxxxxxx   http://bulknews.net/lib/ml/


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

      4123 2001-08-03 03:05 [<moeru@xxxxxxxxxx>  ] ¥á¥â¥ê¤ÎÀáÌóÊýË¡                        
->    4125 2001-08-03 06:22 ¨±[Tatsuhiko Miyagawa <]                                       
      4138 2001-08-03 20:36 ¡¡¨±[<moeru@xxxxxxxxxx>  ]                                     
      4140 2001-08-04 07:03 ¡¡¡¡¨±[Tatsuhiko Miyagawa <]