Hehe, good to know, thanks again. Regards, Saša Stamenković
On Thu, May 20, 2010 at 12:25 PM, Aleksey Zapparov <[email protected]>wrote: > 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! >
