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

mysql:16211

From: Åĸý ¹À <Åĸý ¹À <h-taguchi@xxxxxxxxxx>>
Date: Wed, 25 Feb 2015 15:53:33 +0900
Subject: [mysql 16211] PHP/PDO¤ÇSQL¤Î¼Â¹Ô»þ´Ö¤òÀ©¸Â¤¹¤ëÊýË¡

¢¨¸Ä¿Í¾ðÊóÊݸî¤Î¤¿¤á¡¢°¸Àè¤òÈóɽ¼¨¡Ê£Â£Ã£Ã¡Ë¤Ë¤ÆÁ÷¿®¤·¤Æ¤¤¤Þ¤¹¡£
-----------------------------------------------------

Åĸý¤È¿½¤·¤Þ¤¹¡£
¡ÊBcc°¸¤Æ¤ÇºÑ¤ß¤Þ¤»¤ó¡£¥·¥¹¥Æ¥à¾å¤ÎÀ©¸Â¤Ç¤¹¡Ë

PHP/PDO¤ÇMySQL¤ò»È¤Ã¤Æ¤¤¤Þ¤¹¤¬¡¢Ä¹¤¤»þ´Ö¤¬¤«¤«¤ëSQL¤òÅÓÃæ¤Ç»ß¤á¤ë¤³¤È¤¬¤Ç¤­¤Þ¤»¤ó¡£
¤É¤Ê¤¿¤«¡¢ÊýË¡¤ò¶µ¤¨¤ÆÌ㤨¤Ê¤¤¤Ç¤·¤ç¤¦¤«?

¤ä¤Ã¤¿¤³¤È¡§
­¡PDO::ATTR_TIMEOUT ¤Ç¡¢3ÉäʤÉÀßÄꤹ¤ë¡£
¢ª $dbh->setAttribute(PDO::ATTR_TIMEOUT, 3);¤¬¡¢False¤òÊÖ¤·¡¢ÀßÄê¤Ç¤­¤Ê¤¤¡£
­¢set_time_limit()¤òÀßÄꤹ¤ë¡£
¢ª ¸ú²Ì¤Ê¤·¡£
¢ª set_time_limit¤ÎÀâÌÀ¤Ë¤Ï¡¢°Ê²¼¤¬¤¢¤ê¡¢SQL¼Â¹ÔÃæ¤Ï¤³¤ÎÀßÄê¤Î¸ú²Ì¤¬¤Ê¤µ¤½¤¦¡£
-----------------------------
´Ø¿ô set_time_limit() ¤ÈÀßÄê¥Ç¥£¥ì¥¯¥Æ¥£¥Ö max_execution_time ¤Ï¡¢
¤³¤Î¥¹¥¯¥ê¥×¥È¼«ÂΤμ¹Իþ´Ö¤Ë¤Î¤ß±Æ¶Á¤òÍ¿¤¨¤Þ¤¹¡£ 
system() ¤òÍѤ¤¤¿¥·¥¹¥Æ¥à¥³¡¼¥ë¡¢¥¹¥È¥ê¡¼¥àÁàºî¡¢ ¥Ç¡¼¥¿¥Ù¡¼¥¹¥¯¥¨¥êÅù¤Î
¥¹¥¯¥ê¥×¥È¼Â¹Ô°Ê³°¤ÇȯÀ¸¤¹¤ë½èÍý¤Ë¤«¤«¤Ã¤¿»þ´Ö¤Ï ¥¹¥¯¥ê¥×¥È¤¬¼Â¹Ô¤µ¤ì¤ë
ºÇÂç»þ´Ö¤òÄêµÁ¤¹¤ëºÝ¤Ë¤Ï´Þ¤Þ¤ì¤Þ¤»¤ó¡£ 
¤¿¤À¤·¡¢Windows ¤Ç¤Ï¤³¤ì¤ÏÅö¤Æ¤Ï¤Þ¤ê¤Þ¤»¤ó¡£ 
-----------------------------
¥µ¡¼¥Ð¡¼¥¹¥Ú¥Ã¥¯¡§
RedHat Linux
Apache 2.x
PHP Version 5.3.3
MySQL Client 5.1.73
PDO Driver for MySQL 5.1.73

¡¿Åĸý


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

->   16211 2015-02-25 15:53 [Åĸý ¹À <h-taguchi@x] PHP/PDO¤ÇSQL¤Î¼Â¹Ô»þ´Ö¤òÀ©¸Â¤¹¤ëÊýË¡    
     16212 2015-02-25 16:56 ¨±[Watanabe Tomoyuki <W] RE: [mysql 16211] PHP/PDO¤ÇSQL¤Î¼Â¹Ô»þ´Ö¤òÀ©¸Â¤¹¤ëÊýË¡
     16213 2015-02-25 17:09 ¡¡¨²[<masaki.kuroda@xxxxx]                                     
     16215 2015-02-25 19:43 ¡¡¨­¨±[Åĸý ¹À <h-taguchi@x] RE: [mysql 16213] RE: [mysql 16211] PHP/PDO¤ÇSQL¤Î¼Â¹Ô»þ´Ö¤òÀ©¸Â¤¹¤ëÊýË¡
     16214 2015-02-25 19:40 ¡¡¨±[Åĸý ¹À <h-taguchi@x] RE: [mysql 16212] RE: [mysql 16211] PHP/PDO¤ÇSQL¤Î¼Â¹Ô»þ´Ö¤òÀ©¸Â¤¹¤ëÊýË¡