Title: 네이버 메일
 |
|
|
박찬민 (naracom2002) 님께 보내신 메일 <Re: InnoDB & Replication questions...>
이 다음과 같은 이유로 전송 실패했습니다.
|
| -------------------------------------------- |
|
|
수신자의 메일 보관 용량이 가득차 있습니다. 나중에 다시 시도하십시오.
|
|
| -------------------------------------------- |
|
--- Begin Message ---
On Mon, Jan 21, 2002 at 10:50:10PM +0200, Heikki Tuuri wrote:
>
> this is a known 'feature' which is also mentioned in the
> manual. SHOW TABLE STATUS will set an exclusive lock to the end of
> table to look at the current auto-inc column value, which SHOW TABLE
> STATUS has in its output. Since there is an uncommitted inserted row
> at the end of the table, the exclusive lock must wait, but the next
> insert will wait for the waiting lock (InnoDB uses the next-key
> locking algorithm). That causes a deadlock.
>
> I have to consider making SHOW TABLE STATUS to bypass the
> transactional mechanism when it looks at the auto-inc column value.
That would be very helpful, I think. It's perfectly reasonable to use
SHOW TABLE STATUS to check the amount of space used, etc. while
transactions are running.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 19 days, processed 440,696,926 queries (264/sec. avg)
---------------------------------------------------------------------
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
--- End Message ---
---------------------------------------------------------------------
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
