Hi, Can somebody tell me what the AUOT_INC lock is doing. When my db is experiencing high load I see a lot of these in the INNODB status monitor.
I'm doing a lot of inserts, and from time to time I need to generate some reports that are based on a large amount of data, and then the MySQL server starts locking the inserts. The strange thing it is locking even inserts to tables that are not used in the report. Here is some data from the INNODB monitor ------------------ ---TRANSACTION 2 559663507, ACTIVE 7 sec, process no 27751, OS thread id 120930675 setting auto-inc lock mysql tables in use 1, locked 1 LOCK WAIT 1 lock struct(s), heap size 320 MySQL thread id 25414071, query id 168565699 xx.xx.xx.xx user update INSERT INTO slogs VALUES (NULL,29837,'OK','0.00','100.97','102.12','103.16','N',Now(),0.131011*1000) ------- TRX HAS BEEN WAITING 7 SEC FOR THIS LOCK TO BE GRANTED: TABLE LOCK table `db_name/slogs` trx id 2 559663507 lock mode AUTO-INC waiting -- Dobromir Velev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
