Re: innodb engine status

2007-08-29 Thread Baron Schwartz
Alex Arul Lurthu wrote: 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 varia

Re: innodb engine status

2007-08-29 Thread Ananda Kumar
Thanks a lot Alex. regards anandkl On 8/29/07, Alex Arul Lurthu <[EMAIL PROTECTED]> wrote: > > 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 D

Re: innodb engine status

2007-08-29 Thread Alex Arul Lurthu
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. -- Ale

innodb engine status

2007-08-29 Thread Ananda Kumar
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-comm