To have a good understanding on the show innodb status output checkout http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
One area you can look at is the "LATEST DETECTED DEADLOCK". But in most cases have found calculations on the status variables more helpful. -- Alex http://alexlurthu.wordpress.com On 8/29/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Hi Friends, > > When i do "SHOW INNODB STATUS\G". It gives me details of transaction > happening on INNODB engine. > > Please let me know what all information i should consider from this output > to ensure if everything is fine or there are issue which i should address. > > I am using mysql version "5.0.41-community-log" > > regards > anandkl >