Show engine innodb status output empty

MySQL & MariaDB Other MySQL® Questions
1

Hi there ,

On DB2 master I’m seeing this very weird problem show engine innodb status command output is totally empty .On other two servers this command is working fine.

on DB2 - No errors in error.log ,mysql version (PS 5.5.28) is same as others db server, db permissions correct , other commands are working fine . Not sure if this problem started after pod move or it was always present since Pod sjh build.

Have anyone seen such problem before ,can yoy please share yr experiences and what’s the cause and fix of this issue.

mysql> show engine innodb status\G;

*************************** 1. row ***************************

Type: InnoDB

Name:

Status:

1 row in set (0.00 sec)

ERROR:

No query specified

Please share yr thoughts .

2

Are you sure your mysql client has no custom pager set before you execute the command? Try “nopager” command before you run “show engine innodb status\G”
Also do the other InnoDB status variables work well? Like can you see the output of this:

show global status like 'innodb%';
3

Thanks Pzemek for replying. With restarting of mysql issue was gone .But there was no “nopager” setting on and all other outputs were working well . I still wonder what was stopping innodb to print innodb status.