Perrin Harkins wrote:

>Steve Hay wrote:
>  
>
>>If I switch to mp2 then the Perl interpreter is now multi-threaded, thus 
>>removing the performance bottleneck, which should be great except for 
>>one thing:  All our mp code involves DBI (& DBD-mysql), but DBI is not 
>>thread-safe!
>>    
>>
>
>I thought DBI was thread-safe at this point.  It's more likely 
>DBD::mysql that is not.
>  
>
There are quite possibly problems with DBD-mysql too, but DBI-1.46 pod 
does say:

"Using DBI with perl threads is not yet recommended for production 
environments."

See:  http://search.cpan.org/~timb/DBI-1.46/DBI.pm#Threads_and_Thread_Safety

>  
>
>>Is there a way to configure mp2 to build with a non-threaded Perl, or at 
>>least to run it in such a way as to not make use of the Perl 
>>interpreter's threads, in order to simulate mp1-style behaviour?
>>    
>>
>
>Sure, see 
>http://perl.apache.org/docs/2.0/user/config/config.html#Threads_Mode_Specific_Directives
>
>Just tell it to start a single Perl interpreter, and you will still get 
>apache threads without perl that handle static stuff.
>
>Of course I haven't tried this stuff personally on win32, but you can 
>grab the latest mp2 and try it out yourself.
>
I think this is what Stas was also saying, but thanks for the link.

- Steve


------------------------------------------------
Radan Computational Ltd.

The information contained in this message and any files transmitted with it are 
confidential and intended for the addressee(s) only.  If you have received this 
message in error or there are any problems, please notify the sender 
immediately.  The unauthorized use, disclosure, copying or alteration of this 
message is strictly forbidden.  Note that any views or opinions presented in 
this email are solely those of the author and do not necessarily represent 
those of Radan Computational Ltd.  The recipient(s) of this message should 
check it and any attached files for viruses: Radan Computational will accept no 
liability for any damage caused by any virus transmitted by this email.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to