Mergetable locking

2001-09-10 Thread Stefan Pinkert

How does mysql manage locks on mergetables?

St. Pinkert

-
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




Re: Mergetable locking

2001-09-10 Thread Benjamin Pflugmann

Hi.

On Mon, Sep 10, 2001 at 12:46:01PM +0200, [EMAIL PROTECTED] wrote:
 How does mysql manage locks on mergetables?

As far as I can see, it locks all underlying tables. This may not be
the best, but a reasonable approach, because it doesn't know
beforehand which tables will be involved.

Bye,

Benjamin.


-
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