Hello, Can you post (or send my privately) your table classes related to this issue?
2010/5/20 Саша Стаменковић <[email protected]>: > I don't know how to monitor mysqld, maybe get connection from adapter > with getConnection() and then retreive it from there and log? > > Regards, > Saša Stamenković > > > On Thu, May 20, 2010 at 1:25 PM, Thomas D. <[email protected]> wrote: >> >> Hi, >> >> Саша Стаменковић wrote: >> > This error occurs only on one admin page in my project, >> > when I try to iterate over rowset, in each iteration >> > change sth in the row and save it (old version) >> > or I use quoteInto() with array of ids in update query (new version). >> >> Can you monitor the used mysqld? This should really tell you, when and >> where the connections came from. >> At least you should be able to do this, when you run your project in your >> local development system with your own mysqld. >> >> >> > I would like to hear what do you think about switching adapter >> > from MySQLi to PDO and setting 'persistent' => true for db connection >> > in my config file? Will that solve the problem? >> >> I don't think that this will solve your problem. >> >> First, when you are using Zend_Db, I would recommend to use one of the >> native DB connectors, because Zend_Db is already your DB abstraction layer >> so you don't need another one. Read <http://blog.ulf-wendel.de/?p=187> for >> more information. >> >> Secondly, you should understand what persistent connections means: >> When you establish a persistent connection, you tell your mysqld "Do not >> *really* close the connection, if I (the client) close it". So when your >> script comes back and tries to establish a new connection, the mysqld will >> search in the connection pool if there is already an existing free >> connection and pass it back. This will save you time, because the work which >> is needed to establish a vanilla connection isn't required. >> >> A benchmark: >> Using a persistent connection will allow you to establish ~47000 >> connections per second with PHP 5.3 (a real C program like libmysql will >> allow you to establish ~78000 connections) on a test system. >> The same test without persistent connection: PHP is only able to create >> 1816 connections per second and the C program only 1783 connections. >> >> (Source: <http://www.phphatesme.com/blog/mysql/persistente-verbindungen/>) >> >> So using persistent connection might save you time (btw: mysqli supports >> persistent connection since PHP 5.3), but cannot solve your current problem. >> >> This article from 2002 is still actual: >> <http://dev.mysql.com/news-and-events/newsletter/2002-11/a0000000086.html> >> >> >> -- >> 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!
