Re: innodb engine status

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  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
>