|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
29/08/2007, 07h59
|
#1 |
Messages: n/a
Hébergeur: |
innodb engine status
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 |
|
|
29/08/2007, 09h34
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: innodb engine status
To have a good understanding on the show innodb status output checkout
http://www.mysqlperformanceblog.com/...-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 ful. -- Alex http://alexlurthu.wordpress.com On 8/29/07, Ananda Kumar <anandkl@gmail.com> 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 > |
|
|
|
29/08/2007, 09h46
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: innodb engine status
Thanks a lot Alex.
regards anandkl On 8/29/07, Alex Arul Lurthu <alex.lurthu@gmail.com> wrote: > > To have a good understanding on the show innodb status output checkout http://www.mysqlperformanceblog.com/...-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 ful. > > -- > Alex > http://alexlurthu.wordpress.com > > On 8/29/07, Ananda Kumar <anandkl@gmail.com> 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 > > > > > > > |
|
|
|
29/08/2007, 13h29
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: innodb engine status
Alex Arul Lurthu wrote:
> To have a good understanding on the show innodb status output checkout > http://www.mysqlperformanceblog.com/...-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 ful. A great article. Once you learn what all those things mean, innotop (http://innotop.sourceforge.net/) can monitor them too. Baron |
|
|
 |
| Outils de la discussion | |
|
|
