Executing concurrent select statements from perl on MySQL ISAM tables(fwd)

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

Executing concurrent select statements from perl on MySQL ISAM tables(fwd)

My previous question raised some follow up questions, so I am going to try to clarify now by explaining the root of my problems: My original (bash) script is the following: ./getTime.pl >> result.txt echo "started: concurrent."

Perl scripts to run concurrent commands on MySQL

Does anyone please have any Perl scripts to execute concurrent SELECT commands on MySQL? Any scripts that do not use fancy libraries would help. Please help. Thanks. - Before posting, please check: http://www.mysql.com/ma

Default MySQL Buffer Cache size

Does anyone please know the default MySQL buffer cache size? I didn't set it while doing a source install and I'm wondering what it is? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Error: Can't lock file

Hi, I am getting the following error while trying to do read-write queries on MySQL. Does anyone know what this error means? The name of the script that generated this error is called randomreadwrite.pl. Can't lock file (errno: 12) at ./randomreadwrite.pl line 54. Thanks very much.

Re: Error: Can't lock file

On Sun, 8 Dec 2002, Paul DuBois wrote: > At 23:09 -0500 12/8/02, Geetika Tewari wrote: > >Hi, > > > >I am getting the following error while trying to do read-write queries on > >MySQL. Does anyone know what this error means? > >The name of the script that ge

Error: Can't lock file

I am getting the following error while trying to do read-write queries on MySQL. Does anyone know what this error means? The name of the script that generated this error is called randomreadwrite.pl. Can't lock file (errno: 12) at ./randomreadwrite.pl line 54. Line 54 does the following: $sth

Increase MySQL Cache Size

Hi: How do you increase the cache size in MySQL? Which parameter should I tweak, and also how do I find out the current default cache size? If there are multiple caches in MySQL, I would welcome suggestions pertaining to all or any of them. Thanks! Geetika ---

Re: Increase MySQL Cache Size

Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 > > - Original Message - > From: "Geetika Tewari" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]&

Using db_stat in MySQL

Hello -- The db_stat utility displays statistics for the Berkeley DB environment variables. I have a version of MySQL that can use Berkeley DB tables. Does anyone know how to use db_stat in MySQL, to get BDB statistics. The db_stat utility can be invoked with "db_stat -h" where the -h flag should

db_stat on BDB tables in MySQL

Hi, does anyone have any experience using db_stat to get statistics on BDB tables in MySQL. How did you go about this please? Thanks. Geetika - Before posting, please check: http://www.mysql.com/manual.php (the manual)