The FreeBSD Diary

The FreeBSD Diary (TM)

Providing practical examples since 1998

If you buy from Amazon USA, please support us by using this link.
FreeBSD Support
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Newer Topic  |  Older Topic 
 Accessing MySQL through Perl and running concurrent Select statements
Author: Geetika Tewari 
Date:   25-11-02 00:55

I am trying to make my perl script fork several processes that all execute 'select' statements on MySQL. I want the statements to happen concurrently (as I want to monitor the behaviour of MySQL with native ISAM tables under this concurrent Read access). So I am using 'fork'. However, I think my 'select' statements are not happening concurrently. Is there something I am missing?

Reply To This Message
 Re: Accessing MySQL through Perl and running concurrent Select statements
Author: .daniel.schrock 
Date:   25-11-02 01:35

i may be wrong, but i don't think mysql is capable of can fake it by making a separate connection for each statement... but if you are using a single connection, the statements will run sequentially.

Reply To This Message
 Forum List  |  Threaded View   Newer Topic  |  Older Topic 

 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Remember my login:
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
How to get the most out of the forum