I thought that by using Berkeley tables, concurrent insert/select locks were
based on a page lock. I have seen the same locking with two clients as you
noted in your email. What I thought was happening is that since my tables
are small, I was getting the locking behaviour mentioned because rows in the
insert/select where on the same page. I would very much like to hear if
that is the case.
Rick
-----------------------------------------
/ Rick Mehalick Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone: 281-544-5092(WCK)
/ Fax: 281-544-2646(WCK)
/ email: [EMAIL PROTECTED]
-----------------------------------------
-----Original Message-----
From: Philippe MORIN [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 12:38 AM
To: [EMAIL PROTECTED]
Subject: Tr: Concurrent insert/select with BDB
Hi
I post once more this message, because I didn't receive any answer.
----- Message d'origine -----
De : Philippe MORIN
A : [EMAIL PROTECTED]
Envoye : vendredi 9 fevrier 2001 09:49
Objet : Concurrent insert/select with BDB
Hi
I'm using MySQL 3.23.32 on Linux.
I try to run concurrent insert/select requests on BDB tables, but it doesn't
work.
I started mysqld with --bdb-shared-data option.
I run mysql on 2 clients (on the same computer). The first one runs a select
request and the second one runs an insert request.
If I use autocommit, the insert waits for the end of the select.
If I don't use autocommit, the insert waits for the commit of my first
client.
Did someone ever use concurrent insert/select with BDB databases ?
Are there some special parameters to initialize, to allow insert and select
at the same time (it doens't matter for me if my first client reads
duplicated records).
Thanks a lot !
______________________________________
Philippe Morin - Prologue Software (France)
Software Engineer
Email: [EMAIL PROTECTED]
Internet : http://www.prologue-software.com
___________________________________
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
