Hello, Don't see nothing scary ;)) I just tried such solution (in sinthetic test) and it showed that there's no difference at all - so my proposal was useless, at least in my environment.
2010/5/20 Саша Стаменковић <[email protected]>: > Ugh...too scared to do that. I will try later, after some testing. Thanks! > > Regards, > Saša Stamenković > > > On Thu, May 20, 2010 at 12:08 PM, Aleksey Zapparov <[email protected]> > wrote: >> >> Hello, >> >> Can you check one thing? Looks little bit dummy, but I never worked with >> MySQLi in fact, so just to reveal my unknowlesge ;)) open up file: >> >> Zend/Db/Adapter/Mysqli.php >> >> and replace string (at line 282): >> >> if ($this->_connection) { >> >> with: >> >> if ($this->isConnected()) { >> >> >> 2010/5/20 Саша Стаменковић <[email protected]>: >> > >> > I can have max 15 connections on this shared hosting. >> > Because the connection I use is not persistanrt, but use pooling >> > instead, >> > every query counts as new connection (not sure)? >> > Also, I thought the problem will dissapear when I remove loop, and use >> > IN(ids) approach, but looks like quoteInto() loops something that kills >> > server for each ID in array. >> > Regards, >> > Saša Stamenković >> > >> > >> > On Thu, May 20, 2010 at 12:00 PM, Thomas D. <[email protected]> >> > wrote: >> >> >> >> Hi, >> >> >> >> > [...] >> >> > but I still get similar error: >> >> > >> >> > 2010-05-20T10:08:40+02:00 ERR (3): exception >> >> > 'Zend_Db_Adapter_Mysqli_Exception' >> >> > with message 'User *** already has more than 'max_user_connections' >> >> > active >> >> > connections' in Zend/Db/Adapter/Mysqli.php:333 >> >> > Stack trace: >> >> > #0 Zend/Db/Adapter/Abstract.php(832): >> >> > Zend_Db_Adapter_Mysqli->_connect() >> >> > #1 Zend/Db/Adapter/Abstract.php(902): >> >> > Zend_Db_Adapter_Abstract->quote('582', NULL) >> >> > #2 Zend/Db/Select.php(1000): >> >> > Zend_Db_Adapter_Abstract->quoteInto('table...', '582', NULL) >> >> > #3 Zend/Db/Select.php(475): Zend_Db_Select->_where('table...', '582', >> >> > NULL, true) >> >> > [...] >> >> >> >> I don't think that this problem is related to Zend_Db and/or is caused >> >> by >> >> a loop. >> >> Zend_Db will use the same adapter for every table. So the script should >> >> only have one connection. >> >> >> >> => The problem should have another source. >> >> >> >> >> >> Are you running on a shared host? Have you control over your mysqld? >> >> Then >> >> check your connections using mtop/MySQL Administrator to see what's the >> >> other connections and where they came from. >> >> >> >> At least you should check what's the webservers max. connections. If >> >> your >> >> webserver can handle 1000 connections, but your mysqld allows only 100, >> >> then >> >> there is a configuration mismatch. >> >> >> >> >> >> -- >> >> Regards, >> >> Thomas >> >> >> >> >> > >> > >> >> >> >> -- >> Sincerely yours, >> Aleksey V. Zapparov A.K.A. ixti >> FSF Member #7118 >> Mobile Phone: +34 617 179 344 >> Homepage: http://www.ixti.ru >> JID: [email protected] >> >> *Origin: Happy Hacking! > > -- Sincerely yours, Aleksey V. Zapparov A.K.A. ixti FSF Member #7118 Mobile Phone: +34 617 179 344 Homepage: http://www.ixti.ru JID: [email protected] *Origin: Happy Hacking!
