elainehoo 2008-6-18 15:05:56

LR 处理MYSQL查询超时的方法是怎么样的

LR7.8
apache+php+mysql
ԶǴһбҳ,ݿȡʱѹ
runtimesetting õtimeoutΪֵ
mysql󲢷800ȴʱ30

ﵽһҳ汨contrallerﲢûгִȫͨˣֻӦʱ䳬30룬ﵽ75롣
ڳmysqlȴʱ30LRôأΪʲôûбأ˵Ȼ30룬LRtimeout֮ԻɹֻӦʱ


Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE: General error: 2006 MySQL server has gone away' in /usr/local/php/lib/php/Zend/Db/Statement/Pdo.php:238 Stack trace: #0 /usr/local/php/lib/php/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array) #1 /usr/local/php/lib/php/Zend/Db/Adapter/Abstract.php(408): Zend_Db_Statement->execute(Array) #2 /usr/local/php/lib/php/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query('SELECT id,name,...', Array) #3 /usr/local/php/lib/php/Zend/Db/Adapter/Abstract.php(705): Zend_Db_Adapter_Pdo_Abstract->query('SELECT id,name,...', Array) #4 /srv/www/group2/libs/groupInfo.php(96): Zend_Db_Adapter_Abstract->fetchRow('SELECT id,name,...') #5 /srv/www/group2/libs/Zendex/AclExHelper.php(61): groupInfo->getGroupInfo('create', 0) #6 /usr/local/php/lib/php/Zend/Controller/Action/HelperBroker.php(137): Zendex_AclExHelper->init() #7 /usr/local/php/lib/php/Zend/Controller/Action.php(128): Zend_Controller_Action_HelperBroker->__c in /usr/local/php/lib/php/Zend/Db/Statement/Pdo.php on line 238

elainehoo 2008-6-19 10:59:08

Ϊʲôû˵IJ

elainehoo 2008-6-20 11:05:26

Zee~~~~
ҳ: [1]
鿴汾: LR 处理MYSQL查询超时的方法是怎么样的