===================================== 700101 20:31:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 39 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 139, signal count 139 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 186, OS waits 86; RW-excl spins 66, OS waits 53 ------------ TRANSACTIONS ------------ Trx id counter 0 9909 Purge done for trx's n:o < 0 9332 undo n:o < 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 107 MySQL thread id 38, query id 31381 localhost root show innodb status ---TRANSACTION 0 3238, not started, OS thread id 83 MySQL thread id 31, query id 5043 localhost root ---TRANSACTION 0 3141, not started, OS thread id 66 MySQL thread id 33, query id 4804 localhost root ---TRANSACTION 0 9908, not started, OS thread id 88 MySQL thread id 28, query id 31373 localhost root ---TRANSACTION 0 2853, not started, OS thread id 44 MySQL thread id 23, query id 4048 localhost root ---TRANSACTION 0 3241, not started, OS thread id 56 MySQL thread id 27, query id 5049 localhost root ---TRANSACTION 0 3240, ACTIVE 1786 sec, OS thread id 114 MySQL thread id 22, query id 5052 localhost root ---TRANSACTION 0 3142, ACTIVE 1788 sec, OS thread id 81 MySQL thread id 32, query id 4819 localhost root
Try committing/aborting these long running transactions, MySQL can't clean up rollback information if you don't.
Jochem
-- I don't get it immigrants don't work and steal our jobs - Loesje
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]