List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 25 2002 5:58pm
Subject:Re: Executing concurrent select statements from perl on MySQL ISAM tables (fwd)
View as plain text  
In the last episode (Nov 25), Geetika Tewari said:
> 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? Thanks.

That should work.  As a test, run two complicated selects, preferably
ones that take a couple seconds to run, then run "show processlist"
from a mysql prompt.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Executing concurrent select statements from perl on MySQL ISAM tables(fwd)Geetika Tewari25 Nov
  • Re: Executing concurrent select statements from perl on MySQL ISAM tables (fwd)Dan Nelson25 Nov
    • Default MySQL Buffer Cache sizeGeetika Tewari30 Nov
      • Re: Default MySQL Buffer Cache sizePeter Brawley30 Nov
  • Re: Executing concurrent select statements from perl on MySQL ISAM tables(fwd)Rodney Broom25 Nov