I found where the problem was!
$newsTable->publishNews($ids);
foreach ($newsTable->fetchNewsByIds($ids) as $news) {
$news->publishOnTwitter();
}
Row have this publish on twitter method, which shouldn't have nothing to do
with the problem - WRONG! It has. When I post it on twitter, a great amount
of traffic is generated, people are opening concrete news and break my limit
of 15 connections.
Looks like I need more connections, heh.
Regards,
Saša Stamenković
On Tue, May 25, 2010 at 10:57 AM, Саша Стаменковић <[email protected]>wrote:
> BTW, my limit is not
>
> mysqli.max_links = 15
>
> its a property of mysql.user table, MAX_USER_CONNECTIONS.
> *
> *
> *http://dev.mysql.com/doc/refman/5.1/en/user-resources.html
> *
> Regards,
> Saša Stamenković
>
>
>
> On Mon, May 24, 2010 at 11:44 PM, Aleksey Zapparov <[email protected]>wrote:
>
>> Hello,
>>
>> Was not able to wait until tomorow to test on FreeBSD as it was really
>> interesting for will it work or not. And it does. Here's mysqli config of
>> my
>> php.ini on FreeBSD:
>>
>> mysqli.max_links = 15
>> mysqli.default_port = 3306
>> mysqli.default_socket =
>> mysqli.default_host =
>> mysqli.default_user =
>> mysqli.default_pw =
>> mysqli.reconnect = Off
>>
>> You can see it's working at: http://sandbox.ixti.ru/zfw/ (it will be
>> available
>> at least until 27th of May 2010).
>>
>>
>> 2010/5/24 Aleksey Zapparov <[email protected]>:
>> > Hello,
>> >
>> > I guess you are doing something wrong. I have just build up a little app
>> from
>> > scratch with zf tool (attachment app.tar.gz) which simply "batch"
>> updates
>> > 32 rows with new status - very dumy logic in controller:
>> >
>> > $news = new Automobili_Model_Table_News();
>> > $ids = range(1,32);
>> >
>> > $news->update(
>> > array('status' => $status),
>> > $news->getAdapter()->quoteInto('id IN (?)', $ids,
>> Zend_Db::INT_TYPE)
>> > );
>> >
>> > And it works good for me at least on my GNU/Linux.
>> > Here's my php.ini (section of MySQLi):
>> >
>> > mysqli.max_persistent = 15
>> > mysqli.allow_persistent = Off
>> > mysqli.max_links = 15
>> > mysqli.cache_size = 2000
>> > mysqli.default_port = 3306
>> > mysqli.default_socket =
>> > mysqli.default_host =
>> > mysqli.default_user =
>> > mysqli.default_pw =
>> > mysqli.reconnect = Off
>> >
>> >
>> > I have a FreeBSD running host so tomorow I'm gonna check this app
>> against
>> > it. Anyway you can try my dummy app by yourself (I've removed some
>> portion
>> > from your News table class (which was referring to another model) to be
>> able
>> > run this code).
>> >
>> > Attached files are:
>> > app.tar.gz - Application itself
>> > dump.sql.gz - MySQL dump of table (I have used to test)
>> >
>> >
>> > 2010/5/24 Саша Стаменковић <[email protected]>:
>> >> Okay, I'm using one connection, one db, one adapter, but still, I have
>> >> problems. I'm pretty sure I'm using it right, because I'm using it like
>> it
>> >> says in the doc.
>> >> The problem is, I can exec up to 15 queries in the row, and this
>> quoteInto
>> >> with array param is hitting my limits.
>> >> I can send you my code on private mail Thomas.
>> >>
>> >> Regards,
>> >> Saša Stamenković
>> >>
>> >>
>> >> On Mon, May 24, 2010 at 9:27 PM, Thomas D. <[email protected]>
>> wrote:
>> >>>
>> >>> Hi,
>> >>>
>> >>> Саша Стаменковић wrote:
>> >>> > Sure, when you have unlimited number of db operation over
>> >>> > a period of time. I'll come up with my own offline quoting.
>> >>>
>> >>> Seems like you are missing one fact all over the time:
>> >>> That quoting would use a connection to a database server, isn't a
>> problem,
>> >>> because Zend_Db_* would use one connection across every component.
>> Only if
>> >>> you are working with multiple databases, it might be a problem,
>> because you
>> >>> would have one adapter per database (=nAdapter * 1 Connection = n
>> >>> connections)...
>> >>>
>> >>> So again:
>> >>> When you are working with just *one* database, everything should work
>> >>> fine.
>> >>> If not, *you* are doing something wrong.
>> >>>
>> >>> Doing your own quoting is everything but not safe. You should use the
>> >>> adapter's escape function, if your application should be safe.
>> >>>
>> >>>
>> >>> --
>> >>> 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!
>>
>
>
