Re: Apache::DBI

2011-08-02 Thread Feng He
Hi, Thank you all for the info. I have finished writting the handler this morning, and have enabled Apache::DBI in httpd.conf. My handler is for this url: http://bizstatus.game.yy.com/upload/ It accept client's uploaded data and write the data to database. The strange stuff is, when I run more t

Re: Sharing variable in threaded mpm not working as expected

2011-08-02 Thread Torsten Förtsch
On Tuesday, 02 August 2011 20:24:46 Fred Moyer wrote: > I haven't used the worker mpm, but it looks like you might want to > preload your handler in the httpd parent process. Unlikely that that will help. threads::shared works by creating a separate perl interpreter to keep the shared values. Tha

Re: Sharing variable in threaded mpm not working as expected

2011-08-02 Thread Pawel Herman
Hello Fred, I already tried the startup.pl file. That didn't help but I can try again. The text you quoted from the docs is familiar to me. That is why I set PerlInterpMax to 1 in my configuration (I want it to block for testing and understanding purposes and intellectual exercise). I initiall

Re: Sharing variable in threaded mpm not working as expected

2011-08-02 Thread Fred Moyer
I haven't used the worker mpm, but it looks like you might want to preload your handler in the httpd parent process. You can do with a startup.pl file. It looks like each thread is initializing a copy of @fruits, which is probably happening at thread creation. However, your current setup will bl

Re: Apache::DBI

2011-08-02 Thread David E. Wheeler
On Aug 2, 2011, at 6:30 AM, Feng He wrote: > I just want to develop a modperl application. > It's a handler, the database is Mysql. > Shall I use Apache::DBI, or DBI is just fine ? I recommend DBIx::Connector. Best, David

Re: Apache::DBI

2011-08-02 Thread Torsten Förtsch
On Tuesday, 02 August 2011 15:30:28 Feng He wrote: > I just want to develop a modperl application. > It's a handler, the database is Mysql. > Shall I use Apache::DBI, or DBI is just fine ? It depends. Apache::DBI provides a transparent connection cache. You can forget the DB handle acquired at so

Apache::DBI

2011-08-02 Thread Feng He
Hi, I just want to develop a modperl application. It's a handler, the database is Mysql. Shall I use Apache::DBI, or DBI is just fine ? Thank u. Regards.

Sharing variable in threaded mpm not working as expected

2011-08-02 Thread Pawel Herman
Hello, I have read all the related documentation (at least those that I found) and I still cannot understand why the little program I wrote below does not share the variable as I would expect. The log file that I created clearly shows that we are running in a single process. Some threads see the