SHOW ENGINE INNODB STATUS output filled by deadlock output

[Evgeniy Stepchenko]

There is a bug
http://bugs.mysql.com/bug.php?id=19825

Which manifests itself by truncating the output of 'SHOW ENGINE INNODB
STATUS' because the deadlock output is to large.

This causes problems because our cacti templates are relying on that
information to graph innodb activity.

Baron actually suggested in the bug report why not move that section to
the end. Is there any chance we could do something about this in the
Percona patched versions.

[Evgeniy Stepchenko (evgeny-stepchenko)]

Yasufumi, please investigate this issue and propose solution

[Yasufumi Kinoshita (yasufumi-kinoshita)]

I think it is not good to move the section to the end of 'SHOW INNODB STATUS'.
If do so, the important data will be scrolled out by the large output of the end section....

[Vadim Tkachenko (vadim-tk)]

Yasufumi, if it is not at the end of 'SHOW INNODB STATUS', then important data may not appear at all in output, as it will be truncated to 64K

[Evgeniy Stepchenko (evgeny-stepchenko)]

it was fixed in the initial XtraDB release

[Yasufumi Kinoshita (yasufumi-kinoshita)]

I will fix as the current XtraDB does.