From MySQL 5.0.18 manual
==================
When accessing the auto-increment counter, InnoDB uses a special table
level AUTO-INC lock that it keeps to the end of the current SQL
statement, not to the end of the transaction. The special lock release
strategy was introduced to improve concurrency for inserts into a table
containing an AUTO_INCREMENT column. Two transactions cannot have the
AUTO-INC lock on the same table simultaneously.
What happened if it exist?... Any idea?
---TRANSACTION 0 461360628, ACTIVE 19 sec, process no 734, OS thread id
3136353728 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 1 lock struct(s), heap size 320
MySQL thread id 28241, query id 13012404 10.1.30.70 root update
INSERT INTO sms_9388_telkomsel.t_outgoing_sms (out_sms_time,
in_sms_time, out_sms_pin_quiz, out_sms_trx_id, in_sms_message_id
, out_sms_dest, out_sms_typePremium, out_sms_msg,
out_sms_typeService_telkomsel,out_sms_quiz_keycode) values (NOW(),NOW(),'92
66715','9266715','9266715','6281356059825','TELKOMSEL_LOVE_2000','LOVE:
Setelah berkencan, jangan lupa untuk menghubunginya k
eesokan hari dan katakan betapa mengesankan pertemuan kemarin dan
berharap bertemu lagi.','2000','LOVE')
------- TRX HAS BEEN WAITING 19 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `sms_9388_telkomsel/t_outgoing_sms` trx id 0 461360628
lock mode AUTO-INC waiting
------------------
---TRANSACTION 0 461360624, ACTIVE 22 sec, process no 734, OS thread id
3133603008 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 1 lock struct(s), heap size 320
MySQL thread id 28227, query id 13012396 10.1.30.70 root update
INSERT INTO sms_9388_telkomsel.t_outgoing_sms (out_sms_time,
in_sms_time, out_sms_pin_quiz, out_sms_trx_id, in_sms_message_id
, out_sms_dest, out_sms_typePremium, out_sms_msg,
out_sms_typeService_telkomsel,out_sms_quiz_keycode) values (NOW(),NOW(),'92
66743','9266743','9266743','6281375092919','TELKOMSEL_LOVE_2000','LOVE:
Setelah berkencan, jangan lupa untuk menghubunginya k
eesokan hari dan katakan betapa mengesankan pertemuan kemarin dan
berharap bertemu lagi.','2000','LOVE')
------- TRX HAS BEEN WAITING 22 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `sms_9388_telkomsel/t_outgoing_sms` trx id 0 461360624
lock mode AUTO-INC waiting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
