Bryan, ----- Original Message ----- From: ""Bryan Heitman"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, April 01, 2004 1:53 AM Subject: InnoDB Deadlock cannot find free slot for undo
> Looking for some help on tuning my InnoDB settings. I received a InnoDB > deadlock. > > From analyzing show innodb status --> > * There were a ton of processes in the active status not doing anything. > * The log flushed up to was moving but the last checkpoint at was extremely > old. > > Error in mysql error log scrolling repeatedly: > 16:21:37InnoDB: Warning: cannot find a free slot for an undo log. Do you > have too many active transactions running concurrently? > > version | 4.0.17-standard-log > > current innodb settings > set-variable = innodb_buffer_pool_size=768M > set-variable = innodb_additional_mem_pool_size=20M > set-variable = innodb_log_file_size=256M > set-variable = innodb_log_files_in_group=3 > > Any help would be appreciated. you probably have > 500 open transactions at a time, and InnoDB ran out of undo log slots in the header of its rollback segment. You should commit your transactions. > Best, > > > Bryan Heitman > [EMAIL PROTECTED] Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
