Memory_leaks. SHOW ENGINE INNODB STATUS; Innodb monitors show information about innodb internal status - which could be used for performance tuning. Lets break down the output of show engine innodb status and get a look at what is happening and how it can be improved. Just fire the "Show engine innodb status" command and check the Output. mysql> show engine innodb status\G*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 091002 9:44:20 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 45 seconds To get a better picture ensure that the output is sampled for some time (say more than 15 seconds - the more the better).
If the sampling time is less, just run the same command again to get another sample. A more explicit output could be (obtained from mysql.com) Oracle: ORA-00054: resource busy and acquire with NOWAIT.