Bug #62074 Ability to add VIEWs in the INFORMATION_SCHEMA
Submitted: 3 Aug 2011 17:02 Modified: 24 Feb 2012 10:55
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[3 Aug 2011 17:02] Federico Razzoli
Description:
I have some VIEWs which extract informations I need from the information_schema - for example sleeping_threads, empty_tables, empty_databases, orphan_triggers...
I created them in an auxiliary database.
But it would be better to have them in the information_schema.

How to repeat:
...
[24 Feb 2012 10:55] Georgi Kodinov
Sorry, but INFORMATION_SCHEMA is a system virtual database and we have no plans of making it a regular database.