From: Date: August 29 2007 10:34am
Subject: Re: innodb engine status
List-Archive: http://lists.mysql.com/mysql/208773
Message-Id: <e375d990708290134x7ed88504w22180b6a857f46fc@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_973_23954673.1188376474254"

------=_Part_973_23954673.1188376474254
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 <anandkl@stripped> 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
>

------=_Part_973_23954673.1188376474254--