Hi. I have quite i buzy MySQL-server running MySQL 3.23.49. The Database has ~100 tables. One of them, here referred to as table_0, is quite buzy.
Turning on the Innodb Monitor gives me the following clue. A lot of transations are listed like this: ---TRANSACTION 0 1029552346, OS thread id 155184269 setting auto-inc lock, active, lock wait, has 1 lock struct(s) MySQL thread id 151538, query id 1612637 xxx.xxxxxxx.com nn.nn.nn.nn database update insert into table_0 (attribute, attribute, attribute) values ( .. ------------------TRX IS WAITING FOR THE LOCK: TABLE LOCK table database/table_0 trx id 0 1029552346 lock_mode AUTO-INC waiting I am not quite sure what this means - my guess would be that there are problems getting a lock on the auto-increment counter in table_0. If so - what could be the cause of this? -- Per Andreas Buer --------------------------------------------------------------------- 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
