Bug #41195 Please add FAILED status to SHOW PLUGINS or SHOW ENGINES
Submitted: 3 Dec 2008 9:29 Modified: 6 Jan 2011 15:47
Reporter: Mikiya Okuno Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Storage Engine API Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[3 Dec 2008 9:29] Mikiya Okuno
When InnoDB has some problems and fails, we may find InnoDB disappears from SHOW PLUGINS or SHOW ENGINES output. Of course, we can find some information in error log, however it is not intuitive. At least we should see the engine is failed to start by SHOW ENGINES command.

How to repeat:
o shutdown the server
o edit /etc/my.cnf and increase innodb log file size
o start the serve
o then InnoDB fails to start and will disappear from SHOW ENGINES output

Suggested fix:
If we can know that InnoDB fails due to some reasons by SHOW ENGINES or SHOW PLUGINS output, it will ease our lives :)
[3 Oct 2009 20:45] Sveta Smirnova
Thank you for the reasonable feature request.