Not the answer you need?
Register and ask your own question!

no innodb status?

mlearymleary EntrantInactive User Role Beginner
I'm having a strange issue:
mysql> show engine innodb status;
Empty set (0.00 sec)

Using Percona 5.6.20-68, this query worked fine last time I ran it (probably on a previous version of percona). I have tried restarting the server and no change, I've also tried a different client (php-mysql). Running 'show global status like 'innodb%';' produces the expected output.

Is this a bug?

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    Can you please provide output of below command and last 50-100 lines of mysql error log please.

    mysql> SHOW ENGINES;
    mysql> SHOW VARIABLES LIKE 'have%';

    May be you have custom pager set already ? It's worth to try "nopager" command before you run "show engine innodb status\G"
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.